Ron Moore
ron.moore at comtechpst.com
Thu Sep 15 15:58:59 CDT 2005
One last thought, Jim, If you can run those stored procedures from a DTS package to begin with, then you can simply call another DTS sub package based on failure/completion/success workflow precedence. Ron -----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 4:42 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Calling DTS from SP 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com