Hello:

I am working on a VB.NET program that allows me to copy whatever DTS package
or packages from one server to another. I am using the following lines of
code to do the actual copying:

For Each strPackageName In arrPackageList
objDTSPackage = New DTS.Package2

'Copy DTS package from source server to destination server

objDTSPackage.LoadFromSQLServer(strSServer, strSUser, strSPassword,
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , , , , strPackageName)

objDTSPackage.SaveToSQLServerAs(strPackageName, strDServer, strDUser,
strDPassword, DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default )

objDTSPackage.UnInitialize()

objDTSPackage = Nothing
Next

Everything seems to work fine, but when I open a package on the destination
server, sometimes it has duplicated connections. For example, if the source
server has two connections originally, on the destination server, the package
shows me four connections. This happens with TEXT FILE connections (OLE DB
connections get copied fine).

I will appreciate any comments of how to explain or solve this behaviour.

You could of course use our tool

Transferring DTS Packages
(http://www.sqldts.com/Default.aspx?204)

--

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"gborda" <gborda (AT) discussions (DOT) microsoft.com> wrote