Insert into Temp Table ??
Team , Can someone please give me an idea on how should i be proceeding on this ? This should be sounding simple for you .. I have a flat file which has a column "Facility" with some x,y,z values .. Facility x y z I just have to retrieve these values , loop it over for each loop container , and do some processing inside the dataflow task placed inside the for each loop .. So should i be going with inserting these values in #temp table ? if so how to configure .. any other ideas ? Please let me know if anything is not clear . Thanks in advance for your help ! Rajkumar Yelugu
September 18th, 2012 10:01am

hello Rajkumar based on what I see you can simply query the results of this table to an Object type of SSIS variable and then shred it from there in a ForEach Loop. This approach is best described here: http://www.sqlis.com/post/Shredding-a-Recordset.aspxArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2012 10:03am

hello Rajkumar based on what I see you can simply query the results of this table to an Object type of SSIS variable and then shred it from there in a ForEach Loop. This approach is best described here: http://www.sqlis.com/post/Shredding-a-Recordset.aspxArthur My Blog
September 18th, 2012 10:08am

based on what I see you can simply query the results of this table to an Object type of SSIS variable and then shred it from there in a ForEach Loop. Arthur can you please advise on how to query over to retrieve flat file column values ? My master source is flat file .. Rajkumar Yelugu
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2012 10:12am

Add a Data Flow Transformation, then double-click it to get to its designer, then add a new flat file data source. Set it up so the 1st row is specified as "column name in first record". Once you set it up, you you should get it picking all the rows from the file. Then you add a recordset destination like in the link above. Once the data is in the recordset you can loop over its values. Arthur My Blog
September 18th, 2012 10:13am

Add a Data Flow Transformation, then double-click it to get to its designer, then add a new flat file data source. Set it up so the 1st row is specified as "column name in first record". Once you set it up, you you should get it picking all the rows from the file. Then you add a recordset destination like in the link above. Once the data is in the recordset you can loop over its values. Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2012 10:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics