No announcements
Found 2212559 threads
-
2 VotesHow can I save the last folder name in a Foreach Loop Container?
I've solved my problem.Answered | 6 Replies | 4259 Views | Created by lc81 - Tuesday, February 17, 2009 12:19 PM | Last reply by lc81 - Tuesday, February 24, 2009 10:11 AM
-
0 Votes
Unexpected behavior of Foreach Loop in SSIS 2012
Add a ForEach loop container 3.Answered | 9 Replies | 3267 Views | Created by Vishal Karve - Wednesday, February 19, 2014 11:12 AM | Last reply by Vishal Karve - Friday, February 21, 2014 6:25 AM -
0 Votes
Knowing which variable is being used in a Foreach loop container
What kind of enumerator are you using?Answered | 3 Replies | 3249 Views | Created by avfc1982 - Monday, January 6, 2014 11:21 AM | Last reply by SSISJoost - Monday, January 6, 2014 7:11 PM -
0 Votes
Specifying multiple file types in SSIS Foreach loop Container e.g: .txt and .dat
If you want multiple file types in one Foreach Loop you could use regular expressions ^.*\.Answered | 9 Replies | 15862 Views | Created by SQL_Admirer - Thursday, August 2, 2012 4:56 AM | Last reply by SSISJoost - Friday, August 3, 2012 7:09 AM -
0 Votes
SSIS Foreach Loop Copy within SubFolders
My source folder structure is like ...Answered | 12 Replies | 11354 Views | Created by Deputy12 - Wednesday, May 15, 2013 5:03 PM | Last reply by Rajkumar5055 - Saturday, May 18, 2013 6:43 AM -
1 Votes
Run the foreach loop container if file exist
Now I want to load and count only those files which filename contain %vendor%.Answered | 4 Replies | 5717 Views | Created by Vipin jha - Tuesday, August 25, 2015 9:15 AM | Last reply by MichaelAdrianJohnson - Wednesday, August 26, 2015 4:29 AM -
0 Votes
SSIS For Loop Container Question
I was able to update the variable using a script task and the for loop worked.Answered | 7 Replies | 4356 Views | Created by larson311 - Wednesday, May 23, 2012 1:55 PM | Last reply by larson311 - Monday, June 11, 2012 5:02 PM -
1 Votes
If a Foreach Loop Container finds no files in the directory...
The problem with this solution is that the user does not want the task AFTER the foreach loop (not inside the foreach loop) to execute if the ...Answered | 9 Replies | 11816 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 - insert record in table
IMO, bad way to solve that problem.Answered | 4 Replies | 5896 Views | Created by Parry2k - Friday, October 22, 2010 10:34 PM | Last reply by Todd McDermid - Friday, October 22, 2010 11:27 PM -
0 Votes
SSIS - Skipping iterations in For Each Loop
you can implement condition inside foreach with combination of script task and variables and expression, look at this sample ( note that in the sample loop through files considered, ...Answered | 1 Replies | 7480 Views | Created by Sudahh - Thursday, December 30, 2010 9:28 AM | Last reply by Reza Raad - Thursday, December 30, 2010 11:42 AM -
0 Votes
foreach loop container - foreach ADO enumerator how performance compares to use of cursors in stored procs
However, I would guess that the cursor would perform better with large amounts of data, given that the operations can be performed on the database server, rather than having to make the round trip ...Answered | 3 Replies | 6180 Views | Created by Armine - Tuesday, April 22, 2008 9:49 PM | Last reply by SQL Lion - Tuesday, July 21, 2009 3:40 PM -
0 Votes
Problem with variable (Excel tab name) in a Foreach Loop
select case when @SheetName like '%xlnm#_filterdatabase' then 1 else 0 end as checkvalue" ParameterMapping = Map the variable @SheetName ...Answered | 5 Replies | 5475 Views | Created by LRHumberto - Thursday, October 3, 2013 10:05 PM | Last reply by Ghneim - Thursday, November 3, 2016 2:04 AM -
0 Votes
Managing the failure of a Foreach ADO Enumerator container - SSIS 2012
Yes, please check these ...Answered | 5 Replies | 2665 Views | Created by pscorca - Thursday, July 9, 2015 3:30 PM | Last reply by Anuj Tripathi - Friday, July 10, 2015 4:32 PM -
0 Votes
SSIS Expression task can't see variables populated by a containing foreach loop
Expressions are evaluated once at the beginning of the package execution or the For Loops so they can not be used to assign/append values as you initially intended it to ...Answered | 6 Replies | 4486 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 Mapping Variable From SSIS Package Not Working In SQL-Server StoredProcedure
I fixed the problem.Answered | 9 Replies | 2347 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 of SSIS Package hidden error!
sql-server-integration-services - Microsoft Q&A Regards, Dave Patrick ....Answered | 1 Replies | 1180 Views | Created by Abdullah Saad Alshehri - Sunday, December 27, 2020 8:15 PM | Last reply by Dave Patrick - Sunday, December 27, 2020 8:46 PM -
0 Votes
foreach loop iteration
@SUDEEP - I am not able to use file system task outside of loop becaus i have used source variable which is related with foreachloop container.Answered | 9 Replies | 5159 Views | Created by Shalin83 - Thursday, July 7, 2011 6:22 PM | Last reply by Shalin83 - Friday, July 8, 2011 2:23 PM -
0 Votes
Retain connection, avoid re-loading data in ForEach Loop Container while processing in-memory
If you know what value you're looking for, you could get the value from the source instead of using a foreach loop.Answered | 13 Replies | 1554 Views | Created by BNicolasB - Friday, December 27, 2019 9:52 PM | Last reply by BNicolasB - Sunday, February 2, 2020 2:08 PM -
0 Votes
For Loop using SSIS Variables
The For Loop is used for looping through a number of tasks for a set number of times.Answered | 2 Replies | 1272 Views | Created by siera_gld - Sunday, January 10, 2016 3:46 AM | Last reply by Charlie Liao - Sunday, January 17, 2016 5:47 AM -
0 Votes
how to foreach an List variable
List<string> list = new List<string>(); Dts.Variables("FileList").Value = list how to use foreach ...Answered | 3 Replies | 1582 Views | Created by Andrea Pirlo - Monday, May 6, 2013 3:52 PM | Last reply by ArthurZ - Monday, May 6, 2013 5:36 PM
No announcements
