I'm building ETL packages in SSIS. My data comes from an OLE DB Source that calls a stored procedure in SQL Server. I want to add a new Lookup (or a similar transformation) that uses some of the input columns returned by the stored procedure to run additional SQL queries and create a new column in the ETL flow. How can I achieve this?
Something like "Get the sale by the SalesOrderID that comes from stored procedure"
I tried using Derived Column, but the expression field does not accept SQL, so I can only work with the data and variables that are in the ETL, and I need to run queries.
Attachments:
You must be
logged in to view attached files.