SQL Server Performance Forum – Threads Archive
Error in DTS packages
–I am executing DTS packages from stored procedures <br />–Here is the Code<br />–***************<br />——————————————————————–<br />Declare <br />@Server varchar(255),<br />@PkgName varchar(255),<br />@ServerPWD varchar(255),<br />@IntSecurity bit ,<br />@PkgPWD varchar(255)<br /><br /><br />set @Server=’111.111.111.111′<br />set @PkgName=’New Package'<br />set @ServerPWD=’xxxxx'<br />set @IntSecurity=0<br />set @PkgPWD=”<br /><br />DECLARE @hr int, @ret int, @oPKG int, @Cmd varchar(1000)<br /><br />– Create a Pkg Object<br />EXEC @hr = sp_OACreate ‘DTS.Package’, @oPKG OUTPUT <br />IF @hr <> 0<br />BEGIN<br />PRINT ‘*** Create Package object failed'<br />select 1,’*** Create Package object failed'<br />END<br /><br />– Evaluate Security and Build LoadFromSQLServer Statement<br />IF @IntSecurity = 0 <br />SET @Cmd = ‘LoadFromSQLServer("’ + @Server +’", "’ + SUSER_SNAME() + ‘", "’ + @ServerPWD + ‘", 0, "’ + @PkgPWD + ‘", , , "’ + @PkgName + ‘")'<br />ELSE<br />SET @Cmd = ‘LoadFromSQLServer("’ + @Server +’", "", "", 256, "’ + @PkgPWD + ‘", , , "’ + @PkgName + ‘")'<br /><br />–=====[<img src=’/community/emoticons/emotion-2.gif’ alt=’![Big Grin :D :D](styles/default/xenforo/smilies/biggrin.png)
]]>