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

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

---

How is a full-text index updated?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

Explain difference between cross join and full outer join?

0 Answers  

---

What do you understand by the analysis services in sql server?

0 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

Explain DBCC?

0 Answers   QuestPond,

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

Explain what is public role in sql server?

0 Answers  

---

What is a domain constraint give an example?

0 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---

How to find 6th highest salary from Employee table ?

10 Answers  

---