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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment