ssis configuration

Question

Post reply

ssis configuration

pat-261672

Hall of Fame

Points: 3325
More actions
January 14, 2009 at 4:05 pm

#128037

Hi all,
I have SSIS package working fine, but the problem is this i want to use package on dev, test and prod system.
but the problem i am having that i have to change variable values all the time while deploying to different server. ( i am using cmd line to execute the package on 64bit server.
Is it possible for the package to look at the table in database for the variables values? so i only have to get package in directory of three system and not to worry about the variables values?
Please guide!!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Without information on specific problems you are having here are a few links that may help.

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

COZYROC One Orange Chip Points: 28499 More actions · Answer 2

pat (1/14/2009)
Hi all,
I have SSIS package working fine, but the problem is this i want to use package on dev, test and prod system.
but the problem i am having that i have to change variable values all the time while deploying to different server. ( i am using cmd line to execute the package on 64bit server.
Is it possible for the package to look at the table in database for the variables values? so i only have to get package in directory of three system and not to worry about the variables values?
Please guide!!

Yes, it is possible. When you setup your package configuration select configuration type to be "SQL Server". You can then select connection, configuration table, etc.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

pat-261672 Hall of Fame Points: 3325 More actions · Answer 3

Thanks for the reply,

also i have for each loop in the package. the job works fine when the file is there but if there is no file to process it fails. how can i set it up for the clean exit when there is no file to process?

pat-261672 Hall of Fame Points: 3325 More actions · Answer 4

I tried that but how can i config the package variable which holds the value and depend on each otheer. like filename for file name. filepath source folder. sorce filepath +filename for example. how can i set those values in SQL Table.

please guide!!

GSquared SSC Guru Points: 260824 More actions · Answer 5

One thing you can do is set those as variables, pull data from a table, and set the values of the variables from the values in a table.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon