Hi Im using sql server 2000 and i need to create a dts to handle a txt file and im looking for some advice.

The first task needs to be that the text file has to be imported in. The difficulty i have is that i have no way of knowing until doing the import how many columns will be needed? How do i go about this?

The delimiter between each field will be a comma.

If this is the wrong forum to ask this in, soz.