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 |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2008-04-21 : 13:12:15
|
| hi,i'm total newbee on SSIS packages and therefore need guidance.I want to make a ssis package that (in order):- check in table (tbl_orders) if there is any new order made- if new order is made, update column (time_last_change)- if this order has geography ID (ID_geography) inserted, insert name of geography.Thank you in advance, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-21 : 14:37:04
|
| What all columns does your tbl_orders table have? |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2008-04-22 : 02:41:06
|
| Tbl_orders (id_order, price, price_no_tax, time_of_order, time_of_change, quantity).that's about it. |
|
|
|
|
|
|
package for update/insert and check for new record