Edit DTS package in structured file

• ridzuan_first

  Right there with Babe

  Points: 798

  More actions

  August 4, 2009 at 6:17 am

  #99818

  Please anyone help me ...

  I have a DTS package that was saved in structured file.How can I edit the package to

  correct the fields mapping?

  How can I view the fields mapping from a package that saved as structured file format?

  Thx for advise,

  Dwen

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  August 4, 2009 at 7:58 am

  #1034254

  You have to open the DTS package from the Enterprise Manager.

  Right click Data Transformation Services and choose "Open Package". Pick the file from the dialog and choose open.

  You can now edit the package and save back to the original file, SQL Server or Visual Basic Project.

  Hope this helps

  Gianluca

  -- Gianluca Sartori