January 5, 2006 at 5:53 am
hi
I've export database table to a txt file using DTS export wizard.
If anyboardy aware how to shedule that using a stored procedure please reply.(not using the DTS Export wizard)
thanks
January 5, 2006 at 6:56 am
When you run the export wizard, you get the option to save the package.
Once you have saved the package, just go into the Data Transformation Services section of EM, right-click the package and select 'Schedule Package' - follow the prompts and this will create a scheduled job.
Or do you need to be able to run the package from a stored proc?
Regards
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 5, 2006 at 12:06 pm
As above - if you need to run the package from a stored proc, you'll either need to do something via command-line to call DTSRun or you can "schedule" a DTS package (run-once in the past or similar) and start it using sp_startjob.
If you need to generate the file from the output of a stored proc, just change the source from table/view to your stored proc name. If there are no output changes, you can just ignore the warning dialog box and continue. Otherwise, you may need to change your file layout (populate from source) and of course, the column mappings.
January 6, 2006 at 11:32 am
Can you please futher expalin how to proceed it using a stored procedure.
the command-line commands and all.
January 6, 2006 at 11:35 am
I need to run the package from a stored proc
January 9, 2006 at 1:48 am
Check out 'DTSRun' in Books Online, it will help you set up the command line that you need to run a DTS package.
To run this command line from within a stored proc, you'll have to use xp_cmdshell - again, if you check Books Online, you will see how this extended stored proc can be used.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply