Re: How do I connect an SSIS data flow to an existing SQL Server 2005
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hi YaHozna,
How does your function work? Is it a SQL function stored in the SQL
Server database?
If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.
Good luck!
J
.
Relevant Pages
- RE: Using SQL Native client (SQLNCLI) from unmanaged cpp
... SQL Server 2005 database is. ... Generally among the existing data access methods, ADO, ODBC and OLE DB, OLE ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
(microsoft.public.vc.database) - Problem with Linked Server from SQL to DB2
... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
(microsoft.public.sqlserver.server) - Problem with Linked Server from SQL to DB2
... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
(microsoft.public.data.oledb) - Re: Recordset Not Updatable
... > Server database, ... I was correcting and enhancing the ADP front-end to SQL ... updates by executing individual SQL statements for each control/field that ... But, as Sylvain says, there are many reasons why a recordset is not ...
(microsoft.public.access.adp.sqlserver) - Re: How to get list of EventClasses in MSSQLServer2000
... out using this procedure any system tables is available on SQL Server 2000. ... Errors','Indicates that an OLE DB error has occurred.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ...
(microsoft.public.sqlserver.security) |
|
