Hi SJanki

I do not know if you resolved your issue already, if you haven't the following package handles the problem you described, the data flow picture below drives the explanation.

PROCEDURE

a....

Yes, that's correct, it could mean a lot of work for you updating any package with Excel data sources based on the old driver (Xl-2003) and people at your site...

Hi Juls-195136

You may use an Script Task component to consume the Web Service, but you also have the Web Service Task, which is better; I found the following article at...

I ran a test on my workstation before posting my suggestion, I was chasing permissions problems, I did not try to use my local server because FTP permissions issues are...

Hi Sandy

Is this the same problem you reported at the Integration Services forum?

Hi Erics

It could be possible that your data source is either [a] not deployed or it was deployed and still referencing the developer environment.

You can check it out by...

Hi GRussell31

I can't explains why your data flow is not following the error path, I can suggest the OnError event at Package level? you can set it up at the...

Hi cafescott

I tried to replicate your issue on my workstation, I set a local FTP server and it worked fine, I had some password rejection because I did not enabled...

You may use the SETX variable value command in a DOS or CMD batch file or console; I did not try this on a secured environment, it does work on...

It seems you missed step 4

4. Double-click on the Script Component to open its editor and click on its Input Columns, search for the column containing the offending dates, and...