23 Foreach loop ado enumerator in SSIS example

Foreach loop ado enumerator in SSIS example
Download the file\script used in the Video from below link

Foreach loop ado enumerator in SSIS example
What is foreach ADO enumerator in SSIS?
What is for each item enumerator in foreach loop container?
What is foreach item enumerator in for each loop container Why would you use it?
How do I pass multiple parameters in foreach loop in SSIS?

[michaelmuell]

Your Channel is an absolute goldmine. Thanks a lot!

[SaraNeiman]

Amazing course, exactly what I need, thank you so much for creating it

[motoray]

Thanks for this video...just helped me solve a problem I was struggling with.

[javaguitarist]

Thank you so much. This helped me enormously.

[kavithagunashekar]

Thank you for the video, it really helped my problem :)

[deepikarawat]

Sir, Thanks for your Videos... Really Helpful... :)

[AshishPatel-ylbk]

How to run same SQL script across different SQL servers using Each Loop ?

[khaledmahmoud]

please in need the same example using excel becuse i have issue in connection string
The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.

[vinayprasad]

Good video, got a question, in sql task properties when you are setting up resultset, you put 0 for the result name, can you please explain that briefly

[khbeyonce]

Aqil bhai, just a quick question why did we create FilePath variable as I don't see we used it anywhere

[govindasindhu]

When we want our result set as single row in execute SQL task such that it must iterate through each value then what to use in ado object source variable .? User:objcontractid I used but it is throwing error can you please suggest the changes

[ibkcjqj]

Hey there, I have a question regarding my database setup. I have a table(Directory), there are few columns that store error flags, using "ERROR" or "OK" to indicate errors. I also have another table that stores the names of columns with error flags.

I'm wondering if I can use a Foreach Loop to dynamically retrieve these column names and generate an Excel file for each column where the data is "ERROR."

In my Execute SQL Statement, I'm currently using the command: select distinct ERROR from Error_Name;
Where "ERROR" is the column name and "Error_Name" is the table storing all the columns with error flags.

Within the Foreach Loop, I'm configuring the data flow in the OLE DB Source Editor, and for the Data Access Mode, I'm using SQL Command Text with the following query: select * from Directory where ? like '%ERROR%';

My question is whether this setup is appropriate for achieving my goal of dynamically generating Excel files for columns with "ERROR" data. Will the SQL Command inside the data access mode recognize the '?' parameter? I want to ensure that it properly substitutes the parameter with the column names when executed.

Any advice or suggestions would be greatly appreciated!

[dilipkumar-cknc]

In expression builder what u write is not visible can u make a note in notepad

[parvanekhemati]

Hi please tell me where is the connection manager window, I can't create an Expression

[MVinodKumar-tttu]

Hello Sir,
When I used Objcity variable datatype as String i got this error
"
[Execute SQL Task] Error: Executing the query "SELECT DISTINCT CITY FROM PERSON.ADDRESS" failed with the following error: "The type of the value (DBNull) being assigned to variable "User::ObjCity" differs from the current variable type (String). Variables may not change type during execution. Variable types are strict, except for variables of type Object.
". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

"
As we know we got this error because I need to use Object as datatype bcz we are getting more than single row. But i didnt understood what is this error sir? Please Explain sir

[satishchoudhury]

I want to extract data for 2 years..
but monthly wise extract
i.e 24 files need to be generated automatically based on date

How to loop this condition

[Shankar-ziyk]

why u have taken newyork has cityvariable value because u know the value is present if u dont know how will u go for that value u should explained that wright please make a video on for and for each loop containers in detail each and every point

[Shankar-ziyk]

u have used a filepath variable and u havent used it why confusing us

[learner_SSIS]

Hi sir, i follow same video in odbc MySQL ( MySQL workbench. And Hiedisql) not working

Very easy to work OLEDB side, but ODBC very difficult sir

Please upload ODBC video sir