I need to import several very large CSV files (both in records and columns) into SQL Server 2000. I've created a DTS package that creates a table then uses bulk insert to load the dad. It uses a .ini file to specify dynamic values like db name, file name, etc, and it works fine. The problem is that not every table is identical so now I'd like to be able to alter the table creation query. My .ini file cuts off the query within a few dozen characters and it won't work with multiline queries. Does anyone know of a way to dynamically alter the SQL table creation in a DTS package? Thanks for your assistance.

I do not have much experience with it but in the DTS designer there is a Dynamic Properties Task. May be this will help you.

I'm using the dynamic properties task. I managed to solve it in a more hackish way then I prefer. I use a seperate .sql file and use dynamic properties to load that just for the query. It works fine, but requires two files instead of one.

Hey,

Then that's probably your best solution. The only other way I know is to use the ActiveX task and vbscript to do what you need.

Brian