In any case you can do this though but its not a recommended approachCREATE TRIGGER dtsxON TB_ClientFOR INSERTASBEGINDECLARE @PK int,@License varchar(100),@Name varchar(50),@dtsExecCmd varchar(max)SELECT @PK= MIN(PK)FROM INSERTEDWHILE @PK IS NOT NULLBEGIN SELECT @License = License,@Name = NameFROM INSERTEDWHERE PK = @PKSET @dtsExecCmd='' SET @dtsExecCmd = 'dtexec /F "your dtsx file path here"' SET @dtsExecCmd = @dtsExecCmd + ' /CONFIGFILE "configuration file path"' SET @dtsExecCmd = @dtsExecCmd + ' /SET "\package.Variables[User::License].Properties[Value]";"\"' + @License + '\""' SET @dtsExecCmd = @dtsExecCmd + ' /SET "\package.Variables[User::Name].Properties[Value]";"\"' + @Name + '\""' EXEC @result = master..xp_cmdshell @dtsExecCmd IF (@result is not null and @result<>0) --write any error logic hereSELECT @PK= MIN(PK)FROM INSERTEDWHERE PK > @PKENDENDGO
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs