• subramaniam.chandrasekar - Monday, February 5, 2018 11:42 PM

    Now, Post creation of your ssis package and provide your own parameters and try to excute as below,

    C:\Program Files\Microsoft SQL Server\100\DTS\Binn>

    DTExec.exe /f “E:\w\Integration Services Project1\Integration Services Project1\Package.dtsx†/SET \Package.Variables[User::Input_One].Properties[Value];â€29″ /SET \Package.Variables[User::Input_Two].Properties[Value];â€29″ /SET \Package.Variables[User::Name].Properties[Value];â€TestUSerâ€

    Be careful though - the shared files directories are based on the version of SQL Server. 100 is 2008. For SQL Server 2012, it would be 110. And it isn't necessarily on C:\

    Sue