Re: DTS package disappearing

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hello,

When you create a new package and then save it, you have the option to save
the DTS package to SQL server, Meta Data Services, a structured storage
file, or a Visual Basic file.

If you save it to SQL server, you also need to select which SQL server you
want to save the package. Please make sure you have selected the exact SQL
server instance. After saving it, you can open the package in SQL
Enterprise manager(EM).

To open structured storage file, you can right-click "Data Transformation
Services", and then click "Open Package". For more information, refer to
the "How to open a DTS package saved to a structured storage file
(Enterprise Manager)" topic in SQL BOL.

I hope the information is helpful.


Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.



Relevant Pages

  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: Migrating DTS Local Package from test to production environments v7.0
    ... The version of SQL Server on which the package was create is SQL Server ... DTS runs at the client so manually will be on the invoker's PC which in this ...
    (microsoft.public.sqlserver.dts)
  • RE: Migrating DTS to Integration Services
    ... let me answer your Encryption issue when you expand your MSDB ... used to connect to your SQL Server, ... Open services.msc and restart your SQL Server Integration Service. ... Migrate DTS 2000 packages or Add Existing package (since you have migrated ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Packages fail when executed from Jobs
    ... Action Plan 1 - Modify the path of Dtsrun.exe ... Expand the server that is running SQL Server in SQL Server ... Action Plan 2 - Run the DTS Package on the server rather than on ...
    (microsoft.public.sqlserver.dts)