Post reply

DTS

  • 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

     

  • 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]

  • January 16, 2007 at 9:45 am

    #683533

    Thanks

    Nita

     

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

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