RE: Import a DTS package into MSDE2000 -
10-21-2004
, 06:59 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,userPasswor d)
dtsPkg.SaveToSQLServer ServerName, "","" ,DTSSQLStgFlag_UseTrustedConnection
Set dtsPkg = Nothing |