No announcements
Found 1602217 threads
-
0 Votespass CSV variable to foreach
replacing the {} from the filter with double quotation marks and single quotation marks around the variable seems to have worked: $Dls = ...Answered | 3 Replies | 638 Views | Created by PaulT15 - Friday, October 7, 2016 1:13 PM | Last reply by Mike Laughlin - Friday, October 7, 2016 2:36 PM
-
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 | 3759 Views | Created by PReardon - Tuesday, March 10, 2009 6:40 PM | Last reply by Duane Douglas - Friday, March 13, 2009 8:28 AM -
0 Votes
Script to get-aduser information from csv file with foreach loop and export-csv with specific column order.
You cannot export from a pipeline without using the pipe character.Answered | 3 Replies | 22919 Views | Created by ETphoneHome5 - Wednesday, June 21, 2017 10:13 PM | Last reply by jrv - Thursday, June 22, 2017 3:44 PM -
3 Votes
Regarding passing several variables to a foreach loop
How do you want 2 variables to be used inside for each loop.Answered | 4 Replies | 779 Views | Created by Mattias Elfgren - Monday, June 9, 2014 10:22 AM | Last reply by DeepakKumarKalyanum - Monday, June 9, 2014 12:22 PM -
0 Votes
Using output from Foreach Loop for Variables
$Database = import-csv Database.csv -Delimiter ';' foreach ($Data in $Database) { Update-UserOwnership -Machine_id (Get-DesktopVM ...Answered | 8 Replies | 3201 Views | Created by Declan G - Monday, July 27, 2015 2:31 PM | Last reply by jrv - Wednesday, July 29, 2015 12:41 PM -
0 Votes
Run Stored Procedures Outside a Foreach Loop Container, without the Foreach Loop waiting for completion prior to moving on
For instance, lets say i enter the foreach loop and product1 starts to process.Answered | 5 Replies | 1668 Views | Created by george0112 - Tuesday, August 13, 2013 3:14 PM | Last reply by jakubk - Wednesday, August 14, 2013 2:58 AM -
0 Votes
Exit loop ForEach
If you have nested loops you can assign labels to the loops and control which one you want to break out of.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
Pulling hash out of loops (foreach)
For example: $csvData = @( new-object PSObject -property @{ "Name" = "Value 1" } new-object PSObject -property @{ ...Answered | 4 Replies | 660 Views | Created by Joe Kelley - Tuesday, October 14, 2014 10:11 PM | Last reply by Joe Kelley - Tuesday, October 14, 2014 10:37 PM -
0 Votes
Row Count of various destinations within a Foreach Loop Container
So after the Foreach loop you will have the total value in the above variable.Answered | 12 Replies | 10921 Views | Created by psudershan - Friday, November 13, 2009 12:17 PM | Last reply by Shivendoo Kumar Dubey - Monday, October 14, 2019 3:26 AM -
0 Votes
Problem with ForEach Loop and rowcount
You can avoid package from failing by setting Propagate variable to false and continue with next sheet on failure.Answered | 2 Replies | 1006 Views | Created by SuzSQL - Monday, March 3, 2014 8:35 PM | Last reply by Visakh16 - Thursday, March 6, 2014 4:45 PM -
2 Votes
Powershell - Write-output on same row as variable in foreach loop?
The answer is that "$_" is the pipeline variable containing the object passed from the previous command.Answered | 23 Replies | 8103 Views | Created by Hennay - Tuesday, July 2, 2019 1:23 PM | Last reply by jrv - Thursday, July 4, 2019 9:29 AM -
0 Votes
ForEach Loop
I have a ForEach loop.Answered | 4 Replies | 3403 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
Import-CSV foreach
Because you have multiple pipes, you need to store value of items coming from first pipeline in a variable and then use it in next pipeline for comparison. something like ...Answered | 4 Replies | 20055 Views | Created by MessageUndeliverable - Wednesday, April 13, 2016 11:00 AM | Last reply by MessageUndeliverable - Thursday, April 14, 2016 7:12 AM -
3 Votes
SSIS - Continuous row count in a ForEach Loop
Once I'd received the error, I then went on to read the detail in the links that you put up Lily, and the first one Create a Row Id was an extension of what Yitzhak had ...Answered | 6 Replies | 2248 Views | Created by MichaelJamesParker - Friday, July 3, 2020 10:36 AM | Last reply by MichaelJamesParker - Monday, July 6, 2020 10:56 AM -
5 Votes
nesting foreach loops for file copy or move
foreach is your normal loop, foreach-object is a foreach loop but used across the pipeline.Answered | 26 Replies | 2786 Views | Created by Wasisname - Friday, August 9, 2013 8:22 PM | Last reply by clayman2 - Monday, August 19, 2013 4:59 PM -
0 Votes
foreach loop - insert record in table
That way, you can load up the data in another Data Flow to do your second pass.Answered | 4 Replies | 5716 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
SSDT - Foreach ADO Enumerator Issue with an extra loop
Hi LeoG71, Could you please share the screen shot of the Execute SQL Task and Foreach Loop Container?Answered | 3 Replies | 966 Views | Created by LeoG71 - Wednesday, September 25, 2019 5:21 PM | Last reply by LeoG71 - Friday, September 27, 2019 4:16 PM -
0 Votes
Get-ChildItem problem in foreach loop
BTW, it is good way to loop to retrieve file's Last Access time?Answered | 8 Replies | 10166 Views | Created by david yeung in lost - Tuesday, May 7, 2013 4:57 PM | Last reply by jrv - Wednesday, May 8, 2013 4:26 AM -
2 Votes
Feeding a Foreach loop with an Execute SQL statement
The Foreach Loop will execute for each row in the table, with the values from the current row in the three variables created above.Answered | 3 Replies | 9735 Views | Created by Spike00 - Saturday, November 14, 2009 11:44 PM | Last reply by Spike00 - Monday, November 16, 2009 1:27 PM -
0 Votes
Force PowerShell ForEach loop to run sequentially
The pipeline processes each object from the beginning to the end of the pipeline before the next object is passed.Answered | 27 Replies | 2755 Views | Created by Shawn 'Cmdr' Keene - Wednesday, September 30, 2020 10:38 PM | Last reply by jrv - Wednesday, October 7, 2020 9:28 PM - Items 1 to 20 of 1602217 Next ›
No announcements
