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 |
|
Yukon2005
Starting Member
8 Posts |
 Posted - 2006-02-20 : 01:25:09
|
| Hi everyone, I'm pretty new to DTS packages and need some help, plz...I have create a dts package with 4 steps:Step 1: Checks that data exists in 2 table to be exported. (ActiveX Scripting Task). If the no records exist then an error message should display using VBScript E.g. MsgBox("Error Message", 16, "DTS Package Name")Step 2: Checks that the folder to be exported to exists. (ActiveX Scripting Task). If the folder could not be found an error message should display using VBScript E.g. MsgBox("Error Message", 16, "DTS Package Name")Step 3: Source ConnectionStep 4: Export table data to a folder using Transform Data Task.My problem is that when I execute the dts package from query analyzer I get the following message back:LoadFromSQLServer failedOLE Automation Error Information sp_OAGetErrorInfo failed.and the error message I specified... How do I resolve this? The thing is that the end user will be executing it using a stored procedure from a button click and I need him to see the error I have specified.Any light whould be of great help. Thank you in advance. |
|
|
Yukon2005
Starting Member
8 Posts |
Posted - 2006-02-20 : 02:30:55
|
| Oops... I found my problem. There was an invalid variable in my if clause that caused it to fail....I'm executing the package using the dtsrun utility:exec master.dbo.xp_cmdshell 'dtsrun -E -S {ServerName} -N "PackageName"'The funny thing is that when the table has no data, an error should be returned. Yet it just keeps running and running like it's in a loop or something. Any knowledge of this? |
 |
|
|
|
|
|
Running DTS Package from a stored procedure