SQL Server Integration Services (SSIS)

  • 380 Blog Articles
Options
893
Sandy Winarko on 01-13-2021 09:58 AM
1,772
Sandy Winarko on 10-18-2020 04:51 AM
1,711
Chunhua on 10-15-2020 08:29 PM
2,054
Chunhua on 07-22-2020 08:33 AM
13.5K
Chunhua on 05-24-2020 05:08 PM
2,510
Chunhua on 05-11-2020 11:22 PM
2,565
Sandy Winarko on 12-31-2019 06:09 PM
3,913
Sandy Winarko on 12-12-2019 01:58 AM
4,635
Chunhua on 12-05-2019 04:21 PM
3,565
Chunhua on 11-25-2019 12:33 AM
4,791
xichen on 10-29-2019 08:40 PM
3,485
Lingxi on 08-29-2019 10:23 PM
4,329
Jarod_Zhu on 08-08-2019 11:31 PM
3,550
qianwen_shi on 08-06-2019 02:23 AM
23.2K
Tim.Chen on 05-14-2019 01:19 AM
3,589
Sandy Winarko on 03-25-2019 04:11 PM
1,773
SSIS-Team on 03-25-2019 04:10 PM
5,149
Sandy Winarko on 03-25-2019 04:09 PM
2,702
Sandy Winarko on 03-25-2019 04:08 PM

Latest Comments

SSIS Execute SQL Task cannot be used with Data Flow Task for each row. I am using OLE DB Command Task. But getting this error"Provider does not provide parameter information and SetParameterInfo has not been called". Wondering why such a basic functionality of Upsert or just Update is not covered by...
0 Likes
@ykhabins , how are you using the SSIS Execute SQL Task to connect to Oracle? Are you setting the ODBC connection manager to the SSIS Execute SQL Task and using the DataDirect ODBC driver for Oracle in the connection manager? The DataDirect ODBC driver for Oracle shipped with SSIS is only for intern...
0 Likes
@gsinghpt , are you using the OLE DB Command Task? It is not supported to use Oracle connection manager in OLE DB Command Task. To update the Oracle (not insert), please use SSIS Execute SQL Task. You need to find a ODBC driver for Oracle or OLDB driver for Oracle and setup the corresponding ODBC/Or...
0 Likes
@Chunhua, The existing Oracle Destination functionality is just for INSERT operations.What is missing is that SSIS Execute SQL Task is not supported for Oracle Connector connections. This will allow to execute direct UPDATE, or call Oracle modules or procedures. As of today, such attempt to execute ...
0 Likes
@Chunhua thank you for your response. I didn't find any information on how to update the data from the link you shared. Can you provide an example?
0 Likes