Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 22nd, 2006, 10:33 AM
AP AP is offline
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 3 - Bulk Insert Example Problem.

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.

Reply With Quote
  #2 (permalink)  
Old December 14th, 2006, 07:25 PM
Registered User
 
Join Date: Dec 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am having this same issue. Was there ever an other discussion on this?
Reply With Quote
  #3 (permalink)  
Old May 22nd, 2008, 03:44 PM
Registered User
 
Join Date: May 2008
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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).
Reply With Quote
  #4 (permalink)  
Old February 5th, 2009, 03:54 PM
Registered User
 
Join Date: Jan 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
  #5 (permalink)  
Old February 5th, 2009, 04:50 PM
Registered User
 
Join Date: Jan 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk Insert Problem starnet SQL Server 2005 5 April 17th, 2007 08:34 AM
hi problem on bulk insert command karthikc85 SQL Server ASP 1 November 8th, 2006 04:22 AM
Bulk Insert Problem pseudo SQL Server 2000 2 October 4th, 2006 06:48 AM
Problem with Bulk Insert starnet SQL Server 2000 1 September 13th, 2006 08:29 AM
BULK INSERT PROBLEM ZoroAstris SQL Language 3 January 3rd, 2005 09:18 AM



All times are GMT -4. The time now is 10:55 PM.


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