I am having problem running the "Bulk Insert" example in Chapter 3 on page 48. When running the package, it says "C:\SSISDemos\ZipCode.TXT" file not found. The file is there. I did the example as per the book instructions.

Any help to resolve this problem will be appreciated.

I am having this same issue. Was there ever an other discussion on this?

I experienced the same error. It seems though not mentioned in the chapter that they assume AdventureWorks is local. The bulk insert task is looking for the file on the server AdventureWorks is on at the path specified. To work around the error I created a mirrored directory on the server with the example files (same path as on your local machine) and that fixed the problem. You could also store it at a unc address (\\servername\temp\examples\zipcode.txt).

Thanks for the tip, the unc address worked for me. But being new to SSIS (only in chapter 3) this makes me wonder if any input file I need for my package will need to be moved into a subfolder of the package itself vs. some common area of the network? Or can it be on another server and just use the unc address there in the connection manager? I've been able to send output flat files to my local C drive (and other servers) from the SSIS server so this source connection wrinkle is a little puzzling. Maybe this is just a peculiarity of the bulk insert task, I haven't tried other tasks that use a file input. The connection manager itself validated my local path when I created it so this just happened at runtime.

I had the same experience with the FTP exercise in Ch. 3 so it's not just the bulk load task. Seems it assumes the SSIS server's C drive vs. my local one, but only for the source file connection. FTP will land the readme.txt file anywhere I want but the archive step fails trying to access the file. Again the unc address made it work.