No announcements
Found 2213161 threads
-
0 Votes
foreach loop container and foreach file in folder
Have a look here http://blogs.conchango.com/jamiethomson/archive/2005/05/30/SSIS_3A00_-Enumerating-files-in-a-Foreach-loop.aspx Ashwani Roy ...Answered | 2 Replies | 4350 Views | Created by Gunnar Eriksson - Monday, January 26, 2009 3:05 PM | Last reply by Ashwani Roy - Wednesday, January 28, 2009 10:48 AM -
0 Votes
Loading Multiple TXT files using ForEach Loop Container
Hi CMK, if the files are different in structure (format) then no change in settings will help because SSIS relies on static metadata, you will end up with several Flat Data ...Answered | 4 Replies | 1931 Views | Created by cmk1 - Tuesday, April 9, 2013 4:01 PM | Last reply by Michael Wandzik - Tuesday, April 9, 2013 5:01 PM -
0 Votes
Foreach loop container question
Has to do with some third party apps installed and you will need the latest SP to fix see this to resolve: ...Answered | 1 Replies | 3745 Views | Created by davebo5256 - Monday, June 27, 2011 2:41 PM | Last reply by ArthurZ - Monday, June 27, 2011 2:59 PM -
2 Votes
Feeding a Foreach loop with an Execute SQL statement
Drop a For Each Loop container on the work surface.Answered | 3 Replies | 9866 Views | Created by Spike00 - Saturday, November 14, 2009 11:44 PM | Last reply by Spike00 - Monday, November 16, 2009 1:27 PM -
0 Votes
SSIS Package to load multiple excel sheets using foreach loop container
Even in that case you can specify a range using openrowset ...Answered | 13 Replies | 2789 Views | Created by scott murdoch12 - Monday, March 3, 2014 3:41 PM | Last reply by B3nt3n - Tuesday, March 4, 2014 6:51 PM -
0 Votes
SSIS (2008) recordset handling question....
After putting results inside the object type variable use for each loop container and do configuration like shown in the figure.Answered | 3 Replies | 3867 Views | Created by edm2 - Monday, April 30, 2012 10:46 PM | Last reply by Syed Qazafi Anjum - Monday, April 30, 2012 11:29 PM -
0 Votes
File Priority in ForEach Loop Container
any other solution that comes to mind involves using two separate foreach loops as you mentioned above.Answered | 1 Replies | 4970 Views | Created by Tech2175 - Wednesday, March 25, 2009 5:19 AM | Last reply by Duane Douglas - Wednesday, March 25, 2009 6:18 AM -
0 Votes
SSIS Conditional foreach loop task
Hi SQLEnthusiast, You could use a For loop container to loop the files one by one.Answered | 4 Replies | 1497 Views | Created by CSharp Enthusiast - Monday, March 7, 2016 9:22 PM | Last reply by CSharp Enthusiast - Tuesday, March 8, 2016 4:36 PM -
0 Votes
Replace ForEach Loop container functionality with Script
the syntax employed by the script is determined by the ssis version being used (2005 or 2008).Answered | 1 Replies | 4294 Views | Created by AkimZ - Friday, May 1, 2009 7:20 PM | Last reply by Duane Douglas - Wednesday, May 6, 2009 7:24 AM -
0 Votes
How to Loop Files based on Date Modified using Foreach loop Container in ssis.
Assuming files are all in same folder you can use foreachloop with file enumerator to iterate through files.Answered | 1 Replies | 6952 Views | Created by Prashu Shetty - Tuesday, January 21, 2014 1:30 PM | Last reply by Visakh16 - Tuesday, January 21, 2014 2:14 PM -
1 Votes
SSIS and the FOREACH LOOP and no Connection String Property
I have the Foreach Loop set up.Answered | 12 Replies | 3360 Views | Created by EMKISER - Monday, June 24, 2013 9:10 PM | Last reply by Peter_D503 - Tuesday, December 17, 2013 7:33 AM -
0 Votes
How can I load a .xlsx File into a SQL Server Table using a Foreach Loop Container in SSIS?
Can you show us the screenshots of your Foreach Loop Container ?Answered | 10 Replies | 2265 Views | Created by ITBobbyP - Friday, January 23, 2015 5:13 PM | Last reply by Katherine Xiong - Tuesday, January 27, 2015 2:30 AM -
0 Votes
Using a ForEach Loop container to import multple files in a directory
Try this: How to: Configure a Foreach Loop Container Or this: Adding and Configuring the Foreach Loop ...Answered | 2 Replies | 4152 Views | Created by NCooper - Tuesday, February 10, 2009 4:19 PM | Last reply by NCooper - Monday, February 16, 2009 4:23 PM -
0 Votes
SSIS Foreach Loop Container Logic
This will give us an opportunity to get back file and load it incase initial load didnt happen due to some reason.Answered | 5 Replies | 863 Views | Created by laumen - Wednesday, September 10, 2014 10:40 AM | Last reply by Visakh16 - Wednesday, September 10, 2014 1:42 PM -
1 Votes
Variable Mapping with Foreach loop container
Hi, Before, writing to record set destination, use the data conversion task and change the data types as Arthur suggested.Answered | 2 Replies | 1219 Views | Created by shba - Thursday, March 14, 2013 4:29 PM | Last reply by Harry Bal - Thursday, March 14, 2013 6:51 PM -
0 Votes
Problem with ForEach Loop and rowcount
Why not use event handler based on OnError event to capture this information.Answered | 2 Replies | 1094 Views | Created by SuzSQL - Monday, March 3, 2014 8:35 PM | Last reply by Visakh16 - Thursday, March 6, 2014 4:45 PM -
0 Votes
SSIS For Each Loop Container
Based on my research, we should use Foreach File Container together with File System Task to achieve your requirement.Answered | 4 Replies | 1046 Views | Created by ShyamReddy - Thursday, April 2, 2015 4:36 PM | Last reply by Katherine Xiong - Friday, April 3, 2015 9:14 AM -
0 Votes
ForEach Loop
I have a ForEach loop.Answered | 4 Replies | 3540 Views | Created by Pete Newman - Friday, June 22, 2012 3:38 PM | Last reply by ArthurZ - Friday, June 22, 2012 4:36 PM -
1 Votes
UnPivot in the foreach loop container
Hi Gilles, To achieve your goal, you can simply use the Unpivot Transformation or UNPIVOT statement in T-SQL.Answered | 5 Replies | 1423 Views | Created by Gilles Machetto - Tuesday, March 11, 2014 3:24 PM | Last reply by Gilles Machetto - Wednesday, March 19, 2014 5:36 AM -
0 Votes
ForEach Loop Container Configuration Question
Not a problem, Ern - it'll do what you want.Answered | 4 Replies | 4786 Views | Created by BigErn782 - Wednesday, September 1, 2010 10:10 PM | Last reply by BigErn782 - Thursday, September 2, 2010 6:53 PM
No announcements