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?
@learnssis2 жыл бұрын
Yeah sure will try to make video on indexes as well. Thank you.
@pavanarajuk4452 жыл бұрын
Thank you so much sir
@learnssis2 жыл бұрын
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().
@gauravt57442 жыл бұрын
Good video sir ji
@learnssis2 жыл бұрын
Thank you Garvs Avenue.
@foodlovers762 жыл бұрын
How to load multiple Excel files into SQL server.... please help
@learnssis2 жыл бұрын
Can you take a look at this video kzbin.info/www/bejne/j4jUgGyBe7mEedE
@nileshpendharkar51332 жыл бұрын
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.
@learnssis2 жыл бұрын
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.
@nileshpendharkar51332 жыл бұрын
@@learnssis thank you
@indrasishdatta72102 жыл бұрын
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.
@learnssis2 жыл бұрын
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.
@indrasishdatta72102 жыл бұрын
@@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.
@learnssis2 жыл бұрын
@@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.