Hi,
I am new to SSIS and just want to know how I can call a store procedure for each record during transformation since my destination table ID is generated by a Store procedure and I must store it also in my integration temp table.
Thanks
Yes, you can call a sproc for each record in the pipeline. Thomas explains how here: http://sqljunkies.com/WebLog/tpagel/archive/2006/01/03/17744.aspx
-Jamie
No comments:
Post a Comment