February 26, 2008 at 9:17 am
I have created a project that contains four separate dtsx packages. Up to now, I've been executing the project by opening BIDS and then right-clicking & executing each dtsx package, one at a time. I wait for the first one to run, then run the next one, etc.
But now that these individual pieces are working, I need to develop a more automated process. I've read up on using dtexec, so I think I can create a batch file to run this, but I'm stuck on how to select which order to run the individual dtsx's.
Do I set the first one I want to run as 'Set as Startup Object'? (I haven't been able to find exactly what that means.) If so, how can I 'call' the other packages from that first one? I was hoping to modify the first package so that if it finished successfully, it would then run the next package, using the 'execute package task'. However, that task isn't giving me the option to select a dtsx from this project.
Or, should I save the dtsx to the file system and call them one at a time in the batch file?
Or, is there a better solution?
More Information: Basically, the project stops a service on the system, drops an existing database, creates it again from scripts, populates some of the tables with selective data from another database, and then restarts the service upon completion (not success). This database then becomes the source table for an internet application on another server.
Thanks!
Gwen Sembroski
February 26, 2008 at 11:19 am
Create a Master SSIS package. you can use exectue package tasks in the control flow to execute in the order required.Call the Master SSIS package using dtexec command.
February 26, 2008 at 11:37 am
Can someone point me to a reference on-line for creating a master SSIS package?
I will also accept a simple explanation here. 🙂
February 26, 2008 at 11:42 am
Master pasackage is another SSIS package with "execute package tasks". Each execute package tasks refers to a SSIS package.
So in master package, you can create precedence constraints to execute one package after another. You can call master package using a batch script.
February 26, 2008 at 11:49 am
I tried to add an 'execute package' task earlier, but I couldn't navigate to any of the packages in this project.
But, I was choosing SQL Server as the location for the packages. I suppose I could save the individual packages to the file system and then call them that way.
Is there another way to call the dtsx packages that are already in this project? Or must the 'master' be its own separate project?
February 26, 2008 at 1:31 pm
After more thinking and googling and researching, I think I see what I need to do now:
1) Create a project that has all my dtsx packages in it. [done]
2) Save a copy of each dtsx package to either the file system or the SQL
3) Then create another project to be the 'master', that uses the 'execute package' task and calls the copies of the dtsx's in the proper order.
4) Finally, create a batch file that calls the 'master'.
Does this sound right?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply