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 |
|
rick.piller
Starting Member
2 Posts |
 Posted - 2006-01-04 : 12:55:09
|
| I go throught the import wizard to import a [DEL] delimited file. At the end I do Run Immediatly, and save it to .bas. The import from Run Immediatly works perfect, but when I try to run the .bas from VB 6 I get an error message:Copy Data from [filename] to [tablename] Step FailedMicrosoft Data Transformation Services Flat File Rowset ProviderIncomplete file format information - file cannot be openedSo any idea why when ran from SQL Server this works, but not from a .bas? Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-04 : 14:40:52
|
| When you run it from the .bas, are you running it on the database server or on a client machine. If on a client machine, then it is unable to find the file from the client's perspective.Tara Kizeraka tduggan |
 |
|
|
rick.piller
Starting Member
2 Posts |
Posted - 2006-01-05 : 08:58:03
|
| I'm running it from the database server machine. The text file is on another server, but I'm providing it the full UNC path to the file. |
|
|
|
|
|
|
.bas not working for import