CODEWITHSUNDEEP
sql-servert-sqlssis
abs786123
abs786123

Reputation: 609

Data Profiling using TSQL and Stored Procedures

I would like to know the T-SQL used for data profiling, I believe there are 5 types of data profile used, I am aware SSIS has its own data profiling control flow task, however I would want it as a stored procedure in SQL Server for convenience and something that is set-based, if possible. Can anyone provide the SQL or reference to a place that covers all 5 types? Ideally I need to run this against a catalogue from information.schema against all tables.

Thank you

Upvotes: 1

Views: 2844

Answers (1)

Marcus D
Marcus D

Reputation: 1144

This rather long, but clever script by Adam Aspin, I have used to profile a table of data. Don't want to paste script into here.

Upvotes: 1

Related Questions