Post reply

run SSIS packages

  • April 13, 2009 at 6:01 am

    #199126

    Dear ones

    I have 3 packages and source is oracle.

    I using SQL SERVER(user defined variables) variables in side the source query.

    I am using script task to combine SQL variable inside the oracle query.

    Now i need to call these 3 packages from one package.

    what wil be the best way?

    Can i add thses 3 packages to sql server agent job and call the through

    sql server agent job task?.

  • April 13, 2009 at 8:45 am

    #976654

    Use the Execute Package Task (3 times for your 3 packages) in a Main package and use SQL Server agent job to run this package. But if u want each package to run at a different scheduled time, then configure the SQL Agent job to execute the jobs separately.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply