Hi Mike,

Thanks for your post.

Still my Script task runs fine without downloading the files to my local directory.

Let me know if we need to set the "write"...

Hi,

i am also having the same issue, Please let me know how you sort it out.

Thanks in advance

hi,

Iam also looking for the solution. please share if you have it...

Try this

Update Test set name = replace(name,' ','')

yes, its occurs only in execution of for loop.

The Error shown as "[Source - Query [1]] Error: The AcquireConnection method call to the connection manager "ExcelConnection" failed with error code...

I have 3 variables

filepath - This is the path i would harcord before running the package (\\Servername\folderName\)

Filename - The data for this variable would be populated from the for loop...