March 5, 2015 at 12:07 am
Dear All,
I am having few queries related to follow.
1. Is it possible to call SSIS package from procedure .
2. Also want to supply parameters to procedure.
3. Can multiple users execute that procedure simultaneously.
4. If yes then will it cause any issue if it is run simultaneously by 10 users.
March 5, 2015 at 6:02 am
First of all, which version of SSIS?
With procedure, do you mean stored procedure?
1. yes. Depending on the version of SSIS this is easy or rather complicated.
2. yes. Depending on the version of SSIS this is easy or rather complicated.
3. Most likely.
4. Maybe. It depends.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 7, 2015 at 4:46 am
Dear Koen Verbeeck,
I am using SQL Server 2008 R2.
March 13, 2015 at 2:47 am
Sushant Yadav (3/7/2015)
Dear Koen Verbeeck,I am using SQL Server 2008 R2.
In that case your options are more limited. You can use xp_cmdshell to call DTEXEC directly, or maybe call a batch file that starts DTEXEC.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply