Sir I am using flat file source and data conversion and script component I want to capture the row which has error and column name I am inserting the data into script component

very nice video for beginner

Thank you Sir. If table has more than 100 columns then how we will do it

nice explain

Thanks, brilliant

Thank you so much. How to change this logic to read the files in parallel and load into the target in parallel instead of sequentially? The actual requirement is a SQL task prior to the Foreach Loop is feeding a list of databases against which same SQL has to be run in parallel (as the SQL runs for a long time) on all the databases that the Foreach Loop receives and the data extracted from each database should be loaded to the same target table in the target database.

GURUUNATAHAAA

wow, very well explained 👍

Please don’t stop uploading videos please

Your Videos are awesome sir

Great Explanation and very informative !

VEry Nice. Easy to understand.

This is very nice video. I am learning SSIS and in 1st watch, i have understood many things from this video. Thank you so much .

apart from using the c# code in script task to extract the file extension, we can also use the ssis expressions which are going to be the combination of ssis functions with literals symbols and operators that we can use to extract the file extension from filepath or filename using the below code.. REVERSE(SUBSTRING(REVERSE(@[User::FileName]), 1, FINDSTRING(REVERSE(@[User::FileName]), ".", 1) - 1)) we can use the precedence constraints and evaluate the expressions and based on the file extension we can move the files to different data flow loads

Very informative video sir thankyou❤️

i am getting the following error when trying to connect excel connection manager. can you please help TITLE: Microsoft Visual Studio ------------------------------ There was an error displaying the preview. ------------------------------ ADDITIONAL INFORMATION: Too many fields defined. (Microsoft JET Database Engine) ------------------------------ BUTTONS: OK ------------------------------

it will be good if you add files used while creating package.

Thanks. I did this 5 years ago as an integration developer. This was a great refresher. 👍

I am working on a Data Management Assignment. I am facing some issues with how to approach this task. I need help with designing a data ware house. I have a CSV file and I have to create a data warehouse for this dataset. I also need help with ETL process using MS SQL Server and SSIS. After ETL I have to do some visualizations. I am confused if I shall create tables for the columns that I would use for creating visualizations. The link to pdf file is here: drive.google.com/file/d/1lSRBVq1cOHwXnljHswliZor6bXzJX5AL/view?usp=sharing The link to the CSV file is within this pdf file. Sir I am requesting you to please guide me with this project. Than you.

The way you explained the ETL process from the scratch is just amazing.

When do I use join and when do I use lookup?

What we need to if we don't have 7zip in my VDI

I am unable to see tool bar in visual Studio when I open a existing package

Very good explanation and please do videos on Team Foundation Server Sir mostly no proper videos in KZbin

If I have exported an existing production package as .ispac file then how I should deploy back to production catalog.

Nice video

Perfect video And the best explaination Thank you very much for a perfect work

Well explained, thank you Aqil sir

Thanks for the video.Very helpful

thank you so much

I'm new to SSIS Sir, Your explanation is perfectly clear and helpful.

suppose we dont have any pk in fact table?

First Thanks a TON.. i was searching this concept everywhere but when i saw your video i m so much relaxed, please share more videos on SSIS and SQL interview questions...

Superb

visual studio 2022 error "The connection manager 'Excel' is not properly installed on this computer" I would be grateful for your help

Simple and super

How to deploy exsist dtsx package?

Great video.. The value for my username and my password ? That’s where throw me off.. idk.. i get this error after everything was entered fine in the script task: Error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Authentication Required. Learn more at Task Send Email Using Script Task failed

M not able to read that ssms environment variable in my script task need help

I wanted to read the password from ssis catalog environment variable

This is a great video. But I have one wish! Is there a way to capture the name of the component that triggered the error handler? What I see in this example is the name of the Task that is inserting the record. I'm more interested in capturing the culprit's name.

Good starter example, looking forward to finding more examples where the script is used, multiple tables are being transformed using ETL with proper error handling .NET Application is executed using SSIS, etc. Thanks for the video, much appreciated.

Hi, Just now i saw your video its very helpful for me can you pls do video for remaining containers means foreach and sequence and can you pls do clear video seperately for data flow and seperately for control flow with live examples

thank you for your tutorial . But Can I ask some queries to you ? I saw results, 2 values are being null in Visited Date column in SQL . Please let me know why ?

i am getting this error while reading from csv file to oledb : Error at Data Flow Task [OLE DB Destination [276]]: The column "NAME_ID" cannot be processed because more than one code page (65001 and 1252) are specified for it. Error at Data Flow Task [OLE DB Destination [276]]: The column "HIC_NUMBER" cannot be processed because more than one code page (65001 and 1252) are specified for it. Error at Data Flow Task [OLE DB Destination [276]]: The column "MEMBER_ID" cannot be processed because more than one code page (65001 and 1252) are specified for it.

All good sir but i want each from invidual excel files anf each file to be create in sql as separate tables what should i have 300 excel files of all different files

How to open password protected zip file in ssis if we do have password?

great effort