Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clo
Starting Member
10 Posts |
 Posted - 2010-08-06 : 06:47:59
|
| I have created a package to load .csv file to sql server.I tested with 2 files: “a.csv” and “copy of a.csv”. Both of the files are located at same folder. “copy of a.csv” is a file that copy and paste from “a.csv”. At each time, I tested for 1 csv file to load to sql server table. The only thing that is change in the package is the FFC conenction string, the rest of configuration (sql server table...) are the same.When I tested “a.csv”, I’m able to load the file into sql server table successfully. However, below message displayed when I tested with “copy of a.csv”.Bulk Insert Task: "Cannot bulk load. The file "E:\Data\copy of a.csv" does not exist.".Please advice. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-08-06 : 07:48:49
|
Try using double quote characters around the name, just in case.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
clo
Starting Member
10 Posts |
Posted - 2010-08-08 : 22:37:52
|
| Hi Peso,Can you please specify how to write the double quote character?After i put double quote at the path, the properties of flat file source are gray out.I have tried underscore: "E:\Data\copy_of_a.csv", but still no luck. |
|
|
|
|
|
|
Bulk Insert Task: file does not exist