September 24, 2013 at 11:07 am
server name: A
Server name :b
ssis project to be moved
..
I am try ing getting lot of errors in the package.
September 24, 2013 at 1:42 pm
Hi Shaun
Please check out the following link:
Br.
Mike
September 24, 2013 at 1:54 pm
Which version of SSIS?
There are a lot of different options on how to deploy packages.
These two articles give an overview:
SSIS Deployments with SQL Server 2012[/url]
Which errors do you get?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 24, 2013 at 2:05 pm
Sounds like you have some hard coded items in the package. Are you using an XML config file, or a SQL Table to store the config items that need to be changed?
I keep things pretty simple, I never use Visual Studio to move a package. I simply copy the package file and the XML config file to the database server that I want. Log into the Integrated Services Server, import the package into the MSDB database and configure the SQL job with the path to XML config or the SQL table config.
I then change the entries in the XML config file or the SQL table, and execute the SQL job. I always put a simple bit value check in the package so that nothing happens to the actual data in the table while testing in each environment. This bit value can be changed in the config file or the SQL table.
Andrew SQLDBA
September 24, 2013 at 2:07 pm
AndrewSQLDBA (9/24/2013)
Sounds like you have some hard coded items in the package. Are you using an XML config file, or a SQL Table to store the config items that need to be changed?I keep things pretty simple, I never use Visual Studio to move a package. I simply copy the package file and the XML config file to the database server that I want. Log into the Integrated Services Server, import the package into the MSDB database and configure the SQL job with the path to XML config or the SQL table config.
I then change the entries in the XML config file or the SQL table, and execute the SQL job. I always put a simple bit value check in the package so that nothing happens to the actual data in the table while testing in each environment. This bit value can be changed in the config file or the SQL table.
Andrew SQLDBA
All nice and dandy if you have access to the production environment 🙂
At one client we can't touch the production environment and to be honest I don't trust the 3rd party DBA's not with the actions you described.
Too complicated for them 😀 I just give them a script they need to double click.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 24, 2013 at 4:07 pm
Hi Andrew,
I'm using SQL 2008 r2, both in prod and dev.
I am using XML config file.
My project has 5 packages.
I updated all the passwords but when I reopen, I get the same error which is oracle null kind error.. I can send the error as i reach home..
Regards
Shaun
September 24, 2013 at 4:22 pm
Forgot to mention using oracle 11g as well
September 25, 2013 at 12:34 am
Shaun2012 (9/24/2013)
Hi Andrew,I'm using SQL 2008 r2, both in prod and dev.
I am using XML config file.
My project has 5 packages.
I updated all the passwords but when I reopen, I get the same error which is oracle null kind error.. I can send the error as i reach home..
Regards
Shaun
Where did you update the passwords?
What is the protection level of the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 7:22 am
I saved the passwords in the package and encryption: EncryptSensitive with user key..
Regards
Shaun
September 25, 2013 at 7:41 am
EncryptSensitiveWithUserkey is a disaster waiting to happen, as sensitive data can only be de-encrypted when you open the package.
Unless you are going to run the package on production every time yourself of course 🙂
Use the DontSaveSensitive protection level and store the passwords in the configuration file.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2013 at 8:30 am
I will do it, let you know any issues occur, but thank you so much for you help and going thoroughly..
Regards
Shaun
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply