July 7, 2010 at 3:53 pm
Hi,
I have very strange problem here. I have sql server 2008 on the server. When
I developed SSIS package, I used package configuration to specify different
parameters. I defined location i.e. D:\Config\pckcfg.dtsconfig.
I need to run it on a
different occasions, but using different package configuration files. I
schedule SSIS job, and I specify different package configuration file (job
step properties - configuratiosn tab):
D:\DifferentConfig\diffpckcfg.dtsconfig.
When I run this job, it ALLWAYS USES package configuration that I specified
when developing package: D:\Config\pckcfg.dtsconfig!!!
Why is this happening? Is there any setting that I might have missed?
July 7, 2010 at 7:19 pm
please help me out with this problem..
July 8, 2010 at 7:15 am
I searched a little and there is an option in steps tab of job scheduling that overrides the design values of variables...IS that the solution?
July 8, 2010 at 7:47 am
[p]How diffpckcfg.dtsconfig file been created? Did you create this configuration file along with pckcfg.dtsconfig? May be it is helpful when you view code of your package.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 8, 2010 at 8:12 am
I have modified the pckconf file by changing the values of variables for example by changing sales.csv to sales1.csv. And I renamed the file as diffpckconf.dtsconfig
I have created another job which executes the same package but with with this new configfile. But the problem is it still executes my sales.csv file not sales1.csv.
Let me know if you need any other additional infO?
July 8, 2010 at 11:45 pm
[p]In BIDS, right click on your package -> click on View Code -> and search for your configuration file name or configuration name. Modify file name there if anything is required.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply