Mostly the SSIS developers need to know the Hierarchy of the tables in the database to insert the data sequentially to avoid the foreign key violation errors. Of course you can disable all the foreign key constraints before load the data, but "disable foreign keys" as a step in SSIS is not a best practice to do it.
So as the first step is to get the list of the tables sequentially, refer the article published in SQLMAG.COM for this task at the below link :
So as the first step is to get the list of the tables sequentially, refer the article published in SQLMAG.COM for this task at the below link :
This will help the SQL Server DBAs, Developers and Analysts to list of the tables in a hierarchical manner to manage the data in the relational databases.
No comments:
Post a Comment