DTS

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  January 16, 2007 at 7:20 am

  #368852

  I want to import test.dts which is saved in C: drive, How can I import this on SQL server DTS??

  Nita

   

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  January 16, 2007 at 9:11 am

  #683511

  I don't if this is the quickest way, but it's how I do it (!!)...

  1. Open Enterprise Manager and expand the group, server etc.

  2. Right-click on Data Transformation Services.

  3. Click on "Open Package" on the context menu.

  4. Locate, select and open the DTS package in the C: drive.

  5. Expand the version history and open the package.

  6. Click on "Package > save as" on the toolbar.

  7. Change "location" to "Sql Server".

  8. Name the package and select the server to save the package to.

  And you're done!

  ---

  
  Ade

  A Freudian Slip is when you say one thing and mean your mother.
  For detail-enriched answers, ask detail-enriched questions...[/url]

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  January 16, 2007 at 9:45 am

  #683533

  Thanks

  Nita