Hi all
Is it possible to convert a dts package saved as .bas file back to
a sql server package so it can be opened, designed,saved and used again in
sql server?

Thanks alot
Rea

The generated BAS package contains the lines of code to both execute or save
the package, look for this fragment:
'---------------------------------------------------------------------------
' Save or execute package
'---------------------------------------------------------------------------

'goPackage.SaveToSQLServer "(local)", "sa", ""
goPackage.Execute
tracePackageError goPackage
goPackage.Uninitialize
'to save a package instead of executing it, comment out the executing
package lines above and uncomment the saving package line
set goPackage = Nothing

set goPackageOld = Nothing

End Sub

You could comment out the goPackage.Execute and use the
goPackage.SaveToSQLServer or one of the other variations to save to file or
repository.

GertD (AT) SQLDev (DOT) Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

"Rea Peleg" <rea_p (AT) afek (DOT) co.il> wrote