September 17, 2007 at 4:15 pm
SSIS is being used to move data into tables that will later be used in the generation of a cube. If this was for a single environment I would be done, but it isn't. The names of the database, and database server change, and in some cases the source database is Oracle and not MS SLQ 2005. The cubes are also on different MS SQL 2005 Servers.
I now have separate SSIS package files for MS SQL, and Oracle, but my attempts to move these files from the creation server to other servers always results in an error(s). The most common is "Failed to decrypt protected XML node". If I get past this error I end up with a useless error that only says the execution failed.
I don't have the option of creating a package on every environment, and training people at each site would be a nightmare.
Any help will be greatly appreciated.
September 18, 2007 at 2:10 am
Hi Andrew,
Have you try to use a "package configuration" file for you package and export the Connection String, Username and Password?
September 18, 2007 at 7:23 am
There is an MSDN thread about the "Failed to decrypt" error over at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142920&SiteID=1
If you use the SSIS Deployment Wizard along with a configuration file, you can specify the values for all configuration variables when you first deploy. That has saved me a lot of frustration when deploying packages to different servers.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply