01 Introduction to SSIS | Create your first SSIS package

[@cooldwnload]

This is the best of all SSIS on KZbin. One stop place to ramp up yourself on SSIS. thank you!

[@learnssis]

Thank you so much Dev for your appreciation.

[@HarshaV44]

Hello Sir, Thanks for uploading the SSIS videos Just today I have started to learn SSIS and found your channel the video is very easy to understand clearly and to start SSIS. Thank you I'll continue to watch your next videos

[@learnssis]

Thank you so much Harsha vardhan for your appreciation. Welcome to the world of SSIS. I hope you will find the videos informative. Stay tuned.

[@rams_here]

This is the TOP channel and content for SSIS, Thank god I found this channel at right time :)

[@learnssis]

Thank you. Glad you found the channel helpful.

[@mugdhaapte]

Hi Aqil. Thanks for such a simple and to the point explanation of this topic. I have subscribed to your channel and would like to learn more about such topics. Thanks for making a non-jazzy, shoo sha videos like others do with their fake english accents, obnoxious commentary and graphics. Your ease of navigating things shows how skilled you are in your work. Congratulations and many thanks.

[@learnssis]

Thank you Mugdha for appreciating. If you got any questions then you can comment on the video or email me at [e-mail]. Happy Learning.

[@luke2042]

You're English is very good. Thank you for this helpful video!

[@learnssis]

ha ha, its not that good, but anyway thank you.

[@Hari_Ramana]

I have installed ssis and sql server, But when i am trying to add connection for destination source after providing server name there are no options appearing as SSIS or anything. Where might i have gone wrong?

[@learnssis]

SSIS is a database that I created. On sql server execute below query this will create a SSIS database create database SSIS

[@kunchapusrikanth4919]

thank you so much for SSIS Videos 😊😊😊 I think definitely useful for my career

[@learnssis]

Thank you Kunchapu Srikanth for your comment.

[@kamizanamirudin4017]

bro, i respect you so much. your video is in english, even your pronunciation not really good, but you did well. i hope others indian people can take you as example. also, the cc is really helping me a lot. this video help me to understand the concept of ssis even just a glimpse, with some effort, i believe i can gain understanding in ssis, since this will help a lot in production on my company for century updated related flat files. thanks again, more respect to you

[@learnssis]

Thanks for your comment.

[@ramchandra833]

you deserve the best bro, very Informative and usefull. Thanks keep doing!!

[@learnssis]

You are most welcome Bro.

[@tahirsyed1346]

The best tutorial in a few minutes, thanks

[@ho3inv33]

thank you for sharing your knowledge. brief and helpful.

[@learnssis]

Thank you.

[@marketfinds]

Had to Install the SQL Provider Manually but after that worked a treat! Great Introduction and Tutorial.

[@muhammadnadeemmn]

This is really a great video, Very precise explanation - Was looking for such video for a long time and finally found it. Thanks for your help.

[@learnssis]

Thank you so much Nadeem for your kind words. Its good to know that you liked the video.

[@madhavanrao3626]

Thanks a lot for sharing valuable information 👏👏👏👏👏👏👍👍

[@learnssis]

Thank you Madhavan.

[@quackaddict9810]

Hi Sir, thanks for uploading these videos. I want to become more proficient with SSIS and this will help.

[@learnssis]

Glad you found the video helpful.

[@dipeekagiradkar6661]

It is very helpful, and I was able to create my first SSIS package successfully. Thank you!

[@learnssis]

Good to know Dipeeka that you started learning SSIS. All the best for learning SSIS.

[@narayanaredde8721]

Good bro This video's helps lot to me ,sharing your experience with this course is a great idea .Thank you bro

[@learnssis]

Thank you so much Narayana for appreciating the video.

[@yuvrajb4696]

I will watch all videos now onwards

[@learnssis]

Sounds great. I am sure they will help you to learn the SSIS concepts.

[@arafahnugroho5347]

Jazakallah Khairan Aqil Bhai :)

[@chinenyeelochukwu2279]

Great teaching and detailed explanations. Thank you so much

[@learnssis]

You are most welcome.

[@jafarmohammedumar-r7l]

Thie was Awsome Jazakallah

[@learnssis]

Shukriya Bhai.

[@fisherchi]

Thanks for tutorial. Very helpful in understanding what SSIS is really used for.

[@learnssis]

You are most welcome Ervin S.

[@sathya8242]

simple and superb explanation with a great execution skill

[@learnssis]

Thank you Sathya for appreciation.

[@khajarasool]

Thank you so much for your tutorial. It was very helpful to us..

[@learnssis]

Thank you Rasool Basha.

[@jigneshvyas3105]

Hi Aqil. I can not thank you enough for the videos. Great work. You have made the whole series available for free, which is very kind. A quick question. Can a flat file source only work when csv files are sitting on a local computer? what are the other approaches when you want to import csv files from a server and load them into sql tables? Sorry if my question sounds stupid.

[@learnssis]

Thank you so much for your kind words. If you want to load the CSV file into sql server table, then other than flat file source 1. We can use Bulk Insert Task in SSIS to load the csv file into sql server table. 2. We can use a Bulk Insert sql query to import the csv file into a sql server table like below BULK INSERT SchoolsTemp FROM 'C:\CSVData\Schools.csv' WITH ( FORMAT = 'CSV', FIELDQUOTE = '"', FIRSTROW = 2, FIELDTERMINATOR = ',', --CSV field delimiter ROWTERMINATOR = ' ', --Use to shift the control to next row TABLOCK )

[@kunwarmaurya2025]

Thanks Very Much for such a detailed information: I was confused before watching your video😊

[@learnssis]

Very nice to hear that you liked the video. Thanks for your response.

[@MD-lu6lb]

Do you have a video on how to tune a package that runs in visual studio fast but run very slow in in initial catalog after deployment. The package doesn’t have any transformation.

[@learnssis]

I don't have the video on the exact topic but I have the video on performance tuning of SSIS packages which you might take a look kzbin.info/www/bejne/aaHElKuNmrmWm5Y kzbin.info/www/bejne/baSudpqjZ9qEe68 kzbin.info/www/bejne/eYq9noCkfMuSoJY

[@akhilvulli]

Very helpful brother will finish entire SSIS videos.

[@learnssis]

Great.

[@hassanalianees5530]

Brilliant Boi

[@learnssis]

Thank you Anees bhai.

[@rhoylleEmpire]

Beautiful

[@learnssis]

Thank you John Bosco.

[@cargouvu]

Are there any performance issues with stand alone ssis compared to ssis through Azure Data Factory that orchestrates the data process? I had an interview and the hiring manager said they are having this issue. I hope to read up on it ahead of the start date.

[@learnssis]

I have not worked with ssis through Azure Data Factory. Just worked SSIS as a stand alone, thus not sure about this.

[@draishwarya-s5c]

while adding a connection in OLE DB , in dropdown SSIS is not showing. i tried various methods but not useful? can you please with this issue?

[@learnssis]

SSIS is a test database that I created, you can create the SSIS database on SQL Server then it will show up.

[@abhishekmukherjee9004]

If I choose an sql serverdestination instead of OlDB.. Is it do the same?

[@learnssis]

yes it will work same however sql server instance should be installed on the same machine from where you are running the package.

[@josejesusanez5536]

Hello Sir, I have this issue when trying to connect SQL Server "The specified provider is not supported. Please choose different provider in connection manager." VS 2022 any idea ?

[@learnssis]

Right click on OLE DB Connection Manager, Select Edit, From Provider, select "Microsoft OLE DB Provider for SQL Server"

[@josejesusanez5536]

you are very kind, I appreciate your time ! @@learnssis

[@laser1915]

Great Introduction

[@learnssis]

You are most welcome @laser1915.

[@ZMoviesAndTVShows]

Thank you, very helpful

[@learnssis]

You are most welcome.

[@nagoorshaik-j4s]

Sir Your Explanation SUPER 👌in SQL and SSIS, Could you please also added the classes power bi and ADF

[@learnssis]

Thank you, I was planning but right now I am a lot of busy on other assignments and not getting time to make videos.

[@SAMEERUNAWANE-w6p]

sir i want to create a SSIS package of store procedure with parameter but i want to exclude those parameters. plz guide me

[@learnssis]

Sorry I did not get you. You want to create ssis package of stored procedure with parameter but do not want those parameters ?

[@SAMEERUNAWANE-w6p]

yes @@learnssis

[@SAMEERUNAWANE-w6p]

actually is ssms it has parameters so it generates a report based on that but i want to exclude those parameters

[@learnssis]

@@SAMEERUNAWANE-w6pSo you have a stored procedure that has parameters. Now you want to call that stored procedure from ssis ? if yes then how you will pass the value of input parameter to stored procedure ?

[@SAMEERUNAWANE-w6p]

@@learnssis that is my doubt. because that sp is fetching data from different tables to generate new table

[@shahiinalam]

Excellent Work

[@learnssis]

Thank you Shahin.

[@trumbaron]

Very good stuff@ Thank you!

[@learnssis]

Thank you so much for appreciating.

[@venulook9942]

hi aqil , can we instal multiple ssdt tools like I have already ssdt 2017 in my system so can i install 2019? or what step shoud i take according to videos i have to follow ssdt 2019 or wahtever it may be its fine ahh?

[@learnssis]

yeah we can install multiple versions of SSIS tools. Even I have both SSDT 2017 and SSDT 2019 installed on my machine.

[@tulasiramaallada2169]

Which version is this ?

[@Latif127]

Very good tutorial, thank you

[@learnssis]

Thank you Latif for appreciating.

[@MdOwaisRumi]

please help....im facing problem in creating OLE DB Connection. i have tried a lot ...please tell how to fix it

[@learnssis]

Email me the screenshot of creating it or make a very small video and send it to me at [e-mail] When creating the OLE DB Connection manager, from the Provider, make sure you have selected "Microsoft OLE DB Provider for SQL Server"

[@zealbehappy5896]

I have file location path store in sql and i want move only store path file from particular folder by ssis

[@zealbehappy5896]

Pls guide me

[@learnssis]

@@zealbehappy5896 You can use a foreach loop container with ado enumerator and loop through those files, inside foreach loop container you can use a file system task to move the files. kzbin.info/www/bejne/f5PMlnd3ltmZa68 kzbin.info/www/bejne/aqCVp3WfZ9SepJY

[@learnssis]

Can you tell more if the source file path is stored in the sql table or just file name without full file path, and what about the destination folder where that information is stored ?

[@MdOwaisRumi]

I'm facing problem in creating a OLE DB Connection . I have tried a lot please help me how to fix it .

[@learnssis]

Email me the screenshot of creating it or make a very small video and send it to me at [e-mail] When creating the OLE DB Connection manager, from the Provider, make sure you have selected "Microsoft OLE DB Provider for SQL Server"

[@Iamyou0075]

sir this tutorial will help me to work on realtime scenarios

[@learnssis]

Good to know that it can help you Shahul Shaik.

[@Iamyou0075]

Tq Sir And i hope it will give full strength In ssis realtime work

[@learnssis]

@@Iamyou0075 Yeah sure it will. I have created a lot of videos those covers a lot of different scenarios those you can face while working on ssis projects. If you check the description of video you will find 3 playlists related to SSIS which can help you to learn SSIS.

[@knawazali5225]

Bro, Connection manager ek top up araaa like the specific provider is not supported please choose different provider in configuration manager

[@learnssis]

It seems like there is some issue with SSIS installation, try to uninstall SSIS and reinstall SSDT learn.microsoft.com/en-us/answers/questions/1258009/vs-19-ssis-project-getting-and-error-the-specified

[@finalcrusade777]

Hello sir Can you help me how to transform a cloumn and its respective records with float data type to DATE data type and all the records of the column accordingly in SSIS?

[@learnssis]

You can use a data conversion transformation in between the Excel Source and and OLE DB Destination and select the data type as DT_DBDATE or DT_DBTIMESTAMP. You can watch a video below like how to use data conversion transformation in SSIS kzbin.info/www/bejne/l4KtdJ6vZ9aZedU

[@finalcrusade777]

@@learnssis yeah i did sir...but didn't happen ...would you please make a video by converting the above mentioned column....step by step sir??

[@learnssis]

@@finalcrusade777 Sure I will. Currently I am out of the station, once I reach home then I will surely make a video on this one. Can you please send the test excel file to [e-mail] so that I can use that file in the video.

[@finalcrusade777]

@@learnssis sure sir...by the way...your suggested video helped me in converting the data...thank you so much sir...

[@learnssis]

@@finalcrusade777 Glad it worked for you.

[@antoniolupen6138]

Opening VS 2019 in ' Create a new project' , there is no 'Integration Service project' option. What i´m missing?

[@learnssis]

You need to download and install SSDT for Visual Studio 2019. kzbin.info/www/bejne/Zn_Sq3yMpLOsj5Y

[@mohangundu3060]

Hi, how to import data from multiple excel sources to sql db respective multiple (individual) tables by using SSIS script task (C#)

[@learnssis]

You can take a look at below video kzbin.info/www/bejne/l6Ozf4yir85gobM

[@nagoorvali987]

Hi Aqil I have one doubt in SSRS I have all filters values 'ALL' showing slowly run any reason

[@learnssis]

Sorry don't have experience with SSRS.

[@GreenDimond-o2e]

I like your teaching sir

[@learnssis]

Thank you Karthik.

[@houssam5638]

Thanks a lot for your effort .

[@learnssis]

You are most welcome Houssam.

[@engincolak3517]

Hello sir, I downloaded SSIS from Microsoft, but the install button does not work during the installation process, I wonder why?

[@learnssis]

There are 2 things to install Visual Studio and SSDT which one are you talking about there ?

[@wiktormigaszewski8684]

Concise, thank you!

[@learnssis]

You are most welcome.

[@alsafisiddig6201]

thank you for excellent explation.PLASE ANSWER ME i have aquestion. I have question i am learing DATA ANALYSIS should i watch all these videos or are there videos specifically for data analysis PECAUSE I WANT LEARING DATA ANALYSIS BY SSIS

[@learnssis]

Yes, if you want to learn data analysis using SSIS then these videos are for you. I have covered almost every task\component of ssis which is normally used in ssis package creation.

[@dillivemala4323]

Excellent explanation.

[@learnssis]

Glad to know that you liked the video dilli vemala.

[@nareshct6543]

Thanks nice start. What is the diff. B/wSsdt and visul studio. Package format version 8 means.. Which version of ssis pkg.. Thanks in advance..

[@learnssis]

Visual Studio is a tool from Microsoft which is used to develop application for a wide verities like you can develop a web app, windows app, console app, DLL, SSIS package, SSRS reports etc. SSDT is for developing SSIS, SSRS and SSAS projects. Sorry I am not sure where are you looking at Package format version.

[@nareshct6543]

@@learnssis thanks for your response. Really good to learn ssis from your channel. So, Without visual Studio we can't use ssdt.? Both are licensed or free of cost.. Thanks again

[@learnssis]

@@nareshct6543 You are most welcome. Visual Studio community version is free. SSDT is just a part of Visual Studio so that is free as well. SQL Server developer edition is free as well for development.

[@yasirkhan1278]

Hi Aqil, Please suggest me the best solution. I have data in my SQL SERVER DATABASE, Whenever there is insertion or update of records in table named "tableA". I need to trigger my Azure Data Factory. Earlier I was planning to HIT Azure Function App from SQL SERVER and then from Azure Function App I will hit AZURE DATA FACTORY. But this solution is not sounding best to me. Please suggest me if using SSIS could help me in having best solution which also be less expensive. THank You

[@learnssis]

Hi Yasir Khan, unfortunately I don't know how we can trigger the azure data factory from SQL Server. I have very little experience on Azure data factory. I know how to trigger an ssis package from sql agent job but not sure how we can trigger the azure data factory whenever there is some change to the sql server table data.

[@yasirkhan1278]

@@learnssis No Worries, But thank you very much for your reply

[@alsafisiddig6201]

GREATE EXPLAIN...WHERE VIDEO FOR DATA PROFILING TASK....EVERY DAY I CHECK IF YOU DOWNLOAD OR NOT .

[@learnssis]

Currently I am busy on some projects and not getting time to make video. Maybe will try to make video during weekend.

[@alsafisiddig6201]

@@learnssisOk..I Waite you...I'm finished from course I get more Benefit and skills To do data analysis....you are best one explain ssis in KZbin.

[@pathanataraj6739]

How to switch debug mode to design mode before we start executing

[@learnssis]

We don't need to switch them. Just write your code inside SSIS package and then you can execute it after click on Start or press F5.

[@akmaaaloa]

Hi Aqil. Do you have a tutorial on how to stop/pause an existing job in SSIS? Thank you.

[@learnssis]

Hi Akmal, I don't have a video on that one, you can right click on the sql agent job, click Stop to stop it.

[@akmaaaloa]

@@learnssis Thanks for your feedback Aqil. If I stop the job, does that mean it stops the overall job of the flow and it will restart all over again once I restart it OR it stops that specific activity and pauses it, and will continue to run after I restart the job? Hope my question is understandable. Thanks again Aqil

[@learnssis]

@@akmaaaloa When you stop the job the overall flow of the job will be stopped and when you will run it again then it will start from the beginning.

[@ExonaQ]

Keeep going

[@learnssis]

Thank you so much.

[@inGENIEur1992]

machaa Allah thank you very much

[@learnssis]

You are most welcome.

[@marciofranco6085]

Thanks for vídeo 👌

[@learnssis]

You are most welcome.

[@mohammedgouse7704]

How to run a sp only once in a day, even if we schedule a job for it. Suppose if we manually run it, it will execute again. How to prevent it

[@learnssis]

Thanks for your question. What I will do is I will create a config_table for it. And the config_table will have below schema create table config_tbl(Id int identity, ProcessName varchar(100), Dated date, Count int) Now in my SSIS package, after executing the SP, I will insert a record into above table with sp_name, getdate() and count will be 1. Now in my ssis package before calling the sp, I will check the sum of count for current date from the config_tbl and if count will be zero only then sp will be called otherwise it won't be called.

[@learnssis]

I will try to make a video on it very soon.

[@mohammedgouse7704]

@@learnssis tnq you bro I am learning alot from Your videos

[@learnssis]

@@mohammedgouse7704 Keep watching 😀

[@learnssis]

Hi, I made a video on this topic Execute SSIS package only once in a day regardless called multiple times kzbin.info/www/bejne/hX7Hd3iBodeneKs

[@srinathgaddam1569]

Hi sir, SSIS is still worth to learn in 2024? can you give me idea about its future scope

[@learnssis]

Hi, yes it is worth to learn SSIS in 2024. Currently SSIS is one of the widely used ETL tool in the market. its future scope might be somewhat limited compared to newer cloud-based solutions. However, learning SSIS can still be beneficial, especially if you're working with legacy systems or organizations heavily invested in Microsoft technologies.

[@Firatayrilik]

KING!

[@learnssis]

ha ha. Happy Learning.

[@narendrapawar7347]

Is this useful for data analyst or data scientist.......?

[@learnssis]

I don't know what is their roles and responsibilities. This can be load to load the data into datawarehouse which can further be analyzed by data analyst.

[@kishanbhise4733]

Hi Aqil, does this playlist cover all that is required for a BI developer

[@learnssis]

It covers all that is required to become an SSIS developer. If you want to learn SSRS and SSAS then you might need to watch other videos as well, but to learn SSIS this is more than enough 😀. I have 3 playlists on SSIS SSIS Tutorials: kzbin.info/aero/PL_YF--8vjjEVEXMf2hEFn0D5tEJV9kRqi SSIS real time scenarios examples: kzbin.info/aero/PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY SSIS Interview questions and answers: kzbin.info/aero/PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7

[@kishanbhise4733]

@@learnssis Thanks for your response,I will watch all the playlists

[@learnssis]

@@kishanbhise4733 thanks. I am sure, they will help you.

[@Dubai_Cnu]

Hi Aquil,Is this classes covered all topics including real time scenarios?

[@learnssis]

yes, I have covered almost all kind of scenarios and topics in SSIS.

[@krisy8434]

firstly Thanks a lot! Just want to know is this the complete ssis tutorial?

[@learnssis]

You are most welcome Kris. Yes in the description of each video you will find the link to playlists on SSIS videos. I have covered almost each and every topic tasks\component of SSIS.

[@RiadhCHIBANI]

Hi, great video, i had a problem , when i click on test conection i got an error "est connection failed because of an error in initializing provider. Délai d'attente de connexion expiré" anyone can help me pls

[@learnssis]

Can you check the server name and database name ? Try to connect to the same server using sql server management studio ?

[@RiadhCHIBANI]

@@learnssis i did the same you did i write SELECT @@SERVERNAME and i did copy paste, btw i made a local server and thank you for you response appreciate

[@learnssis]

@@RiadhCHIBANI Right click on the connection manager, edit, uncheck the Work Offline option.

[@saihuman3840]

One interviewer asked to me I have number of files in a folder today didn't get any file how can we check plz do the vedio

[@learnssis]

Sorry did not get your question. Can you please explain in detail.

[@saihuman3840]

@@learnssis how can we exists the folder files or not by using ssis

[@learnssis]

@@saihuman3840 Do you mean you want to check if some specific files like Customer.CSV and Employee.CSV those files exists in a folder or not ?

[@saihuman3840]

@@learnssis yes

[@learnssis]

@@saihuman3840 Okay great. I will try to make a video on it, that for example if a file exists then we will make an entry into a table that file exists and if file does not exists then we will make an entry into a table that file does not exists.

[@gagansingh3481]

Do you give training on ssis and ssrs

[@learnssis]

Email me at [e-mail]

[@a.kharshith2169]

Hi sir i can't find ssis in my visual Studio y it is so

[@learnssis]

Did you checked this ? kzbin.info/www/bejne/Zn_Sq3yMpLOsj5Y I have shown how to install it.

[@a.kharshith2169]

@@learnssis ok thank you

[@learnssis]

@@a.kharshith2169 You are most welcome.

[@thepriestofvaranasi]

What is flat files?

[@learnssis]

Flat file is any file that has data in either delimited format like the column values are separated by a delimiter like comma. OR the file can be a fixed width file as well in which every column has a fixed given width according to the length of data. The extension of the file can be either txt or csv.

[@jerryiriri1655]

Is SSIS still worth learning 2021?

[@learnssis]

Yeah huge databases are stored in SQL Server on premises and SSIS is used to migrate the data to SQL from any other system, or you can migrate to Oracle\MySQL from SQL Server. Thus SSIS is still in demand.

[@jerryiriri1655]

@@learnssis I appreciate you response. Thank you.

[@learnssis]

@@jerryiriri1655 You are welcome.

[@GangiredlaBalajiRamaSunil]

SSIS its Required Coding or not

[@learnssis]

Its better that you understand a language like C#, Java, PHP, or Python so that you understand how we write code and logic in a programming language. 90% work can be done without C# but 10% coding might be required time to time to complete the project.

[@DataJuggler]

It's a shame VS 2022 doesn't have Integration Services Project. I have another project that has to use VS 2019, so I have it also, I just prefer VS 2022 whenever possible.

[@divyaarunarajan6733]

Hi can you please add header and trailer to the same file .

[@learnssis]

If you want to import a csv file to sql server, then it can easily import the file with header information, however if there are trailer in the file then we need to handle them separately.

[@lamiaaelammari5172]

Hello Aqil thank you very mutch ,I have a csv file that contains disorganized data, scattered, incoherent with the same id, there are multiple lines, the difference there is of the value null the other row of the same id the field is filled how I can do to extract the data, I fill the null fields with the value of another row and if the date is different, I take the most recent . for example: id;name;birthdate;gender;address 1;null;02/10/2000;null;ad1 1;ali;null;null;null 1;null;01/03/2020;m;null I want as result like that (1;ali;01/02/2020;m;ad1) group all the lines in a single line because it is the same id you have an idea how I can solve this problem thks so mutch

[@learnssis]

I think first you can import the data as it is to a sql table, and then you can easily update data for the records where one of the field is null from another record where data is not null.

[@lamiaaelammari5172]

@@learnssis thks Aqil I do the update query even it is the Big table with 2,336,000 records ??

[@learnssis]

@@lamiaaelammari51722.3 Million records are not very big. If there were 2.3 Billion records then it was a big table. You can use below approach to update the data and get the desired result drop table if exists tblData create table tblData(id int, col1 varchar(100), col2 varchar(100), col3 varchar(100), col4 date) insert into tblData values (1 ,null, 'dd', null, CONVERT(date, '12/12/2000', 105)), (1 ,'ali', null, null, null), (1 ,null, null, 'tt', CONVERT(date, '23/01/2022', 105)) go --select * from tblData update a set a.col1 = b.col1 from tblData a inner join tblData b on a.id = b.id where a.col1 is null and b.col1 is not null go update a set a.col2 = b.col2 from tblData a inner join tblData b on a.id = b.id where a.col2 is null and b.col2 is not null go update a set a.col3 = b.col3 from tblData a inner join tblData b on a.id = b.id where a.col3 is null and b.col3 is not null go update a set a.col3 = b.col3 from tblData a inner join tblData b on a.id = b.id where a.col3 is null and b.col3 is not null go ;with cte as ( select ROW_NUMBER() over (partition by id order by col4 desc) as rn, * from tblData ) select Id, col1, col2, col3, col4 from cte where rn=1

[@lamiaaelammari5172]

@@learnssis Thank you very much Aqil for your collaboration I applied your logic ,and it works well

[@learnssis]

@@lamiaaelammari5172Glad it worked for you.

[@bz86054]

Thanks!!!

[@learnssis]

You are most welcome.

[@omkarsaste6998]

can nonprogramber do the MSBI?

[@learnssis]

If you know SQL then yes it is easy. You should be aware about at least one database language either SQL or MySQL Or Oracle then it will be quite easy to learn the MSBI.

[@zealbehappy5896]

@@learnssis thank you.

[@learnssis]

@@zealbehappy5896 You are most welcome.

[@omkarsaste6998]

@@learnssis How much SQL knowledge is required?

[@learnssis]

@@omkarsaste6998 Basic level of SQL knowledge is fine, you can learn more while working on the SSIS package.

[@yuvrajb4696]

Thanks a lot

[@learnssis]

Thank you Yuvraj.

[@manpt123]

Thank you sir

[@learnssis]

You are most welcome Metaman.

[@manpt123]

Sir, I have a task to convert ssis deletation process to python code. I am little confused what i have to do exactly because I have no idea about ssis but I know python. Could you please just explain what I should do !

[@learnssis]

@@manpt123 I have the same issue that I know SSIS but I don't know Python.

[@givonzirkind957]

Good intro. The volume is a bit low.

[@learnssis]

Thank you Givon, yeah you are right volume should have been higher.

[@ericsos101]

Nice video and great explanation.. can you share dataset to follow through practically?

[@learnssis]

Sure Eric. I shared the link in the description of the video, please download it from there. Thanks.

[@ericsos101]

@@learnssis Thx . received it

[@learnssis]

@@ericsos101 Glad.

[@mohankagankar]

please make hindi series

[@archanam4224]

ssis packages->gcp(airflow)

[@kiranshetty-xb8mn]

Hi Bhai. Thanks for the video. Can you please make a video on how to validate a txt file in ssis . that will check if header is as expected it will print valid file then it has to check for footer if it's valid - print message it's valid file. And If there is any line after footer or before header - it should give invalid file.And next it should check if data is present between header and footer if it's present it should give valid file. Can you please help me I have searched everywhere I didn't get how to finish this task

[@learnssis]

This is not an SSIS task, but this is a C#.NET or VB.NET task and you would need to write code in C# to check this one. Try to ask chatgpt to write code for this scenario and try to write a console app for this requirement. If code works fine in console app then we can write the same code inside script task in SSIS.

[@kiranshetty-xb8mn]

@@learnssis ok Thanks Bhai, I'll try to search in chatgpt and use that code

[@Mr.AI_Pixverse]

perfect

[@learnssis]

Thank you so much for your comment.

[@nobodyanybody1174]

Hi Aqil by watching ur videos can we learn ssis from scratch we only have sequel knowledge

[@learnssis]

Yeah of course, you can learn from scratch. I have covered almost every topic of SSIS from beginners to expert level.

[@nobodyanybody1174]

@@learnssis Thank you Aqil

[@learnssis]

@@nobodyanybody1174 You are most welcome.

[@gvscreations4182]

Hi sir .... ssrs videos available in KZbin sir .....

[@learnssis]

Hi, currently they are not available but I am planning to make those in future.

[@sandeepnagurla9982]

👌

[@learnssis]

Thank you Sandeep 😊

[@user-qf4ew3hh9n]

I didn't watch this - captioning, even automatic captioning is disabled. I'm hearing-impaired & would love to watch this great video, but I can't.

[@learnssis]

Sorry for that C.Law. I will upload the subtitles for the video soon.

[@learnssis]

I added the sub tiles for this video and will try to create and upload sub titles for all of my videos. Thank you.

[@user-qf4ew3hh9n]

@@learnssis Wow, thank you for replying and for following through with uploading captions. I applaud you and appreciate you. I'll be watching this soon!

[@learnssis]

@@user-qf4ew3hh9n You are most welcome.

[@alsafisiddig6201]

YOU DONT HAVE VIDEO DATA PROFILING TASK

[@solomong.gebrhana1204]

Hello, I am working with bulk Insert in Microsoft SQL studio which I need to automate so badly so it can run daily. I have this code ......... BULK INSERT [dbo].[Transactions] From 'Y:\Imports\Paytronix\Transaction\20221110_transactions.txt' With( firstrow =2, rowterminator = '0x0a' ); The code works but I have to change the file name every day, and unfortunately, the txt file includes "a quotation mark and I have to find and replace that as well before importing it to my table. So, if you could help me how I can create some kind of job to run daily without me changing the filename daily and to get rid of that quotation mark. I would really appreciate it.

[@MahmoodEqubal-c7q]

Thanks a lot Aqil sir for providing so much of good content on SSIS. If you have time, I have a quick question for you. Following your steps trying to connect to OLE DB, but the databases are not showing in the drop down. When trying to "Test Connection", this message is coming. One more thing, to fix this thing I tried many options without any success. Then I uninstalled SSIS and now when I am trying to re-install it, the installation is not happening. And this below message is coming. "Fatal error during installation 0x80070643 for microsoft as OLE DB provider for sql server 2016. an error occurred during the installation of assembly Microsoft.VC80.CRT,type="win32",version="8.0.50727.6229",publicKeyToken="1fc8b3b9a 1e18e 3b",processorArchitecture="x86"." NOTE: I am using Visual Studio 2022 Community Edition, SQL server dev. ed., and on top of it I have SSMS. Thanking in anticipation.