I built 3 diffrent packages and i want to be executed in order. The first one is exporting some tables to another database and the other two packages are based on the database built in the first package.
Any suggestions?
Thank you in advance:)
I assume you wish to automate this process. The simplest option would be to create a SQL Server Agent job, and just have three steps within the job, one for each package.
A more SSIS orientated approach would be to use a master package, that has three execute package tasks, one for each of your existing packages. Link the Execute package Tasks together with workflow constraints to enforce the order of execution for the tasks and hence the packages.
|||Darren,
Just a question: when we're talking about the maximum number of DTSX inside a DTSPROJ only limitation is the memory?
TIA
|||Yes.
If you do have a lot then I'd be tempted to write a more dynamic process.
Perhaps use a SQL table to contain the list of packages, and also have a column for the order. You could then use the Exec SQL Task with simple SELECT query to extract the list of packages in order of execution. You could store this results in a variable, and then loop and shred this via the For Each Loop.
This example uses Data Flow task to get the result set into a variable, but I normally find an Exec SQL Task easier. It does show the shredding of the results via the loop though.
Shredding a Recordset
(http://www.sqlis.com/default.aspx?59)
|||I used the SQL Server Agent Job.
thanks for the help :)
No comments:
Post a Comment