All, please may I have your assistance with the following?
I'm trying to reference an existing DTS connection in my activeX script task
rather than instantiating a new connection object with plain text connection
details.
The objective of the DTS package is to upload an XML file details into a
table. I need to make this generic so that the package can be deployed on
different sql servers.

My objective is to replace the follwoing::

'Create and initialize (Open) ADO Connection
Set objADOCnn = CreateObject("ADODB.Connection")
objADOCnn.Open "PROVIDER=SQLOLEDB;SERVER=aaaa;UID=sa;PWD=bbbb;DAT ABASE=dddd;"


If this is not possible what other options are there?


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200508/1

You can only reference an existing connection in order to grab its general
properties. You cannot use it as a connection AS IS in ADO.

The way to make this generic is to expose essential properties as Global
Variables so in your case it might be

ServerName
UserName
Password
Database
Filename

etc


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"John Shiangoli via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Allan, many thanks for your help


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200508/1