Lineage for SQL query as a source in SSiS

Hari 1 Reputation point
2021-09-24T06:57:28.383+00:00

The lineage for SQL query as a source in SSIS is not support. Can you please add that as a feature.

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
948 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 77,901 Reputation points Microsoft Employee
    2021-09-27T09:56:37.91+00:00

    Hello @Hari ,

    Welcome to the Microsoft Q&A platform.

    Azure Purview currently doesn't support query or stored procedure for lineage or scanning. Lineage is limited to table and view sources only.

    135440-image.png

    For more details, refer to How to get lineage from SQL Server Integration Services (SSIS) into Azure Purview.

    Currently, lineage is supported for Copy, Data Flow, and Execute SSIS activities. Learn more details on the supported capabilities from Supported Azure Data Factory activities.

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

    As you know Azure Purview is currently in PREVIEW and we have been adding new data sources/lineages every month.

    Regarding service general availability, I would suggest to keep an eye on Azure updates.

    Azure updates provide information about important Azure product updates, roadmap, and announcements.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators