Post reply

modify a package in a scheduled job

  • March 22, 2007 at 2:00 am

    #123250

    Hi,

    I have a scheduled job setup on a server, which has a step to transfer data from one serevr to another. The step is a package. Ho do I open and view this package to see what it does and modify it?

    Thanks

  • March 22, 2007 at 10:11 pm

    #696532

    hi!

    u must be having the .dtsx file located either on the file system or on the SQL Server where the package is currently deployed. Then by using the VISUAL Studio 2005 you can open the specified package in the studio for modifications and the tasks that u want to do. like another OBJECT FLOW TASK and define the Source and the valid destinations.

    test the same package again after modifications.

    As far as deployment of the package is concerned, just deploye the same using the studio only and the execute package utility command for execution.

    Regards,

    Nitin'

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

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