Viewing 12 posts - 1 through 12 (of 12 total)
I recreated the package from the beginning new connection managers but I am still getting the same error.
The connection "{EFC6889A-D312-4A9E-B251-877C7A67B8DF}" is not found. This error is thrown by Connections collection...
March 27, 2014 at 8:48 am
Thanks Koen
I finally found the issue, the sql server agent service account did not have permissions to the drive.This was further complicated by the fact that the drive I was...
March 27, 2014 at 4:38 am
No problem on the local disk so it looks definitely like a permissions issue. How to solve it is the issue as the proxy did not work?
March 26, 2014 at 9:11 am
Tried it with a proxy no joy. But thanks for all your help you have been great.
March 26, 2014 at 8:25 am
Would a proxy account help?
March 26, 2014 at 7:40 am
Yes it is a network drive.
March 26, 2014 at 7:36 am
Getting closer I did all tasks and now the only error is
Started: 12:13:37
Error: 2014-03-26 12:13:38.36
Code: 0xC020200E
Source: Data Flow Task Flat File Destination [2]
...
March 26, 2014 at 6:15 am
I dont have any package configurations I was wondering do I need to add them?
What other areas should I review based on the error I am getting?
March 26, 2014 at 4:45 am
Could it have anything to do with package configurations?
March 26, 2014 at 4:36 am
IN the Data source properties of the job step both connections are visible the ole db and the csv so the job is seeing the connections. The SQL server agent...
March 26, 2014 at 4:35 am
There seem to be 2 issues:
* an ole db connection manager is not found. It surprises me that this error is not present in BIDS.
* the file "L:\Information Technology\Business Intelligence\BI...
March 26, 2014 at 4:23 am
Phil thank you for your reply. But after a long search I finally realised what was occuring (which I must say is poorly documented) however I found the answer on...
March 19, 2012 at 2:41 pm
Viewing 12 posts - 1 through 12 (of 12 total)