I have a rather simple ssis package. It has two datasources. One local and one remote.
I have Visual Studion 2005 installed on the SQL Server. (Server is 2008 R2) SQL 2005.
I can run the package just fine in Visual Source Safe, but when I deploy the package and run it from inside SQL Server (Job or Manually run the package) I get an error about the remote connection not haveing a password.
I have tried to change the protection level to server storage then saving the package but I get an error The system could not verify that the destination supports secure storage capability.
I have tried Encrypt all with password, but it won't save the password.
To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.