Chapter 5 -- Sample 1: Zip Code Extract
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 : 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 : 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.