How can I Save .DTS file to SQL Server... 1

[hneal98]

I need to know how to save a .DTS file to sql server. Is there a way?

Thanks in advance.

 

[nigelrivett]

You can use the dts designer in enterprise manager or did you want to use t-sql?



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[AtomicWedgie]

Go to the server in enterprise manager
Rightclick on data transaformation services.
Then select open package, select the package.

The "package designer" gets opened and the dts package is shown. In the menu select 'package' and then select 'save as'.

In the 'save package' screen fill in a name etc. and in the location dropdownbox select 'SQL server'.

Now you have to select the server etc. you want to save it to.

The dts package is then stored in the 'local packages' of the server.

Atomic Wedgie

 

[hneal98]

Perfect. AtomicWedgie, that was awesome.

 

[rodboy]

However, if you have saved your DTS package in SQL Server you cannot always use the designed to edit/save (well, you can but it doesn't work properly) if you have complicated SQL statements.

It's easier to copy the details into Notepad and recreate a new DTS package (using the wizard) and when prompted to save, save as a DTS file (VB or Structured Storage File).

Hope this helps.
Rodboy.