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 |
|
Fredforfree
Starting Member
49 Posts |
 Posted - 2009-07-08 : 11:38:33
|
| Hi I am attempting to create a table from data in a view from server 1I need to have this table created on server 2, how can i do that?FredFred |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 11:41:42
|
| use ssis export import task and create the destination table in server 2 |
 |
|
|
Fredforfree
Starting Member
49 Posts |
Posted - 2009-07-08 : 12:10:49
|
| Hi Visakh16Thanks, i had neglected to change the destination server to server 2 in connection managerOLE DB SOURCE SERVER 1OLE DB DESTINATION SERVER 2Fred Fred |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 12:14:35
|
| sorry didnt get you..did it work? |
|
|
|
Fredforfree
Starting Member
49 Posts |
Posted - 2009-07-08 : 12:20:50
|
| Yes thanks, do you know how to stop an ssis package in the middle of running?Fred |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 12:23:48
|
| yup. click the red square button on top toolbar |
|
|
|
Fredforfree
Starting Member
49 Posts |
Posted - 2009-07-08 : 12:34:41
|
| Stop Debugging thanks againFred |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 12:35:55
|
| welcome |
|
|
|
Fredforfree
Starting Member
49 Posts |
Posted - 2009-07-08 : 12:52:44
|
| One more question please, when a package is automated to run and copy source data to destination table.How does the package know not to copy everything again when really all you want is any new data?FredFred |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 12:59:06
|
| you need to have either pk column or audit column in your table which you will need to compare in your ssis package and take only changed once.you may use scd wizard task if you want which does this for you based on your pk column |
|
|
|
|
|
|
create table on different server