SUPER!!!! Just tested the solution aligning it to my environment and it WORKED! Thank you very much ScottPletcher. Just a bit of background, we had a poorly designed table where...

Hi ScottPletcher

Thank you very much for your time. Will test solution and get back to you.

Hi Phil

Thank you very much for your time. The date range is always within a week, could be 3 days or 5 days but does not go beyond 7 days.

This worked for me as well. Thank you:-D:-D

Thanks for the reply, will test this and let you know. My concern with thIs is it seems as if it will retrieve all the values in the table making...

My sharepoint list is reading and writing to sql server custom database using bcs. I want to store tube user name that makes changes to my sharpening list

I have the same problem. We have a SQL Server 2012 where the SSRS is installed and a separate SharePoint 2010 server. While installing SQL Server on the SQL box...

the path is valid still no luck

Yes, the problem is not with the ForEach loop, its with the excel connection manager. My excel connection manager ConnectionString is Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties="Excel 8.0;HDR=YES"; and by the way i...

please note that I have 2 Foreach containers. The Flat File (source) executes without any issues but the excel one gives the error. Both foreach loops are configured the same...

Im strugggling to get rid of this error. Will post as soon as I have a solution

Couple of weeks ago I was also experiencing the same error. What I did was to assign admin roles to nt authority/system within SQL Server and the error was resolved...

Im not using any 3rd party. I created packages using SSIS 2008 tested successfully in dev, deployed to file system, this was running for 2 weeks every day without any...

yesterday I changed the schedule so they can run sequentially full first then diff and it executed successfully using sql server agent. I then changed the times back to original...

I'm using SQL Server 2008.