December 6, 2011 at 11:21 am
Hello All,
I am working on a project where I need to run a process multiple times but I imagine that I can only be running about three of them at any one time. I am new to SSIS but know how to run a single command by using the Execute Process Task and then passing in the Executable and Arguements but can't conceive of how to run say a total of 30 of these in a loop type fashion waiting for one to finish and then starting the next?
sqldoc /project:"U:\DBA\Documentation\Server01\SQL Doc\Server01sqldoc"
Any suggestions is appreciated.
Thanks
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
December 6, 2011 at 1:56 pm
Why don't you take a look at these articles:
http://www.sqlservercentral.com/Authors/Articles/Elliott__Whitlow_/483442/%5B/url%5D
CEWII
December 6, 2011 at 1:59 pm
That is the ticket Elliot! Thanks so much!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
December 6, 2011 at 3:33 pm
Good deal, if you have any questions let me know.
CEWII
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply