No announcements
Found 2212572 threads
-
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 | 3897 Views | Created by davebo5256 - Monday, June 27, 2011 2:41 PM | Last reply by ArthurZ - Monday, June 27, 2011 2:59 PM -
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 | 2017 Views | Created by cmk1 - Tuesday, April 9, 2013 4:01 PM | Last reply by Michael Wandzik - Tuesday, April 9, 2013 5:01 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 | 10021 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 | 2884 Views | Created by scott murdoch12 - Monday, March 3, 2014 3:41 PM | Last reply by B3nt3n - Tuesday, March 4, 2014 6:51 PM -
1 Votes
foreach loop container and data flow task
Since the transfer database objects wizard seems useless (see this post: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/44a90cba-f507-4ee3-8880-c8eff72d346a ...Answered | 4 Replies | 6063 Views | Created by JustinRush - Tuesday, December 15, 2009 8:38 PM | Last reply by COZYROC - Wednesday, December 16, 2009 12:11 AM -
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 | 5112 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
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 | 4405 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
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 | 4000 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
SSIS Conditional foreach loop task
Hi SQLEnthusiast, You could use a For loop container to loop the files one by one.Answered | 4 Replies | 1649 Views | Created by CSharp Enthusiast - Monday, March 7, 2016 9:22 PM | Last reply by CSharp Enthusiast - Tuesday, March 8, 2016 4:36 PM -
1 Votes
SSIS and the FOREACH LOOP and no Connection String Property
I have the Foreach Loop set up.Answered | 12 Replies | 3493 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 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 | 7206 Views | Created by Prashu Shetty - Tuesday, January 21, 2014 1:30 PM | Last reply by Visakh16 - Tuesday, January 21, 2014 2:14 PM -
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 | 4213 Views | Created by NCooper - Tuesday, February 10, 2009 4:19 PM | Last reply by NCooper - Monday, February 16, 2009 4:23 PM -
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 | 2334 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
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 | 976 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 | 1343 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 | 1252 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 | 1194 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 | 3721 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 | 1588 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 | 4909 Views | Created by BigErn782 - Wednesday, September 1, 2010 10:10 PM | Last reply by BigErn782 - Thursday, September 2, 2010 6:53 PM
No announcements