DTS Packages

I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three step
SQL job that:
1. truncates data
2. runs a DTS package
3. runs a stored procedure
In 2000 I ran DTSRUNUI to generate an encripted command that generated a
GUID line. This was the line in I inserted into step two listed above.
In SQL 2005 I installed the dts compatability stuff but it does not give me
the DTSRUNUI application. Any suggestions other than use SSIS?
Thanks
Titan
Hi
Why don't you run the package using it's name?
John
"Titan" <Titan@.discussions.microsoft.com> wrote in message
news:380EC2B4-133A-4F4A-BA11-2677D1F066DD@.microsoft.com...
> I'm moving to SQL Server 2005 on a new box. In SQL 2000 I have a three
> step
> SQL job that:
> 1. truncates data
> 2. runs a DTS package
> 3. runs a stored procedure
> In 2000 I ran DTSRUNUI to generate an encripted command that generated a
> GUID line. This was the line in I inserted into step two listed above.
> In SQL 2005 I installed the dts compatability stuff but it does not give
> me
> the DTSRUNUI application. Any suggestions other than use SSIS?
> --
> Thanks
> Titan

DTS Package Scheduled Job Result Issue

I am using SQL Server 2000. I created Package1, Package2, and Package3. If I ran from scheduled job Package2 and it failed, the result in Job History is Failed. If I ran from scheduled job Package1 that runs Package2 and then Package3 and Package2 failed, the result in Job History on Package1 is Successful. Why? How can I have the result Failed so I can get the failure notification.

Thanks,

DanYeung

look at DTS Package Properties at Logging tab; there is a check box "Fail package on first error", see if it is on or off.|||

I couldn't find the Logging tab on the DTS Package itself (atually there is no properties when I right clicked) and the schedule job under SQL Server Agent - Jobs. The tabs on the schedule job are General, Steps, Schedules, and Notifications. I am using SQL 2000. Can you please advise? Thanks

DanYeung

|||

in "locale packages" of DTS in Enterprise open yor package, right click on window surface and then "Package Properties"

|||

It works. I have to check it in all 3 pacakges. Thank you.

DanYeung

DTS Package Scheduled Job Result Issue

I am using SQL Server 2000. I created Package1, Package2, and Package3. If I ran from scheduled job Package2 and it failed, the result in Job History is Failed. If I ran from scheduled job Package1 that runs Package2 and then Package3 and Package2 failed, the result in Job History on Package1 is Successful. Why? How can I have the result Failed so I can get the failure notification.

Thanks,

DanYeung

look at DTS Package Properties at Logging tab; there is a check box "Fail package on first error", see if it is on or off.|||

I couldn't find the Logging tab on the DTS Package itself (atually there is no properties when I right clicked) and the schedule job under SQL Server Agent - Jobs. The tabs on the schedule job are General, Steps, Schedules, and Notifications. I am using SQL 2000. Can you please advise? Thanks

DanYeung

|||

in "locale packages" of DTS in Enterprise open yor package, right click on window surface and then "Package Properties"

|||

It works. I have to check it in all 3 pacakges. Thank you.

DanYeung