BAD Directory on SQLDTS.com (Looping, Importing and Archiving)

K

kfschaefer

I am trying to set Global Variable that will open a txt file and import the
data into a sql table.

I am currently using the sample I found at sqldts.com (Looping, Importing
and Archiving).
When I set the variable for filename = dbo.cadfilepath.filename, I get a Bad
Directory error.
My filename data is stored in another table - I am looking for the best
approach to calling the filename from the table = cadfilepath and opening the
actual text file and importing the data into my project table.

ie.
Table = CADFilepath(pathname, projectnum)
Pathname ProjectNum
\\Seasc-Shared\Spln\Shared\Forecast\00000-000.txt 00000-000
\\Seasc-Shared\Spln\Shared\Forecast\00000-001.txt 00000-001
\\Seasc-Shared\Spln\Shared\Forecast\00000-002.txt 00000-002

I want to access the info in CADFIlePath and then open the first record's
text file and import this data into my Project Table, then repeat the process
until .EOF.

I know this sounds confusing and I can email you my documentation - since
this website does not allow for attachments.

Any assistances is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import all files in directory 1
importing csv 2
Access 2003: Import Extensionless Files 3
Help Importing Multiple Text Files into Different Tables 7
Storing a Variable Using SQL in VBA 2
Import multiple text files with filename as column 1
Import mutiple name text files into Access 2003 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0

Top