Hi NG,

i got some DTS-packages saved as structured-file (.dts)
Is there a way to store them into a sql-server by vbscript (like an
installroutine)?

kind regards

frank

Hi Frank,

yes, there is a way:

You have to create an Package2 (sql2k) or Package (sql7) object in
vb/vbscript.
Load the DTS object from Storage File with
YourPackage2object.LoadFromStorageFile() function.

Once the DTS package is loaded into VB - Package2 object, you can use member
function YourPackage2object.SaveToSQLServerAs()

For detailed information about DTS Package2 object and functions take a
look at SQL Server online help.

Regards / Grüße aus Stuttgart

Mario


"Frank Matthiesen" <fm (AT) xax (DOT) de> schrieb im Newsbeitrag
news:bo5nmu$16kkb9$1 (AT) ID-151790 (DOT) news.uni-berlin.de...

Mario Kropik wrote:
Hi Mario,

löppt!

Regards / Gruesse aus Bremen

Frank