[dba-SQLServer] Calling DTS from SP

Jim Lawrence accessd at shaw.ca
Thu Sep 15 14:18:13 CDT 2005


Hi All:

I have another simple question to ask... though it may not be.

I have a number of DTS packages which have been used to import data from a
client's old DB application into some interim tables. Then a group of SPs,
build a new set of tables, extract the data from the raw imported and then
keys/index and relationships are added. I can even automate the legacies'
database export processes but...

How do I call a DTS package from a SP? (sample code?....)

TIA
Jim      




More information about the dba-SQLServer mailing list