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.
Table = CADFilepath(pathname, projectnum)
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.
Posted On: Saturday 10th of November 2012 05:09:52 AM
View Complete with Replies