Data Driven Query Task
Hi All -- I have a unique situation
I want to execute a stored procedure for data pulled from a flat file, which I have figured out.
My question is this: I have a flat file where the data must insert several rows in the same table; the data occurs 3 times on the flat file in succession:
CONTRACT01 DATA FOR ROW 1 DATA FOR ROW 2 DATA FOR ROW 3
And it needs to be represented in a table like this:
CONTRACT01 DATA FOR ROW 1
CONTRACT01 DATA FOR ROW 2
CONTRACT01 DATA FOR ROW 3
It does get a little bit more complex-- I can't do this through a simple insert; I want to use a stored procedure (for a lot of reasons; error handling, and putting data in several tables at once without having to do lots of lookups).
I have it figured out how to "loop" through this data using ActiveX Script with simple Inserts but that won't suit my needs.
Can someone enlighten me how to execute a stored procedure passing the proper segmented part of my record as a parameter to my stored procedure?
"A spirit with a vision is a dream with a mission"
\"A spirit with a vision is a dream with a mission\"