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 |
|
whizsql
Starting Member
17 Posts |
 Posted - 2008-12-17 : 16:20:04
|
| hi,I created a simple SSIS impoer export package that exports data from one database to another database on the same server.I did execute the package and it ran successfully and verified that the data is loaded to the database too...I am created this package from BIDS on my desktop connecting to the server using 'sa' account.As a next step, I created a XML package configuration file (.dtsConfig)which has properties such as Connection string,server Name,User name,password of source & destination connections.I also, build the package for deployment. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 18:01:48
|
| http://www.sqlis.com/post/Easy-Package-Configuration.aspx |
 |
|
|
|
|
|
SSIS package execution