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 difference between Triggers and store procedure?

2 Answers  

---

How to know whether our backup is succesfully taken?

1 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

---

How to declare and use cursor variables?

0 Answers  

---

Write query to return all rows sql?

0 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

Different Types of Functions ?

2 Answers   Satyam,

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

Does group by sort data?

0 Answers  

---

What is Transparent Data Encryption?

0 Answers  

---