chaithu559
SSCommitted
Points: 1574
More actions
August 21, 2010 at 3:24 am
#239304
Please help me out in calling package from stored procedure in sql server 2008
Koen Verbeeck
SSC Guru
Points: 259115
August 23, 2010 at 2:55 am
#1210300
This topic should point you in the right direction:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ff610236-9065-4868-8bf0-9ce622886657
However, it is much easier (and also pointed out in the above discussion) to create a job that runs the package and simply call the job with sp_start_job.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
Raunak Jhawar
SSCoach
Points: 15701
August 25, 2010 at 1:52 am
#1211483
Can we use xp_cmdshell??
DTEXEC and DTUTIL using the above call to SP
Raunak J
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply