October 11, 2001 at 6:27 am
Hi !
I want to launch à DTS from a trigger. the sql statement of the DTS must be parameterized by a variable value from the inserted table : in fact, I want to tranfert to a file (txt) a record which is inserted in a table.
Thank's a lot !
October 11, 2001 at 7:02 am
Best way is to just use sp_start_job to run your package. Do you really have a requirement to do the export real time?
Andy
October 11, 2001 at 9:33 am
I wouldn't run this from a trigger. If you have problems, then the transaction would fail. I'd use the trigger to insert the record into a staging table with a timestamp. Then have your DTS pacakge run every minute or so and check for new records within the last minute. Export these records.
Steve Jones
October 15, 2001 at 6:59 am
Hi !
Thank you !
The trigger fails because the datas aren't posted in the database. I will lauch a DTS package which will run every 10 minutes of fewer.
I have another question : I want to launch an executable every week end. It moves files for a directory to store them for saving.
How can i do it with a job ??
A job accepts only a cmdexec (operating system command) ... Help !!
October 15, 2001 at 7:03 am
Thank you Andy !
I am not a specialist of SQL derver and i am only certified with Oracle. I haven't a big experience in SQL server and I do my best to send datas to SAP database via an text file.
I will export datas every 5 minutes and not in real time !!
October 15, 2001 at 8:11 am
About your earlier post - you want to want to launch an app from a job using an operating system job? Or you're looking for alternatives?
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy