Load Data from Multiple Source (Text & Excel) Into Single Table Using SSIS

This blog helps you develop a very flexible SSIS package which loads data from excel and text files dynamically into a single SQL Server Table destination.

[KeshavSingh]

I would advise you to check the scope of the variable and keep it to the package level.

[krismaly]

Its an awesome video explaining lot of functionalities. Especially handling multiple files and archiving.
Also explained
setting to 32 bit
Delay Validation to TRUE
External validation to FALSE 
are all important.

Thanks for educating the community and appreciate your volunteership.

How about teaching the same functionality step by step in an another video.
Time taking up to 20 mins is also fine since so many functionalities to cover.

Can you make a videos how to handle errors in SSIS packages.
With your experience day to day developers encountering error and how to fix them.
I don't see such videos and it would be nice and large audience may attract.

You could let me know when you release a video so that I can review and give you feedback.

Good Luck!

Appreciate and thanks a lot

[anbudhan]

Hi thanks for this, great tutorial. For some reason the user variable is not showing up while setting up the connection manager string on the flat file connection property. Same with the excel source. I have made sure the var is listed in the collection in FEL Task. I am i missing something here?

[morisjasuja]

Hi I have tried the same example but the script task fails at below line : 

        public void Main()
        {
            // TODO: Add your code here
            string filepath =
          
 Error: DtsRuntimeException: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during 
execution of the package and the element is not there.
 ---> (0xC0010009): The element cannot be found in a collection. This error happens when you try to retrieve an element
 from a collection on a container during execution of the package and the element is not there.

Can you please help ?

[chandramouli]

Here U R Not Given Proper Details. Flat File As well As Excel Set Properties I Think This is not useful.This is Time wasteing EndUsers...