Execute SSIS package
-
Hi. I have a SSIS package named TESTPACKAGE on the 2005 SQL Server. How I can exeucte it from VB.NET? I found some articels that refer to Microsoft.SQLServer assembly but I use older .NET Framework version (1.1) and this assembly is not availabe for me in Visual Studio (2003). I read something about DTEXEC command. Can I use it in the Stored Procedure to run SSIS. I used this code in the Stored Procedure to run DTS package on the previsous/older SQL Server version.
CREATE PROCEDURE dbo.exportData AS Exec master..xp_cmdshell 'DTSRUN /SMYSERVER /NTESTDTS /Umyaccess /Pmypassword' GOThank you, -
Hi. I have a SSIS package named TESTPACKAGE on the 2005 SQL Server. How I can exeucte it from VB.NET? I found some articels that refer to Microsoft.SQLServer assembly but I use older .NET Framework version (1.1) and this assembly is not availabe for me in Visual Studio (2003). I read something about DTEXEC command. Can I use it in the Stored Procedure to run SSIS. I used this code in the Stored Procedure to run DTS package on the previsous/older SQL Server version.
CREATE PROCEDURE dbo.exportData AS Exec master..xp_cmdshell 'DTSRUN /SMYSERVER /NTESTDTS /Umyaccess /Pmypassword' GOThank you,Don't Cross Post in Multiple Forms.
Regards, Satips.:rose: