| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-03-09 : 10:21:03
|
| Hi ! I'm trying to move my packages to Prod server using dtsconfig file. I defined parameters while deploying to server, but still see in file pointers to the DEV server. How does this work? Thanks a lot |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-09 : 11:05:06
|
| What do your mean by "I defined parameters while deploying to server"?Did you actually change the values in the config value before running the package? |
 |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-03-09 : 11:11:27
|
| Yes, while deploying there is an option to change some of parameters, for example server name (that's just what I need), but when I open config file after , there are still DEV server names in it. |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-09 : 11:13:57
|
| ok..so you changed the connection string...did u rebuild the config file...only then it will change.Or physically edit the config file and change ur values to prod and run the package using the new config file. |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-03-09 : 11:19:20
|
| That's exactly that I don't know how to do - how do I run the package with new file ? You mean deploy? copy it to server? |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-09 : 11:43:58
|
| yes...copy your package and config file to your server.I'll tel you what we do here..we create a .cmd commmand file and call it from an autosys job..but the command to execute the package is as belowdtexec /f "\\njros1d2224\Scripts\ACTGEXTR.dtsx" /CONFIGFILE "\\njros1d2224\Scripts\ACTGEXTR_D5.dtsConfig" dtexec "the location of the drive" "location of package " /CONFIGFILE "location of config file" |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-03-09 : 11:47:40
|
| Thanks . I was not sure if config file must be copied,because on dev server I don't have it. Do I have to make two of them? Is file's location important - I mean have it to be in the same directory as other packages? |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-09 : 12:05:30
|
| Its better to have all of them in the same location in the DB server. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-03-10 : 10:09:47
|
| That's what I'm trying to do. I managed to create and copy file to server, attached it to my job for the package, but now it fails - I receive an error Source: Data Flow Task OLE DB Source [1] Description: The column "FALNR" cannot be processed because more than one code page (1252 and 1255) are specified for it. End Error Error:I changed "AlwaysUseDefaultCodePage" to True' that helped in similar situations, but now it doesn't work. Maybe it's not exactly the announced issue, but maybe you can help ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-10 : 13:55:25
|
| whats the datatype of column in source? |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-03-11 : 03:14:12
|
| Hi ! Source and destination tables are tables of one column -FALNR varchar(10) |
|
|
|
|
ssis project from DEV to Prod