RE: Novice: How to modify rows (not add) using a script component
- From: changliw@xxxxxxxxxxxxxxxxxxxx (Charles Wang[MSFT])
- Date: Fri, 04 Aug 2006 09:38:37 GMT
Hi Shakir,
Thanks for your response.
I think it should be by design. SSIS need to consider various database
providers and abstract some interfaces for data sources. Also, script
component is a developer related feature and designed for those people who
need to program to realize their advanced or custom needs.
If you don't use SSIS, you can use the SQL statement OPENROWSET to
transfer data between two different data sources.
If two data sources are both SQL Server, you can use SQL directly by adding
linked server.
You may want the references:
OPENROWSET (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms190312.aspx
sp_addlinkedserver
http://msdn2.microsoft.com/en-us/library/ms190479.aspx
If you have any other questions or concerns, please don't hesitate to let
me know.
Charles Wang
Microsoft Online Community Support
.
- References:
- RE: Novice: How to modify rows (not add) using a script component
- From: Charles Wang[MSFT]
- RE: Novice: How to modify rows (not add) using a script component
- From: Charles Wang[MSFT]
- RE: Novice: How to modify rows (not add) using a script component
- Prev by Date: Unable to cast COM object error in SSIS
- Next by Date: Re: How to run a ssis package from .net code in 32-bit mode on a 64bit
- Previous by thread: RE: Novice: How to modify rows (not add) using a script component
- Next by thread: RE: Novice: How to modify rows (not add) using a script component
- Index(es):
Relevant Pages
|
