SQL Server Performance

What is DTS

Discussion in 'General Developer Questions' started by praveengrd, Aug 29, 2005.

  1. praveengrd New Member

    please tell me hot to send a DTS package from one place to another ?

  2. dineshasanka Moderator

    You can save the DTS as Structured Storage File which has the extension of dts.
    Then you can open the DTS from the server you want to save the DTS and save it there.
  3. dineshasanka Moderator

  4. Akthar New Member

    Hi,

    Have a look in SQL Books online under DTS

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  5. Akthar New Member

    Here u are
    How to save a DTS package to SQL Server (Enterprise Manager)
    To save a DTS package to SQL Server

    In Data Transformation Services (DTS) Designer, on the toolbar, click the Save button.


    In the Location list, click SQL Server.


    Complete the rest of the required fields.


    Note If the DTS package has already been saved to Microsoft® SQL Server™, the Save DTS Package dialog box will not appear and a new version will be saved. If the package has been saved to a structured storage or a Microsoft Visual Basic® file, or to SQL Server 2000 Meta Data Services, click Save As to save to SQL Server.



    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  6. FrankKalis Moderator

  7. dineshasanka Moderator

  8. praveengrd New Member

    thanx 4 the solution

Share This Page