To change the output file name at runtime define an expression in the connection manager properties used by the Flat File Destination. In the expression add the ConnectionString property...

If you aren't using Query Analyzer what are you using to determine that column isn't being copied in full?

I ran a DTS package to import that file and all 1439...

Debra,

Thanks for the posting the input file.

The Exception file is set on the Options tab of the Transform Task Properties dialog.

Are you getting the impression it's truncating because of...

Make sure you're checking the Exception log, not the package error log.

If it's within your company's privacy and security policies post some of all of the input file as an...

The error is occurring because you're assigning the DTSSource=DTSDestination outside of the Main function. Assign those inside Main.

Second, the way you have the If condition written it will...

Since the Copy Column transformation will truncate columns without notification it might be worth switching to an ActiveX Script transformation. That would allow you to get some additional information...

This isn't a script but here's another way to get the maintenance plan on other servers.

From Object Explorer connect to Integration Services. Expand Stored Packages/MSDB/Maintenance Plans. Right click...

The full path of the restore is logged in the servers Application Event log as well as the SQL Logs. Look for EventID 18267.

DBCC INPUTBUFFER(spid) might be what you're looking for.

When you say no functions does that include system functions as well?

If system functions are allowed have a look at this article: Using COALESCE to Build Comma-Delimited String

A Derived Column between the Flat File source and SQL destination might do what you want.

If the ConnectionString for the source is set as a package variable then an expression...

It looks like the SQLCMD -v option is expecting the variable to be quoted.

SQLCMD -v myVariable="myValue"

To get the the variable quoted add an additional set of double quotes:

:SETVAR myVariable """N'C:\temp'"""

:!!ECHO...

A good place to start would be to track what time of day it seems to be growing. A Perfmon log could help with that; SQLServer : Databases and...

If the scripts are scheduled using the SQL Agent they are likely using whatever service account the Agent is running as.

If the service account is the same for all your...

Can you post a few of the lines from the flat file that do and don't cause errors?

Also, for the Flat File source what are the DataType and ColumnWidth...