question

rjareno avatar image
0 Votes"
rjareno asked rjareno commented

Data Lineage on SSIS with Azure Purview

Hi,

I'm testing Azure Purview. I have some projects with SSIS and I have migrated the projects to Azure Data Factoy. The projects and its pacakges work correctly. On some data flows I have used SQL Commands (Components) to update records on destination table. When I use PurView I get this error :

Salida
{
"reportLineageToCatalog": {
"status": "Failed",
"message": "Code:300007\nDescription: Lineage is not supported for '[SqlCommand]

I think that the some components are not supported on Azure PurView. I need to know if these components are going to be supported or that other alternatives exist.

Thank you
Regards

azure-purview
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered rjareno commented

Hello @rjareno,

Welcome to the Microsoft Q&A platform.

For the lineage of Execute SSIS Package activity, we only support source and destination. The lineage for transformation is not supported yet.

For more details, refer Push Data Factory lineage data to Azure Purview (Preview).

Hope this helps. Do let us know if you any further queries.


Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @rjareno,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @rjareno,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!

0 Votes 0 ·

Hi,

Thank you. In this link there is informaction too.

Do you know the roadmap? Will it be supported?

Regards


0 Votes 0 ·
rjareno avatar image
0 Votes"
rjareno answered

Hi,

Thank you. In this link there is informaction too.

Do you know the roadmap? Will it be supported?

Regards


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.