[dba-SQLServer] Calling DTS from SP

Jim Lawrence accessd at shaw.ca
Thu Sep 15 15:42:29 CDT 2005


Thank you Ron. 

I have been using the xp_cmdshell for running the external DB export
routines but was hoping there might be a more sophisticated method for
running MS SQL internal DTS objects..:-(

Jim  

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Ron Moore
Sent: Thursday, September 15, 2005 12:31 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Calling DTS from SP

Jim, you can either use xp_cmdshell with dtsrun or the sp_OAmethod to do
it using automation.  I did not have success when trying the second
method (meaning, I did not persevere).  Sorry I don't have time to dig
for code.  You can probably google these approaches and find some code.

HTH
Regards,
Ron Moore

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence
Sent: Thursday, September 15, 2005 3:18 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Calling DTS from SP

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      

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list