Hello, I have a SQL 2000 table with several columns that will need to get their data from several text files. These text files are fixed column witdh text. I'm trying to use DTS packages to accomplish this.
When I import the data from the first text file, I insert the record ID and the first 2 values for the record.
My problem arises when I need to import the subsequent values so the records can be complete. In my subsequent DTS package I need to create a where clause or an if statement in the transformation screen so the third value goes to their matching record (all text files have the record ID so I can use this as my clause) and then I need to import the 4th value to their respective column for the same record id and so on.
I am using a DTS package for each value import.
This is what I'm trying to do in the transformation screen:
DTSDestination("ORB2") = DTSSource("Col002")
WHERE DTSDestination("RecordID") = DTSSource("Col005") <-- this is my where clause that doesn't work!!!
Main = DTSTransformStat_OK