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 |
|
cshekar
Starting Member
49 Posts |
 Posted - 2004-08-06 : 11:10:18
|
| I have create a DTS package for Imporat load from Excel to my tabel in SQL server, I am using Trasfornation Data Task and it working fine I am calling this package from from my Stored procedure. when I execute stored procedure this DTS package execute ok and it Loads the data to my tabel.But My concern I want Handle the Error if some reson DTS package failfor example it can not open the source file or It did not load to the data to table or any reason if fails,I need to put some sort error I do not know how to hanld this pLease help me. because I am calling this DTS from Stored procedure.Thanks for helpChandra shekar chandra shekar |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2004-08-06 : 11:23:00
|
| Are you familiar with DTS Workflow? You could setup a task, that gets executed if a specific task fails. See SQLDTS.com for more information.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
cshekar
Starting Member
49 Posts |
Posted - 2004-08-06 : 11:28:19
|
| yes I am familiar with DTS Workflow that will lead to execute next task based on workflow like if Success or failure but what I need is some sort of of message return to user when they execute my stored procedure it should return the error code or message Thankschandrachandra shekar |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2004-08-06 : 11:31:04
|
| Not sure I follow you. Are you planning to provide a stored proc that will run and show the user, the status of last executed DTS package?--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
cshekar
Starting Member
49 Posts |
Posted - 2004-08-06 : 11:41:25
|
Hi VyasI am trying to get some kind of mesage from DTS and pass to proc and where I can get that mesage and make sure that data loaded to table or other how would I known my table loaded with fres data i just wanted make sure that data loaded from DTS to table successfully,taht is why I need kind of success or failure message from DTS and pass to Proc and from proc I can catch that mesage from print command.Thankschndraquote:
Originally posted by VyasKN
Not sure I follow you. Are you planning to provide a stored proc that will run and show the user, the status of last executed DTS package?--HTH,Vyashttp://vyaskn.tripod.com
chandra shekar |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-06 : 12:57:36
|
| ?? From the data load task, create a failure workflow and a success workflow. Attach those to a SQL task that calls a stored proc with one message or another.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
cshekar
Starting Member
49 Posts |
Posted - 2004-08-06 : 14:31:05
|
Thank you so much I got idea now.Chandraquote:
Originally posted by derrickleggett
?? From the data load task, create a failure workflow and a success workflow. Attach those to a SQL task that calls a stored proc with one message or another.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
chandra shekar |
|
|
|
|
|
|
|
|
Error Handling in DTS