SQL SERVER 2012 - IntegrationServices (Assign values to variables in 2012 SSIS Package)

Question

Can i assign values to variables in 2012 using below command I have used the same command in 2008 and it works fine.

DTEXEC /SERVER"XXXXXXXX\SQLSERVER2012"/SQL"Mypackage.dtsx"/SET\Package.Variables[FilePath].Value;"C:\Test\testvariable.csv"

Wondering is there a different way in 2012 to pass values to variables dynamically.

Thanks in advance.

Did it work when you tried it? There are several ways to pass variables to SSIS dynamically. What are you trying to solve? — Eric Hauenstein, Jul 16 '15 at 20:09
Yes it works in 2008..Am using the same in 2012 and the procedure which am using this command fails . It doesn't show me any error. What are the other ways you suggest to pass the values dynamically ? — dunes, Jul 16 '15 at 20:33

score 0 · Answer 1 · answered Feb 06 '19 at 20:34

You can assign values to variables using dtexec 2012:

Syntax

dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue

Example

dtexec.exe /FILE "D:\TestPkg.dtsx" 
/SET \Package.Variables[User::FilePath].Properties[Value];"C:\Test\testvariable.csv"

References

1 Answers1