June 15, 2011 at 6:42 am
Hi,
I'm knocking up a simple flat file importer and I have a small problem with the destination table having 2 columns that are not populated from the file, but from lookup tables on the destination SQL Server DB. Not the trickiest problem but something I've not had to deal with before.
How do I populate these columns at the same time as bringing in the flat file data?
Cheers
June 15, 2011 at 6:53 am
Use a Merge Join transformation in your data flow.
John
June 15, 2011 at 7:05 am
Or run an Execute SQL 'UPDATE' at the end of the import.
You may also like to check the LOOKUP transformation.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 16, 2011 at 5:21 am
I prefer running an Update via a stored procedure in the Execute SQL Task myself. Merge Join takes a lot of resources that I can better use in other areas of my package. I try not to use that transformation unless I absolutely have to.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply