Yes, you are right. The Retry Attempts and Retry Interval option from agent job relys on the failure of package execution and it will record every failure of retry in...

This is great, but I think there is another solution may be even simpler and with no coding required. I have a set of csv files need to be uploaded...

If the uploaded raw files can be transferred to .csv or .psv files, it should be a good solution. I use SSIS to handle many complicated .csv and .psv uploading...

That's right. The 64 bit system won't support Jet 4.0. I am quite sufferring from that problem too. So far, I couldn't any reliable solution to work around it yet....

Hi Carolyn,

I get it worked out! Actually, it's a credential issue. The account used to run the SQL Server Agnet don't have a proper access to the file system on...

Try to take advantage of the Precedence Constraint of the ExecutePackage task and lead it to the Send Mail task. It may work.

Charley

Try to set the MaximumErrorCount property for Data Flow Task (in your case Row Count) properly, for example 13. Make sure all properties in Execution section for the component...

Hi Carolyn,

My test is very simple and it contains only a script task and execute process task. the script task is used to setup a string for the arguments of...

Thanks for sharing the knowledge. This could be a good sulotion to archive the processed raw files when you have a daily procedure that uploads the raw flat files to...