Hello fellow DBA's,

Lets hope this makes sense.

I am using a DTS Package that I created.

I am using an Execute Sql Task. Within this I am simply deleting records for the current month.

Upon success, then I am importing using Text File (source). Within this, it has a form whose properties have the filename, and various settings to import the file. Basically I am appending data from a text file to a table whose records were deleted for the current month.

Problem: Is there another way to import text file programmatically. The text file (source) has the fixed name of the text file. I would like to be able to change the file name thru code. Lets say it is august, i would like the code to look for a filename for august, instead of july. I need it to be done automatically without manual editing the DTS package.


Regards,

Jeremy Beal
Shamrock Materials Inc.

MS Sql Server LazyDBA home page