I have a user in the IT department that wants a process to take his text file and import it into a SQL Server table. Simple enough with a DTS package.
The rub is that he want's to execute the package and have it prompt him at that point for where the file resides. I tried to get him to go into the DTS pacakge and update the connection, but he doesn't want to do it that way. I suggested renaming the file to a common name to be used each time the application runs, and he wasn't interested in that solution either.
Any help you can give would be greatly appreciated. Thanks!
Have a look at this:
http://www.sqldts.com/default.aspx?226
No comments:
Post a Comment