RE: Novice: How to modify rows (not add) using a script component
- From: changliw@xxxxxxxxxxxxxxxxxxxx (Charles Wang[MSFT])
- Date: Wed, 02 Aug 2006 06:18:10 GMT
Hi Shakir,
Do you use SQL 2000 ActiveX scripts DTS or SQL 2005 SSIS script task?
If you are using SQL 2000 ActiveX scripts DTS, by default, DTS
import/export wizard doesn't provide update option for data transformation.
To realize such function, you need to use ADO Recordset in your ActiveX
scripts.
For how to use ADO Recordset in ActiveX scripts, you can refer to:
Using ActiveX Scripts in DTS
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_
addf_ax_06er.asp
If you are using SQL 2005 SSIS script task, you still have to use sql
command to do the job other than use oledb destination directly.
You may refer to:
http://blogs.conchango.com/jamiethomson/archive/2005/02/08/960.aspx
If you have any other questions or concerns, please feel free to let me
know. it's my pleasure to be of assistance.
.
- Prev by Date: Returning value from SQL Task
- Next by Date: RE: Returning value from SQL Task
- Previous by thread: Returning value from SQL Task
- Next by thread: RE: Novice: How to modify rows (not add) using a script component
- Index(es):
Relevant Pages
|
Loading
