Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2007-08-01 : 15:24:40
|
| hi,I am trying to use SSIS package to trasfer data and hitting road block for [SQL Server Destination [37]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.".How can i resolve this!!thanks |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2007-08-01 : 15:44:26
|
| The error says the file is not there. Can you confirm if the file is present in the specified location. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-01 : 23:04:06
|
| If it's remote file, defind it with unc name. |
|
|
|
|
|
|
SSIS errors!!help