Re: Duplicate connections when using LoadFromSQLServer and SaveToSQLSe

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 09/25/04

  • Next message: Allan Mitchell: "Re: merging datasets" 
    Date: Sat, 25 Sep 2004 08:41:18 +0100

    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@discussions.microsoft.com> wrote in message 
news:55EBAB1E-EAF6-458A-9AF6-5DF60A4393EF@microsoft.com...
> 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.
  • Next message: Allan Mitchell: "Re: merging datasets"

    Relevant Pages

    • 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: 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)
    • Re: DTS Environment Control
      ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
      (microsoft.public.sqlserver.dts)
    • Re: DTS Environment Control
      ... > I know I have machines which will execute packages in a given environment. ... > table on the aliased server and retrieve it through a DP task. ... > the package back out. ... > challenge is when you promote your packages up; the connections have to be ...
      (microsoft.public.sqlserver.dts)