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-10-17 : 11:07:12
|
| Hello All,i completed one package in SSIS (this is my first package ) in development system (localhost, on my desktop)the package task is, basically reads data from one flat file then writes to table and a procedure will execute to do some tasks on data then finally the table data will write to CSV file.now as i completed, i have to make it available on production servercan any one tell me how to deploy this package to serveri do have a look on configuration & deployment, but seems to be i have still some doubts on it1) where to specify source file path, 2) and where to specify destination file path, 3) where to specify DB server connection properties (i.e writes data to table from flat file)4) how can i set these three values (after deploy on production server)Thanks in advance,Best Regardsasin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 11:11:56
|
| you use packahe configuration to set values for all these. Then when package is moved from environemnt to other, it takes the value based on configuration settings. you can either use environment variables or xml file for storing configuration properties. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 11:14:40
|
| refer this toohttp://www.sqlis.com/26.aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-17 : 11:15:53
|
| http://www.mssqltips.com/tip.asp?tip=1405 |
|
|
|
|
|
|
how to deploy on to server & change conn mgr value