 | |
ssis update or delete
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: ssis update or delete -
05-23-2008
, 06:59 PM
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#12
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#13
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#14
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#15
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#16
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#17
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#18
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
#19
| |||
| |||
|
|
come on guys, i am desperado and need some help with this stuff. if you have some reading for me, please point it out. "lark" <l... (AT) buysurething (DOT) com> wrote in message news:2a2Xj.143$mh5.136 (AT) nlpi067 (DOT) nbdc.sbc.com... hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with an ssis package based on a csv file? thanks for you help.- Hide quoted text - - Show quoted text - |
1. Include a Lookup Transform in your data flow. Join the data from
the csv file to the db tables you are updating.
2. If you do not get a match, then insert the record using an oledb
destination.
3. If you do get a match then, update the row using an ole db
command.
If this is to update a dimension in a data warehouse, you could also
try using the slowly changing dimension transfrom (it will do
something very similar to the steps above.)
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.