60 What is the most complex SSIS package you have worked on ?

[@shailajakesani8048]

Most wanted video. Thank you so much sir 👏 Could you please do on performance tuning techniques in SQL server.

[@learnssis]

Sure, will try to make a video on performance tuning techniques in SQL server.

[@smirfan9394]

Most useful vedio which covers most topics!

[@learnssis]

Thank you Irfan.

[@jitendrakumarswain5319]

Thank u Aqil. I am following u also in whp since I started ur video in utube.Thank u .

[@learnssis]

Thank you so much Jitendra.

[@henrinoguem888]

that's really interesting, these are such Projects that I like to see, it is certainly complex, but I go from the fact that these are similar Projects that we will do in business

[@learnssis]

Thanks Henri, yeah some part of this project can be used in different other projects like auditing thing, zipping or unzipping files, uploading and downloading files from FTP and importing CSV files to SQL server tables, so some parts of this project are widely used across other projects.

[@arunp6973]

Thank you so much Aqil, great job!

[@learnssis]

You are most welcome.

[@srinivasarao-gr8pv]

Thanks you Aqil for your efforts making a video on what i am asking previously. Great job and explanation is also very well👌❤️👍

[@learnssis]

Thank you Srinivasarao. Glad you liked the video.

[@7to7media]

please also make video on complex store procedure

[@learnssis]

Sure, will a video on that topic as well.

[@didyouknowamazingfacts2790]

This is definitely the most complex SSIS package I've seen.

[@learnssis]

Thank you.

[@notoriousft]

Great example.

[@learnssis]

Thank you FTT.

[@huzischannel]

Thank you.
Just an alternate way can you please confirm if we can implement conditional join using dynamic SQL as well?
I feel we can..need confirmation.

[@learnssis]

Yeah we can generate the whole sql query or whole stored procedure dynamically thus conditional join can be dynamic.

[@chanal4858]

Woooow super

[@learnssis]

Thank you.

[@pvksmaheeth8816]

the best explanation ever thank you . is that ftp server still available so I can create the package as it is from the scratch ?

[@learnssis]

Thanks, that ftp server is created on my machine, you can create the ftp server on your own machine, I have created a video how to setup ftp server on your machine
th-cam.com/video/53ROaESKYhM/w-d-xo.html

[@fitehalewdemilew4527]

Thank you, great video with excellent explanation. Just a single question what if we download and extract the "zip" file and perform the rest of the task using SSIS. I was just wondering 🤔

[@learnssis]

Yeah we can do that. In some of the project I worked a dedicated person used to download the files from the FTP server and then I manually used to unzip the files and then rest of the work was done using SSIS.

[@fitehalewdemilew4527]

@@learnssis Okay great. Thanks, for the quick response. This is one of your best qualities.

[@learnssis]

@@fitehalewdemilew4527 No problem. You are most welcome.

[@usharani176]

Hi Aqil,plz do make video clearly I'm confused 😢

[@learnssis]

This is a complex package, so it is okay that you got confused. Please first watch other videos, like how to unzip the files, how to download files from sftp server, how to import files from a folder, how to do incremental load using lookup transformation, how to export data to csv files. Watch other videos first and then come to this video.

[@arimbakammeghavardhan6424]

Thanks

[@learnssis]

You are most welcome Arimbakam.