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 microsoft sql server?

0 Answers  

---

Can I delete event logs?

0 Answers  

---

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

---

What is an extended Stored Procedure?

1 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

What is pivot and unpivot?

0 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

What are the differences between ms sql server & oracle?

0 Answers  

---

What is lookup override?

0 Answers   Informatica,

---

explain query execution plan

1 Answers  

---

Why is the need for data conversion transformations?

0 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---