|
I have some data in Excel and need to import into database. Is there any tool that can validate and maybe clean the data? Does Red Gate have such tool? The input will be Excel. Given table constraints, eg. CHECK, UNIQUE KEY, datetime format, NOT NULL. Desire output should be as least shows which lines are having problems, and then fix some trivial error automatically, like fill in default value for NULL columns, automatically correct datetime format. I know using Python can build such a script. But just wonder what's the popular way to do this. Thanks.
(comments are locked)
|
|
SQL Server Integration Services (SSIS) is the tool (SQL2005 onwards) that came bundled with SQL Server. You use this to develop ETL processes between many different data source and SQL Server. Prior to SQL 2005, you would have used Data Transformation Services (DTS) Thanks. So is there any component provided in SSIS can shows which lines are invalid data if given table constraints, eg. CHECK, UNIQUE KEY, datetime format, NOT NULL. And any component can fix some trivial errors. I know some of the checking rules still have to be make by SQL statement (via execute SQL task component), but I wish to find more standard method.
May 15 '10 at 04:13 PM
Stan
(comments are locked)
|
