Yes, the proxy account was missing write access to SharePoint and after granting the access it worked 🙂

Thanks for the reply, here is the detailed error

Executed as user: nt\svc_prd_div17. ...2500.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: ...

Yes, that's right. The text column is actually a calculated column in SharePoint List.

Thanks for your reply 🙂 . So to make sure i understand it clearly - i have to use 4 file task with 4 data flows and put them each...

I changed the format of the date field in excel to yyyy-mm-dd and this helped in resolving the issue. 🙂

Okay, not sure if this is the right way to do but i tried this.

Step 1: Created a table in Sql Server

Step 2: Created a data flow task -...

Thanks for the reply, After the data flow task i'll be moving all files to a different location after renaming it. SO i was planning to do a single foreach...

Thank you so much....that worked!!!

I'm using Sql Server 2008, that's the reason i cant find this REPLACENULL() function. I see this function in SSIS 2012 but i dont think i can deploy 2012 SSIS...

Sorry for my ignorance but I did not find ReplaceNull() function. I tried this in COnidtional SPlit

, The results are only...

Thank you, that explains the issue :-). I tried to execute after couple hours and it worked.

But my question still remains open, why i'm not able to use Open Row...

Thanks for the reply! All files are closed, no user is using it. I only see this error when I'm using the query. I tried using the query yesterday evening...

I observed this second error in Execution task

[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record...

No, excel file did not change. No columns added or renamed. Everything is same.

I'm seeing this error when I'm trying to use Sql Command in the Data Access mode. I'm trying to skip 9 rows. In this try i tried to skip 8...