<jimdefruscio@yahoo.com> wrote in message
news:1168372846.836406.204740@o58g2000hsb.googlegroups.com...
> Is there a way to use xp_cmdshell (or any other method) to execute an
> SSIS package residing on a SQL Server 2005 from a stored procedure on a
> SQL Server 2000 database?
>

"jimdefruscio@yahoo.com" <jimdefruscio@yahoo.com> wrote in message
news:1168372846.836406.204740@o58g2000hsb.googlegroups.com:

> Is there a way to use xp_cmdshell (or any other method) to execute an
> SSIS package residing on a SQL Server 2005 from a stored procedure on a
> SQL Server 2000 database?
>
> I used to have a procedure that used a COPY SQL Server Objects tasks to
> copy data from tables from a source (SQL Server 2000) database to a
> destination (SQL Server 2000) database. This DTS package was called
> programmatically in a stored procedure using xp_cmdshell and DTSRUN.
> Recently the destination server has been upgraded from SQL Server 2000
> to 2005 and I can not get the DTS to connect to SQL Server 2005. So, I
> built an SSIS package that will do the task, but I can not figure out a
> way to call the package in a similar way.
>
> Any help would be appreciated!