Hi Can I trigger an ssis package to run by vba and pass a variable value to it ? Thanks

Not sure about the VBA code.. Work Around: Call Storeprocedure in your VBA application and pass the parameters dynamically. <tt>exec xp_cmdshell 'dtexec /f mypackage.dtsx /set \package.variables [myvariable].Value;myvalue'</tt> <tt>let us know your obseravtion</tt> Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/

Execute package : http://msdn.microsoft.com/en-us/library/ms136090.aspx. Basically using Package.Execute(); Working with Variables : http://msdn.microsoft.com/en-us/library/ms136082.aspxHappy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!