19 Import files from multiple locations to SQL Server in SSIS

Import files from multiple locations to SQL Server in SSIS
Download the file\script used in the Video from below link

Import files from multiple locations to SQL Server in SSIS
How do I import multiple files into SSIS?
How do I import multiple Excel files into SQL Server using SSIS?
How do I import multiple flat files into SQL?
How do I import multiple CSV files into SQL Server table?

[krishnaveer]

How will you improve the performance tuning if data is huge?

[deepalipatil]

Thank you. I had a small doubt. Pardon me if this sounds silly. In the DestFilePath you have set the value as the sample_data.csv. But the actual files have something more appended in the file name in c drive. Won't that create an issue while copying the file?

[sathiyamoorthi]

Hi Aqil,
Thanks a lot for your video!!

[SagarSagarsoftware]

How Can I load a multi-tab excel file into multiple tables by matching the table names with tabs name present in ExcelSheet. Please help Sir!

[krishnaveer]

How to resolve if dead lock happens in ssis. If the package will run for 30 mins due to dead lock it's running from one hr.

[triveninalabothu]

Hi Aqil,
Is there any specific reason to move the file to other location using File system task.
Instead of File system task we can use DFT to load data right?

[krishnaveer]

How you will add column to the exists slowly changing dimension

[dhirajsharma]

I am getting an error while executing package through sql server agent job. It is showing error that not able to acquired connection with default value that i passed in variable. It is not picking dynamic value in runtime. How to resolve this issue.

[sathiyamoorthi]

Hi Aqil,
Can please the upload videos same but file does not copy from other directory to move into common folder because each and every day new files comming we need track and file should be excel format.

I am working real time on this please help me

Thanks in Advance !!

[ybrrcbq]

Hi Aquil,
Thanks for making incredible session on SSIS.
I want to knwo if there is a way we can import multiple csv files with diffrent schema into respective database tables. I dont want to use script activity(C#) for this.
Thanks in advance

[reality]

Hi friend.. in server source any table in dynamic.. destination also dynamic table, insert any table but final data will came dynamic.. it's possible or not

[krishnaveer]

Can you do how will send the data to sql server if a source is API.

[mohammadrizwan]

Hi, I want a incremental load base on date column. Daily basis take csv file and load only T-1 date into sql server table

[priyavishalkulkarni]

How to import files from different file formats into SQL using SSIS?

[solomong.gebrhana]

I am trying to import data from an external source(website) to my local server database, do you have any advice? I am using visual studio 2010 on a windows server 2012R2.

[gantamahesh]

Hi Aquil, In the Data flow task what will need to configure the Source to the destination?

[paragbshah]

Hi, is there any option in SSIS to get data from API source? If yes, then could you please let me know the steps.
Thank You

[aditipande]

How to save several files from database to folders through ssis?

[prajaakeeyaparty]

HI Aqil...I have requirement like need to build a ssis pacage from multiple excel files to sql tables based on one column values from excel files data to multiple company tables from excel the table has to be created dynamically if not available and to be truncated before loading (Table name example infosys(from Companyname column))

[ahmedhassankotb]

how to import tables from different server to one database destination