SSIS Deplyment Tip 09-01-2011

 

--Using variable in package to store sensitive information like db connection string). In db connection property , select expression and put connectionstring=@User::variablename

-- if a package will execute another package ( need to set second package protectlevel from default to dosavesentive)