| Q. John Chen 2005-09-27, 8:24 pm |
| I am getting the same error in a different situation.
I created a package on my machine. it move the XML data source to SQL Server
Destinations. It works fine on my machine.
I also created package configuration file with connection string in it. The
dtsConfig file is in the same folder as the package.
I give my package and config to my colleage (both of our project locations
have the same file structure) . Manually change connection string to point to
his SQL Database. Added package to his project. Run the project and got this
error.
On the other hand, I was able to use one of his package using the same
method with no problem.
Any clue? we are using June CTP. Read a post on SQLJunkies, So we just
delete the destinations and recreate them, fixed couple but made the others
fail.
Thanks
John
"uros" wrote:
> Hello!
>
> I'm using IS to copy and transform some data from one SQL to another.
> And when I'm executing package, I get this strange error:
>
> [SQL Server Destination 3 1 [338]] Error: An OLE DB error has occurred.
> Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft
> SQL Native Client" Hresult: 0x80040E14 Description: "Cannot fetch a row
> from OLE DB provider "BULK" for linked server "(null)".". An OLE DB record is
> available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14
> Description: "The OLE DB provider "BULK" for linked server "(null)" reported
> an error. The provider did not give any information about the error.". An OLE
> DB record is available. Source: "Microsoft SQL Native Client" Hresult:
> 0x80040E14 Description: "Reading from DTS buffer timed out.".
>
> Any Ideas?
>
> Uros
|