Share via

flowlet InvalidOperationException when using data preview after select

Julia Riedel 1 Reputation point
2022-08-10T08:23:14.6+00:00

I've build an scd2 data flow and want to put the logic of the data flow into a flowlet. Everything is working fine in the data flow but when I'm using a flowlet I always run into an error.

I've added some mock data to represent the issue....
When I connect the Output directly to the input everything looks fine:

229912-flowlet-data.png

For the next step I want to add the following select activity:

229872-flowlet-select.png

And when I then add the output again I get the following error message in the data preview:

229865-flowlet-error1.png

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator
    2022-08-11T10:23:02.86+00:00

    Hi @Julia Riedel ,

    Thanks for posting query in Microsoft Q&A Platform.

    Is your intention of select transformation here is to change column names hashKey and hashAll to '#odsHashKey#' and '#odsHashAll#' ? If yes, you should consider below settings to use.

    230328-image.png

    Is any specific reason to do same?

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.