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 |
|
dhani
Posting Yak Master
132 Posts |
 Posted - 2008-11-05 : 11:45:36
|
| Hello All,i am developing SSIS package in my local desktop, using some test DB in my local machinenow i completed my project 1) what actually it does is reads file from source 2) writes this file data to SQL SERVER table3) then source file moves to another folder (ex processed folder)here in step 1 path is different in my local machine & in actual server path and also in step 2 the DB credentials are different in local db and original production server.in above step 3 it changed to another lcoation using a variablehow can i set up these paths on serveri mease how can i deploy on server these package with server paths PleaseThanks in advanceasin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-05 : 12:19:30
|
| you does this by means of setting package configurations. This enables the migration of package from one environment to another. See belowhttp://www.sqlis.com/post/Easy-Package-Configuration.aspx |
 |
|
|
|
|
|
howto set serverpaths&serverDB credentials on serv