52 Performance tuning in SSIS

[@deepakj6717]

Most waiting video and excellent presentation .. Keep it Up.. Thank you !! As you suggested table INDEXES will improve performance, can you pls try to make video on INDEX? Types of Indexes? on which columns we need to create index? How it improves performance?

[@learnssis]

Yeah sure will try to make video on indexes as well. Thank you.

[@pavanarajuk445]

Thank you so much sir

[@learnssis]

You are most welcome. If I have not made the video today, then I might have received few more comments in next few days 😀

[@allroundernh7906]

Thank You so much Akil...It's very helpfull. Can you make a video regarding how to found file count in source folder?

[@learnssis]

You are most welcome. You can use this 2 lines of code to get the count of files in a folder using script task. DirectoryInfo dir = new System. IO. DirectoryInfo("SourcePath"); int count = dir. GetFiles().

[@gauravt5744]

Good video sir ji

[@learnssis]

Thank you Garvs Avenue.

[@foodlovers76]

How to load multiple Excel files into SQL server.... please help

[@learnssis]

Can you take a look at this video kzbin.info/www/bejne/j4jUgGyBe7mEedE

[@nileshpendharkar5133]

I query, if csv files are present in client location in local system, how to import those files using SSIS SQL server? Please help for this.

[@learnssis]

There is no inbuilt tool for this in SSIS. You would need to write some API in C#.NET to upload the CSC files from client System to your local server. OR Ask them to upload the files to FTP server so that you can download them from FTP server to local server using SSIS.

[@nileshpendharkar5133]

@@learnssis thank you

[@indrasishdatta7210]

Can you make a video on how to connect to a share point link in ssis to fetch flat files from a folder and load them into DB.

[@learnssis]

Actually at the moment I don't have access to any share point link thus it won't be possible for me to test it. But what I think might be possible that you should try to download the files from sharepoint link to local using C#.NET and then you can load them using SSIS.

[@indrasishdatta7210]

@@learnssis Yes, Can you just show the way to how to access a share point through ssis? As I would have to take the files from the share point only, I can not dowload the files on local. Thanks for the advice.

[@learnssis]

@@indrasishdatta7210 Actually there is no inbuilt component in SSIS to connect to share point, it will be done using C# only. And at the moment I don't have access to any share point, thus I won't be able to test it.