Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sandesh.ravi
Posting Yak Master
110 Posts |
 Posted - 2011-10-12 : 10:40:16
|
| Hi, I have created SSIS packages in development server where data source pointing to development sql server and the source file path is in development server. I need to move these packages to production server where in the packages should point to production sql database and the path of the source file is different from the development path.Please let me know the easiest way to do this.Thanks,Sandesh |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-12 : 10:42:10
|
| You could use a configuration file but I usually call the packages with the connection data as parameters - picking this data up from a table.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-10-12 : 10:54:21
|
| Thank you. I am planning to use configuration file with connection string property set.Thanks,Sandesh |
|
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-10-12 : 11:16:12
|
| Do I need to change the configuration settings and then run the deployment utility or the other way round?Thanks,Sandesh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-12 : 12:04:17
|
| you can specify configuration settings even when deploying through deployment utility------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-12 : 12:33:20
|
| Create the config file on your dev box. Copy the config file to the server then change the values in it.If you do everything with files including the packages then this is easy - just a file copy.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Deployment of SSIS Packages to production server