Duplicate connections when using LoadFromSQLServer and SaveToSQLSe

From: gborda (gborda_at_discussions.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 07:55:05 -0700

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.

Relevant Pages

  • Re: Missing rows from Transform - Intermittent Issue??
    ... server memory while running a DTS package. ... Bouncing SQL Server did not help. ...
    (microsoft.public.sqlserver.dts)
  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: setup an offline connection
    ... If you are calling the package in VB then you can simply use the object ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > the laptop to a client, I would like to modify the DTS package to ... > delete the connection to my computer and put the connection to their ...
    (microsoft.public.sqlserver.dts)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: sunmanagers Digest, Vol 34, Issue 14
    ... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
    (SunManagers)
Loading