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 |
|
flanz_g
Starting Member
22 Posts |
 Posted - 2007-01-22 : 06:13:56
|
Hi, Could someone please advise which connection object is best to use to connect to a file like this one below:?"http://xx00xx0123.abcdef.net/ABC_REPORTS/DATA/Table1.csv"Thanks,Gezza |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-22 : 06:26:39
|
| Why not use Text File(Source) as connection object if the file is Comma-Separated Values (CSV) file?BTW, the link you specified gave Bad Gateway error.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
flanz_g
Starting Member
22 Posts |
Posted - 2007-01-24 : 05:10:07
|
Hi, I can access the path to the http...csv file via Microsoft Internet Explorer which offers me either to Open or Save, but when I try to set up a Text File(Source) Connection Object in the DTS New Package, Typing the path into the "File Name" window I get:"Could not Open the specified file for reading.Make sure that thefile exists and that you have read access to it"Am I doing it wrong?Gezza |
|
|
|
|
|
|
My 1st DTS Package