All geek questions in one place

SSIS - Using Parameters in Oracle Query Using Oracle Datasource Attunity

I am using the Attunity Oracle Connector in SSIS to connect to a remote Oracle server.

In my SSIS package, I need to connect to an Oracle database to retrieve data based on datetime parameters.

I followed the suggestions here to write a query SELECTwith a parameter:

  • Created a batch variable
  • Set the variable to evaluate as true
  • Put the query in the expression along with the parameter as another package variable
  • Define an expression for [Oracle Source].[SqlCommand]in the data stream for a package variable (containing the query as an expression)

I am satisfied here, but if you set the expression for [Oracle Source].[SqlCommand]in the data stream, what query do I set in the "Oracle source" inside the "Data Stream" task? How to get output columns and perform conversions?

I cannot execute the package until I install a valid Oracle data source.

Each recommendation indicates that the property is [Oracle Source].[SqlCommand]used in the data stream, but no one mentions how to configure the Oracle source. Did I miss something?

Update (2014/02/18) -

Based on the comments of @billinkc, I created a data source with a nonparametric query and added an expression to the data stream. When I execute the package, the request inside the data source changes to everything that is in the package variable expression, but it throws an error:

OCI. ORA-00936:

WHERE -

Where SL.RECEIVED_DATE = TO_DATE( @[User::Last_Run_Timestamp] , 'dd/mon/yyyy HH24:MI:SS')

+4
2

Attunity Oracle . . SSIS .

, SSIS ​​ Evaluate as, true, . PowerShell, . . @[User::Last_Run_Timestamp] , + .

"SELECT * FROM Table SL Where SL.RECEIVED_DATE = TO_DATE( " 
+ (DT_WSTR, 24)@[User::Last_Run_Timestamp] 
+ " , 'dd/mon/yyyy HH24:MI:SS')"
+6

. , ...

  • Flow Flow "".

  • "" , .

  • [Oracle Source]. [SqlCommand], .

: http://sornanara.blogspot.com/2013/11/ssis-use-dynamic-sql-in-oracle-source.html

+3

Source: https://habr.com/ru/post/1526897/

More articles:


All Articles