I'am just trying to create a .bat file, from the results of a query.
As an example here is a line of results .i.e
Copy\perfectinfodocrootpdf2007 92060967390.pdf\pi-profileF$FTPSiteRekeyPdfText20079
Can somebody help me out with put the results in to a .bat file as a automated job.
Here is the
problem that I am trying to solve. We currently have a mail order
manager application that we use. We have several vendors that we have
to initiate purchase orders with, and this is currently done manually.
I am converting it to do the purchase orders through a webservice, but
I would like this to complete in real time. I figured the best way to
do this would be to initiate a trigger when the particular table has a
record inserted. This insert triggers a script, passing the order
number and verifies if a purchase order needs to be initiated based on
what was ordered. If it does, it contacts the webservice, gets the
appropriate data, then updates the appropriate tables with the new
data, all through the script. I have been doing some research, and I
have heard that triggers are simply best to be avoided, and calling
outside scripts could be problematic too. However, I don't see any
other way to do this.
Hi,
I have a SSIS with a set of SQL Tasks that executes SPs, I need to add a precedence constraint which handles case of error, but as way to use only one SQL Task for Error... I think about using a variable that stores the SQL Task Name in turn and that can be used as a Parameter in the SQL task that I use with "sp_send_dbmail" to notify error..
That is..
________
|_sql 1__| --------
|
| ___________________
________ | sql handling Error |
|_sql 2__| -------->> |___________________|
|
|
________ |
|_sql 3__| --------
Need that Every SQL Task send its name as a parameter to my
"Sql handling Error Task" to be use with something like this code..
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Profile',
@recipients = @MailRecipient,
@body = 'Error in' + @SQLTaskName,
@subject ='Error al ejecutar ...' ;
I want to receive the name of the failing task in message body or subject.
I need to implement it also is projects with SQL 2000 (with Global Variables). Would appreciate any help, Please : )