No announcements
Found 1178590 threads
-
1 VotesforEach loop to execute a folder of power shell scripts
\tables | foreach { & $_.fullname $server $database } imfrancisd, you're right spaces in file names breaks the "invoke-expression" example, ...Answered | 8 Replies | 4991 Views | Created by RPCASEY001 - Thursday, November 26, 2009 3:48 PM | Last reply by Shay Levi - Saturday, November 28, 2009 3:02 PM
-
0 Votes
Power Shell Foreach loop with imported file pausing / stopping for long periods
Your line of questions lead me to add an output field to the loop to see what site was stopping during the process.Answered | 10 Replies | 856 Views | Created by Rich369 - Monday, February 17, 2020 7:57 PM | Last reply by Rich369 - Monday, February 17, 2020 10:50 PM -
0 Votes
Foreach loops output in Different files.
When coding in any language or system it is always important to avoid interim variables and unnecessary code.Answered | 7 Replies | 815 Views | Created by Shriram14 - Monday, July 15, 2019 10:35 AM | Last reply by jrv - Monday, July 15, 2019 11:37 AM -
0 Votes
Stopping a SSIS Foreach loop at a certain time.
James, I am working on a similar project where I want to take an 835 file an import it into a database.Answered | 6 Replies | 8833 Views | Created by JamesNT - Sunday, November 14, 2010 6:28 PM | Last reply by JamesNT - Wednesday, March 9, 2011 1:44 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 | 4221 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
Foreach loop transformation not stopping after files completed the execution
Hi, design your for each loop to test for a condition if thencurrent file should be processed or not...Answered | 1 Replies | 1716 Views | Created by ChandraShekhar Gurrapu - Friday, February 1, 2013 8:34 PM | Last reply by silna - Saturday, February 2, 2013 4:00 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 | 4081 Views | Created by NCooper - Tuesday, February 10, 2009 4:19 PM | Last reply by NCooper - Monday, February 16, 2009 4:23 PM -
0 Votes
for each loop container doesnt stop
Then you can import the flat file to table in a dataflow task in a batch way.Answered | 13 Replies | 2796 Views | Created by SQL Insane - Monday, November 21, 2016 6:41 PM | Last reply by Gene Daigle - Thursday, November 24, 2016 4:18 AM -
0 Votes
ForEach Loop Container missing Foreach File Enumerator
What is the default enumerator when you click Collection in for each loop?Answered | 9 Replies | 5746 Views | Created by Brandong - Monday, August 24, 2009 9:53 PM | Last reply by Brandong - Thursday, August 27, 2009 9:28 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 | 39912 Views | Created by Cylon2005 - Wednesday, April 4, 2007 11:49 PM | Last reply by Sifiso Ndlovu - Thursday, August 3, 2017 6:41 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 | 4853 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
Foreach loop for flat file output
Anything parallel or looping, results are unpredictable.Answered | 4 Replies | 811 Views | Created by Buster Coder - Saturday, May 9, 2015 7:47 PM | Last reply by Buster Coder - Tuesday, May 12, 2015 4:30 AM -
0 Votes
foreach loop iteration
Thanks, Shalin Do you have your file system task in the foreachloop our outside the foreach ...Answered | 9 Replies | 4945 Views | Created by Shalin83 - Thursday, July 7, 2011 6:22 PM | Last reply by Shalin83 - Friday, July 8, 2011 2:23 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 foreach ...Answered | 9 Replies | 11131 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 IN SSIS
Use the Foreach Loop File Enumerator.Answered | 3 Replies | 1353 Views | Created by geneeyussTgr8 - Monday, December 16, 2013 7:13 PM | Last reply by SSISJoost - Tuesday, December 17, 2013 9:08 AM -
0 Votes
ForEach Loop
I have a ForEach loop.Answered | 4 Replies | 3405 Views | Created by Pete Newman - Friday, June 22, 2012 3:38 PM | Last reply by ArthurZ - Friday, June 22, 2012 4:36 PM -
0 Votes
Exit loop ForEach
above one frome Mike Crowley didn't work after some research I put -ea "Stop" at the end of each script (please see below) and it workes Try { $CSV = ipcsv ...Answered | 3 Replies | 1130 Views | Created by asif300 - Friday, November 15, 2013 7:48 PM | Last reply by asif300 - Saturday, November 16, 2013 6:14 PM -
0 Votes
Microsoft Power shell script in Exchange 2010
I tested with jpeg files and it worked.Answered | 6 Replies | 603 Views | Created by RavulaRamana - Saturday, April 9, 2016 12:58 PM | Last reply by Patrik L - Monday, April 11, 2016 7:47 AM -
0 Votes
power shell table issue
Hello, PowerShell files have a .ps1 extension instead of a .vbs extension.Answered | 2 Replies | 1230 Views | Created by Najeh Jalil - Wednesday, November 19, 2014 5:32 PM | Last reply by Just Karl - Tuesday, November 25, 2014 9:33 PM -
0 Votes
SSIS Foreach Loop Container - looping progress frozen after first file
I have an SSIS 2005 package migrated to SSIS 2008 BIDS ; in this package, I have a Foreach loop container, which reads text files from A to E, i.e. 5 files.Answered | 1 Replies | 1014 Views | Created by sph1777 - Friday, April 29, 2016 1:07 PM | Last reply by ArthurZ - Friday, April 29, 2016 3:27 PM - Items 1 to 20 of 1178590 Next ›
No announcements
