Data Lineage on SSIS with Azure Purview

Question

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

Answer 1

Hello @Raúl Jareño Zamora ,

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.

Answer 2

Hi,

Thank you. In this link there is informaction too.

Do you know the roadmap? Will it be supported?

Regards