Hi,

I am looking for some advice/ or examples on the best approach for Importing
a text file to a SQL Server DB using DTS and a GlobalVariable for the
pathName.
I plan on executing this DTSPackage from a VB.NET application.

Thank You,

Chris

Chris,
You can change the text file source using your global
variable and to set the DataSource in an ActiveX script,
using something like:
Dim Conn
Set Conn = DTSGlobalVariables.Parent.Connections("Text File
(Source)")
Conn.DataSource =
DTSGlobalVariables("YourGlobalVariable").Value

You can find some examples at sqldts.com. Check the
following article:
How can I change the filename for a text file connection?
http://www.sqldts.com/default.aspx?200

-Sue

On Mon, 7 Feb 2005 07:37:08 -0800, "Chris Lane"
<ChrisLane (AT) discussions (DOT) microsoft.com> wrote:

Thank You Sue,

I also discovered dynamic properties in SQL 2000 DTS.