declare @DTSinSERVERName NVARCHAR(50)

declare @DTSname NVARCHAR(50)

 set @DTSinSERVERName='kftusoktulboa08\cb2'

 set @DTSname='sdbCanada.dbo.KMA_G_Hierarchy.imp'

declare @RESULT int DECLARE @SQL_STATEMENT NVARCHAR(1000)

    SET   @SQL_STATEMENT = N'dtsrun /S'+@DTSinSERVERName+' /Ucranberry /Pcranberry /N   '

  

 exec @RESULT= master..xp_cmdshell @SQL_STATEMENT