Answer / guest

You can use the DTS object model to programmatically create,
modify and run DTS packages.
You can do this many ways, but essentially this object model
has objects for anything you can do in DTS.
If you already have the package created and saved as a file,
add a reference to the DTS Library.
Then you can call it like this:

Dim Package As New DTS.Package

Package.LoadFromStorageFile App.Path "\DTSPackage.dts"
Package.Execute

What is “asynchronous” communication in sql server service broker?

0 Answers  

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

What is a bit datatype?

0 Answers  

---

What are the different acid properties?

0 Answers  

---

How do you send email on SQL Server?

0 Answers   MindCracker,

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

What is in place upgrade in sql server?

0 Answers  

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---