Brandie Tarvin (5/13/2013)
Stefan Krzywicki (5/13/2013)
Can you use SSIS?I've done something similar recently with SSIS, so if you can use it I think you have a good option.
Yes, we can use SSIS. In fact we're using SSIS to load the file into our staging table and run the proc that does the update.
I've got a few meetings, but after those I'll dummy up some data and sanitze the destination tables and post them in a bit.
I have two files I need to process every week that have a similar format. Descriptive lines that I don't need to import and multiple header rows that are interspersed with corresponding data rows. I use a conditional split to check the line type and divert it to the proper parsing and insert, which I think you do with the IF @rec=2 line.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams