oracle destination Table Name expression

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
mallison
Posts: 1
Joined: Mon 12 Aug 2019 20:45

oracle destination Table Name expression

Post by mallison » Mon 12 Aug 2019 20:50

I'm evaluation the oracle data flow components. How is possible to use an expression for the TableName in the oracle destination component? I don't see any variables for the oracle destination component in the Data flow properties.
We have multiple schemas with the same table name and need to parameterize it.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: oracle destination Table Name expression

Post by Shalex » Thu 15 Aug 2019 17:43

There is no way to set TableName in Devart Destination component at the moment. We will investigate the question and notify you about the result.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: oracle destination Table Name expression

Post by Shalex » Sat 14 Sep 2019 14:37

The possibility to set object name via user variable in destination components is implemented: viewtopic.php?f=60&t=39336.

After you created the variable named tableName, set ObjectName=User::tableName in the destination component.

Post Reply