Loading multiple files through DTS

[Rob P]

Is it possible to take a text file that contains multiple record types through the Data Transformation Service in MS SQL 7.0 and load each different record type into a seperate table?

Thanks in advance.

[Rob P]

------------
Rob P at 9/8/00 6:31:17 PM

Is it possible to take a text file that contains multiple record types through the Data Transformation Service in MS SQL 7.0 and load each different record type into a seperate table?

Thanks in advance.

[GreatInca]

I'd import the whole text file into a table and work from there with a SP to defferientate the fieldsets. Do you have a foreign-key like something in the text file to identity what fieldset is what Having that would make everything a lot easier. I am assuming that a record type is a separate set of fields. Probably 10 different styles of data all interbogled around in the same text file?

------------
Rob P at 9/8/00 6:31:17 PM

Is it possible to take a text file that contains multiple record types through the Data Transformation Service in MS SQL 7.0 and load each different record type into a seperate table?

Thanks in advance.