Thanks Keshav for this fantastic video. It really helped me alot. I watched it again and again and paused and backed up and reviewed alot, so having it in video format was also a big help.
Now I only have one question. I am trying to use the package (not project) deployment option for SSIS. This way I can use the variables like you did in the video for the EXCEL path and table name. This is better because then I reduce the number of SSIS packages. I see that.
I get all the way up to setting the variables as exportable in creating the package and the system accepts everything. Afterwards I save and I look at the xml in a browser to see what the config dtsx file contains but it doesn't show any variables at all. Do you have any ideas why it might be doing this. I am using visual studio 2010 and am connecting to an SQL 2012 database.