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

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

---

Explain stored procedure?

0 Answers  

---

Define outer join?

0 Answers  

---

What is indexing and its types?

0 Answers  

---

---

Which command is used for user defined error messages?

0 Answers  

---

What are the main control-of-flow T-SQL constructs?

1 Answers  

---

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

How can you find out how many rows returned in a cursor?

0 Answers  

---

What is merge statement?

0 Answers  

---