When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist or The Path Specified Cannot be Found. This is usually due to the fact that the file must be on the same server as the database. In other words, it you are connecting to a remote machine the flat file must be on the remote machine. The connection to this file in the SSIS package must use a UNC path and not a mapped drive.
Search
Post Calendar
My Tweets
- We just backed Ten Plagues the Card Game on @Kickstarter kickstarter.com/projects/64044… https://t.co/1hIFAxaLHd 3 months ago
- I just entered to win a $50 Miniature Market Gift Card with help from @TheGameBoyGeek ! gameboygeek.com/contest 5 years ago
- Help Sydney travel Abroad gofundme.com/help-sydney-tr… 6 years ago
- Got to meet zee @dtconofficial https://t.co/m0YUdcLVOr 6 years ago
- RT @StrateSQL: Mikes entering sandman #sqlkaraoke vine.co/v/eYUJrV0JAiK 7 years ago
Pass Summit 2011
SQL Rally
Meta