I have a DTS package that kicks off another one, looping through a
recordset. I have Dbase 3 connections in the child package, and am
trying to reset the path to a new path with each loop.

I've tried using the dynamic properties to set the datasource =
dtsglobalvariable("dbpath") I have a message box that pops up and
gives me the values of dbpath and connection data source, and they
show to be correct. However, it never actually changes the data
source for the Dbase 3 connection -- it just keeps pulling from the
file path in the connection over and over.

Any ideas?

Thanks

Have you set the connections to close on completion ? (workflow properties)

Why do you call another package ?

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"John Fitzgerald" <john.fitzgerald (AT) ebi-sys (DOT) com> wrote