Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
 Posted - 2007-07-03 : 10:01:47
|
| I have a DTS which is run by users everyday using a batch file.THis is the text for batch file.dtsrun /SMYservername /UMYusername /PMYpassword /NMYdtspackagenameThe window appears and disappears in a few seconds once the package is clicked. There is no way for the user to tell whether it failed or succeeded. Is there a way to print the results somewhere.Coz when you run the above line in CMD you get to see the resultshow many rows were copied. Is there a way to see that from a batch file.Ashley Rhodes |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-07-03 : 11:06:46
|
| dtsrun /SMYservername /UMYusername /PMYpassword /NMYdtspackagename > c:\result.txtOr you could enable logging in the package.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-07-03 : 11:15:38
|
| I have a problem. when The task fails the email is not send for some reason. There are 2 connections in the DTS used to copy data from one table to another. But I want to see if the email is send when there is error.So I try to copy data into wrong table and i get an error:The number of failing Rows exceeds the maximum specified. Insert Error Errorr Converting Value.But the DTS says Send Mmail Task not Run. IN case the package is success the mail is Run. How do I get to run even in case of failure. There are 2 connections and a transformation between them. I tried using this with a Data Driven Query task with same connections instead of a trnasformation it still does not runs the send mail taskAshley Rhodes |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-07-03 : 15:22:41
|
| This dtsrun /SMYservername /UMYusername /PMYpassword /NMYdtspackagename > c:\result.txtdoes the job by writing the results to a text file. But is there a way to Print results on the screen as well and to the file as well.Ashley Rhodes |
|
|
|
|
|
|
to get Err message from Batch File if DTS FAILS