Very Urgent: How to deploye Parent and Child package in SQL Server

  • Hi all,

    I have one Parent package and 2 child package. It is working fine in BIDS.

    When i try to run as SQL job. it is not working.

    Steps i followed:

    Parent and child packages are pointing same config file.

    1. Import package in File system

    2. A new job created .

    When i try to run manually or automation it is not running.

    Please give me the solution how to achive this.

    Thanks

    Thiru

  • Did you set the configuration in the scheduled task? When you create a step, you select the package from the 'General' tab, then the configuration from the 'Configurations' tab. Do you have any error messages, either in the job history or in the SQL Management Logs?

    I think if you gave more information you may get more help...

  • I also think the same way. I think there can be some problem in the configuration. If not, it can be the jobs created by mistake. Did you call the correct package? Please provide more info and what steps you took so we can troubleshoot some more.

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

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

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