No announcements
Found 436994 threads
-
1 VotesVariable Mapping with Foreach loop container
By using for each loop container i will try to mapping variable i got error like For each variable maaping can not be applied.Answered | 2 Replies | 1336 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
Variable Mapping of Foreach Loop
Do you want a variable to get incremented until it satisfy a condition?Answered | 2 Replies | 2042 Views | Created by Manju_2012 - Wednesday, December 5, 2012 9:46 AM | Last reply by Eswararao C - Wednesday, December 5, 2012 10:19 AM -
2 Votes
Multiple variable Foreach loop?
A: so you have to have a Email object foe each DFT (Data Flow task) -- No, I actually have 46 execute sql tasks, 46 data flow tasks and 1 foreach loop ...Answered | 4 Replies | 5737 Views | Created by swinimer - Tuesday, August 24, 2010 2:34 PM | Last reply by Nik - Shahriar Nikkhah - Tuesday, August 24, 2010 3:12 PM -
0 Votes
set variable in foreach loop
If you have your package structured as a ForEach Loop Container that's configured to iterate over the files in the folder, and to fill a variable ...Answered | 7 Replies | 1123 Views | Created by MTL2014 - Wednesday, October 26, 2016 3:10 AM | Last reply by RyanAB - Thursday, October 27, 2016 1:02 AM -
0 Votes
Need help with a ForEach Loop Container
essentially, what happens is that the foreach loop container would store the file name in an ssis variable.Answered | 3 Replies | 4000 Views | Created by PReardon - Tuesday, March 10, 2009 6:40 PM | Last reply by Duane Douglas - Friday, March 13, 2009 8:28 AM -
1 Votes
foreach loop container and data flow task
So I created the foreach loop container using the foreach item enumerator, added two rows with a single column.Answered | 4 Replies | 6057 Views | Created by JustinRush - Tuesday, December 15, 2009 8:38 PM | Last reply by COZYROC - Wednesday, December 16, 2009 12:11 AM -
1 Votes
If a Foreach Loop Container finds no files in the directory...
Hi Phil, you can't access those variables inside the foreach loop container. can you please give me the example for that (step-by-step). i would like to ...Answered | 9 Replies | 12093 Views | Created by ckbkyne - Tuesday, September 22, 2009 7:40 PM | Last reply by Manish Sharma - ETL - Tuesday, September 22, 2009 8:36 PM -
0 Votes
Foreach loop container question
When I move a foreach loop container onto the control flow area from the Toolbox and do Edit - Collection - Enumerator I do not see a selection for Foreach File ...Answered | 1 Replies | 3883 Views | Created by davebo5256 - Monday, June 27, 2011 2:41 PM | Last reply by ArthurZ - Monday, June 27, 2011 2:59 PM -
0 Votes
Foreach Loop Container and Dts.TaskResult
If I set the inner Script Task MaximumErrorCount to 99 or to 0 (infinity) it still breaks the Foreach Loop Container at the first Go. if I set the outer Foreach ...Answered | 3 Replies | 2649 Views | Created by Nuno Aragao - Wednesday, September 11, 2013 12:38 AM | Last reply by Nuno Aragao - Thursday, September 26, 2013 6:40 PM -
2 Votes
ForEach Loop Container Mapping Variable From SSIS Package Not Working In SQL-Server StoredProcedure
My problem is not knowing how to use the mapping variable from the ForEach Loop Container enumeration.Answered | 9 Replies | 2411 Views | Created by jsorrisone - Tuesday, March 11, 2014 8:00 PM | Last reply by jandho - Thursday, March 13, 2014 8:44 AM -
0 Votes
ForEach Loop Container Configuration Question
Configure the EST to use a resultset of "full", and go to the resultset tab to add one variable of type Object to receive that rowset.Answered | 4 Replies | 4902 Views | Created by BigErn782 - Wednesday, September 1, 2010 10:10 PM | Last reply by BigErn782 - Thursday, September 2, 2010 6:53 PM -
0 Votes
Cannot read filename to variable using foreach loop
You need to check the variable scope.Answered | 9 Replies | 3935 Views | Created by hoakey - Tuesday, January 5, 2010 3:23 PM | Last reply by Nik - Shahriar Nikkhah - Tuesday, January 5, 2010 6:25 PM -
0 Votes
SSIS 2008 R2 Foreach Loop Container on ADO object in Endless Loop
SSIS 2008 R2 I have an object Variable populated by a SQL Query.Answered | 2 Replies | 1679 Views | Created by Mysetdancer - Tuesday, August 5, 2014 3:44 PM | Last reply by RealSQLSantos - Monday, August 11, 2014 7:20 PM -
2 Votes
How can I save the last folder name in a Foreach Loop Container?
I was successful in it setting the foreach loop properties and using expressions with the string value of the path.Answered | 6 Replies | 4288 Views | Created by lc81 - Tuesday, February 17, 2009 12:19 PM | Last reply by lc81 - Tuesday, February 24, 2009 10:11 AM -
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 | 4497 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
Problem with variable (Excel tab name) in a Foreach Loop
1)Create a variable ValidityCheck of integer type.Answered | 5 Replies | 5584 Views | Created by LRHumberto - Thursday, October 3, 2013 10:05 PM | Last reply by Ghneim - Thursday, November 3, 2016 2:04 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 | 5107 Views | Created by Tech2175 - Wednesday, March 25, 2009 5:19 AM | Last reply by Duane Douglas - Wednesday, March 25, 2009 6:18 AM -
1 Votes
problem in ssis foreach loop container using recordset
In each loop the variable value will change.Answered | 8 Replies | 12093 Views | Created by RajneeshSingh - Wednesday, May 4, 2011 11:26 AM | Last reply by Todd McDermid - Thursday, May 5, 2011 4:23 PM -
0 Votes
SSIS Expression task can't see variables populated by a containing foreach loop
To do this, I'm using a ForEach loop with an expression task inside that is supposed to stuff the path from each iteration of the loop into a variable.Answered | 6 Replies | 4588 Views | Created by kettch - Monday, March 25, 2013 7:24 PM | Last reply by ArthurZ - Tuesday, March 26, 2013 3:19 PM -
2 Votes
Foreach loop container Foreach File Enumerator sort files
Consider using Script Task using methods from LINQ as per my article: https://www.sqlshack.com/using-ssis-foreach-loop-containers-process-files-date-order/Answered | 27 Replies | 40719 Views | Created by Cylon2005 - Wednesday, April 4, 2007 11:49 PM | Last reply by Sifiso Ndlovu - Thursday, August 3, 2017 6:41 PM - Items 1 to 20 of 436994 Next ›
No announcements
