when you want to transfer data from test_stage to test_cdc, do you want to do any transformations or just move data from one environment to other?

If you are just...

See if below way works for you -

The concept I worked on long ago in one of my assignment was we created a control table which will maintain list...

see if this link helps you - Microsoft OLE DB 12.0 Provider Not Registered

Case 1. when you say that you have files with 2/3/4 columns, does it means files with 2 columns have always same 2 columns, files with 3 columns have always...

JoshuaT,

You can refer below link on how to convert spreadsheet to new format.. This script will go in script task.

http://blog.quasarinc.com/ssis/save-as-a-new-excel-file-in-ssis-2012-script-task-using-visual-basic/

You can use variable to read the file name...

Not sure about the drivers but see if below workaround works for you -

Add a script task in the package to save/convert .xls file as .xlsx with proper formats...configure...

Have you tried using DT_Numeric instead of DT_I4?

Can you try using this.variable("VariableName").value instead of dts? Also, is your variable listed in ReadWriteVariables section of the task?

Have you done grouping at the query level or report level?

Please check whether SQL Server Agent Account/account with which package is executing has access to path "\\sharedfolderserver\sharedfoldername". In your designed, SSIS package runs with your own user account however when...

well I am able to get this done.. but have a bit short of time to explain you on this right now.. You can check back in 2-3 days and...

Thanks Daniel..! It worked for me..! 🙂

Thanks tnk!

I really appreciate your help on this and would be glad if you can provide idea even at high level to achieve this. I am not a sharepoint developer...

Thanks Daniel.!

But the situation is I am displaying these reports in sharepoint site where report parameters are not passed with URL but passed internally. If I use bookmark on sharepoint...

Thanks GSquared...

but on excel data provider this type of query does not work.. ! It says it requires a parameter but none is provided.