-
Schedule Job in SQL Server
I hope you'll be able to help me with this question.
I'm suppose to import the content of formatted text files every hour. I'm able to do so using the DTS package. But here's the problem, the text files, although have the same formatted fields, have different names, dependent on when they are created. As a result, I have to schedule 24 DTS packages in order to get all the contents loaded into the database.
Is there an easier way to do this? Say, is there an SQL procedure that I can call and pass the source and the destination parameters and SQL would do the same import task that it does when I schedule a DTS package.
Any help would be much appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|