March 5, 2007 at 5:30 pm
I have a simple SSIS Package that copies data from an Excell Spreadsheet to a SQL Server 2005 Database and I keep getting the error below. How do I fix it? YES! I have increased the MaximumErrorCount Property to 200 but the error is still the same and the package won't work.
Help anyone?
SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Error: 0xC0202009 at Data Flow Task, SQL Server Destination [240]: 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.".
Error: 0xC0202071 at Data Flow Task, SQL Server Destination [240]: Unable to prepare the SSIS bulk insert for data insertion.
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "SQL Server Destination" (240) failed the pre-execute phase and returned error code 0xC0202071.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "SQL Server Destination" (240)" wrote 0 rows.
Task failed: Data Flow Task
Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
March 5, 2007 at 10:51 pm
Hi
is ur sql database on a local server or network server. check the credentials you ar using to connect to the database
Chirag
"Keep Trying"
March 6, 2007 at 12:01 am
March 7, 2007 at 12:39 pm
I had the same problem and I could figure it out. I am glad I saw your post and now mine is working.
But I don't understand why I need to use OLE DB even it is a SQL Server table as destination.
May 9, 2007 at 5:02 am
Hi friend,
You can´t to use the SQL Server Destination on remote server...
Instead, the packages should use the OLE DB destination
http://msdn2.microsoft.com/en-us/library/ms141095.aspx
Regards!
Lucas
May 10, 2007 at 6:45 am
I have a similiar problem. I am trying to use the Transfer SQL Server Objects to copy all tables and data from a source server to a target server. It fails with the same message. I have found the OLE DB dox but I haven't been able to figure out how to get the task to use OLE DB rather than the SMO Connection Manager (which uses SQLNCLI).
This was actually very simple in DTS but I can't use that since these are 2005 servers.
Any help would be GREATLY appreciated.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 23, 2007 at 7:40 pm
I have the same exact problem.
Any advise?
Thank you.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply