I found out something else about using constants in a DTS to textfile transfer.  You don't need to have an existing empty field in the source database for reference, all...

I just figured it out!  I originally created an empty field in my source table, named BDL and am using it for all of the extra fields I need to populate...

I tried that but it just renames the column.  I want to populate the field for every record picked up with a constant value.

Thanks

Al

I found the solution on my own...

http://support.microsoft.com/default.aspx?scid=kb;en-us;818334

I didn't know that installing SQL Server from an image would cause problems.  I didn't specify this in my post because I didn't think...