OK, so you're using the DTS Import/Export Wizard.

My first thought is to try what you're doing but also add the RTRIM function to strip off the trailing spaces, like...

Whenever you're creating your transformation from the txt file to your db table, for that specific column of data, try using "DateTime String" instead of using the "Copy Column" transformation. ...

I'm going to guess that you have this scheduled as a job?

If so, and you go into the Jobs under SQL Server Agent, you may have to refresh the screen...

You can dynamically change the SQL of a task/data pump via an ActiveX Script and pull in the global variable information like such:

 myVariableName = DTSGlobalVariables("myGlobalVariableName").Value

An Example ActiveX Script:

Function Main()

 Dim objPkg

 Dim objTask

 Dim...

Regarding specifically building something, that looks like what the guys over at SQLDTS.com did and made it available to the masses.  They also have an article which shows how to write...

Well, I really don't want to read the values from an INI file (or any other format) via the Dynamic Properties Task.  What I am looking for is to reproduce...

Although creating a front-end (in VB\VBA) to alter the information within the DTS is a viable option, I was hoping to keep everything in a DTS package.  Any other suggestions?

Thanks!!!

Try also using the IsNull function in the transformation.

From BOL...

ISNULL

Replaces NULL with the specified replacement value.

Syntax

ISNULL ( check_expression , replacement_value )

Arguments

check_expression

Is the expression to be checked...

Check out this site:  http://www.sqldts.com/

They have an article specifically about creating an Access database:  http://www.sqldts.com/default.aspx?288

When scheduling DTS packages by right-clicking on the package name and then selecting "Schedule Package", the job is created with the DTSRun string automatically encrypted.  But, the job is saved...

You may also want to check out:  sp_helplogins

Check out these articles from Microsoft...

INF: How to Shrink the SQL Server 7.0 Transaction Log

http://support.microsoft.com/default.aspx?scid=kb;en-us;256650&Product=sql

INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE

http://support.microsoft.com/default.aspx?scid=kb;en-us;272318&Product=sql

First, check out this site:  http://www.sqldts.com

Related to your question, I dynamically set the password of my connection object – I'm sure you can change the...

Check out the related post at...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=120942

I personally use a DTS to call and execute another DTS.  This method allows me to log each step of the called DTS after it...

What I like to do is have a DTS (a) that calls the DTS (b) that I want to log information about.  The calling DTS (a) contains logging code as...