all groups > sql server dts > october 2004 >
You're in the

sql server dts

group:

Import a DTS package into MSDE2000


Import a DTS package into MSDE2000 yaniv
10/21/2004 2:23:06 AM
sql server dts:
Hi i was wodering how can i transfer a developed dts package from sqlserver
RE: Import a DTS package into MSDE2000 yaniv
10/21/2004 4:59:02 AM


nevermind found a way.
a simple VBScript that imports the file.dts :

Const DTSSQLStgFlag_UseTrustedConnection = 256

dim ServerName,dtsFilePath,userPassword
Dim dtsp, dtsPkg

ServerName = "server"
dtsFilePath = "d:\path\File.dts"
userPassword = ""

Set dtsPkg = CreateObject("DTS.Package")
dtsp = dtsPkg.LoadFromStorageFile(dtsFilePath,userPassword)
dtsPkg.SaveToSQLServer ServerName, "","" ,DTSSQLStgFlag_UseTrustedConnection
Set dtsPkg = Nothing
AddThis Social Bookmark Button