x

SSIS OLEDB COMMAND

Team, help me resolve the below issue please:

Basic requirement is to update records in oracle table by comparing the records in SQL database table. If the records are present in both the oracle table and SQL table, the records need to be updated. I am creating a Data flow task with a merge join from SQL table & Oracle table as source. The output is then passed to data conversion task to handle the UNICODE conversion. This is then passed to OLEDB command Transformation (Connected to Oracle instance).This acts as destination. The update statement is something like : UPDATE TABLE_1 SET COL2 = ? WHERE KEY_COL = ? . I have verified that the column mappings are proper for these. The issue here is that when I execute the package, it executes successfully with out any warnings, errors. But, when I check the data in the Oracle table, the records are not updated ! any idea on how to resolve this ???
more ▼

asked Jun 09, 2012 at 01:07 PM in Default

loktaurian gravatar image

loktaurian
0 1 1 1

Are you passing riight parameters to the OLEDB Command?
Jun 11, 2012 at 05:40 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x927
x378
x3

asked: Jun 09, 2012 at 01:07 PM

Seen: 1280 times

Last Updated: Jun 11, 2012 at 05:40 AM