p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 (http://p2p.wrox.com/forumdisplay.php?f=242)
-   -   Chapter 5 -- Sample 1: Zip Code Extract (http://p2p.wrox.com/showthread.php?t=38754)

mt February 20th, 2006 03:00 PM

Chapter 5 -- Sample 1: Zip Code Extract
Good Morning,

I am working my way through the book has am encountering an error in the first example of chapter 5. The basic problem is that SSIS will not (can not) open my text file for bulk loading. I have rebuilt (from scratch) the project several times reviewing the instructions each time to try to be sure that I am not missing anything.

The error I am receiving is:

Error: 0xC0202009 at Load Zip Code Info, Adventure Works [27]: 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 Load Zip Code Info, Adventure Works [27]: Unable to prepare the SSIS bulk insert for data insertion.

Error: 0xC004701A at Load Zip Code Info, DTS.Pipeline: component "Adventure Works" (27) failed the pre-execute phase and returned error code 0xC0202071.
Task failed: Load Zip Code Info

This is the first sample to fail to this point in the book and I don't quite understand the problem as I can access the flat file directly with a text editor and can see the columns/data when setting up the connection manager.

Any help will be greatly appreciated.


mt February 20th, 2006 04:41 PM

I found the issue....

The answer can be found here:


I wouldn't have realized that in order to use the SQL Server Destination that I actually had to execute from the SQL Box.

Oh Well, you learn something every day.


All times are GMT -4. The time now is 07:51 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.