How to run DTS packages in Management Studio?

  • Hi All,

    I need to run my DTS packages in Mangement studio. Actually, I was able to get the packages loaded under Mangement -> Legacy -> Data Transformation Services (I did this by right clicking on Data Transformation Services and chose "Import Package File..."). How ever, I could not see any option to run the package when I right click on the package. Could any one help me to find the run option?

    Thanks in advance,

    Suresh

    Regards,
    Suresh Arumugam

  • You have to open the package and execute it withing DTS Designer. Alternatively, you can create a SQL Agent job with DTSRun in a job step.

    Greg

  • Thanks Greg. I have installed DTS designer and executed the package.

    Regards,
    Suresh Arumugam

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

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