Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bhavika18
Starting Member
4 Posts |
 Posted - 2011-04-15 : 08:05:21
|
| I have to import data from Excel to Database .In between that i need to check several validations such as duplicates, Distinct rows , quantity cannot be negative etc etc .So which transformation should i use to check validations. i need to check around 7 validations before the data goes into the DB table.Thanks & Regards,Bhavika |
|
|
ZZartin
Starting Member
30 Posts |
Posted - 2011-04-15 : 14:09:47
|
| It sounds like some of your filtering could be done with a conditional split and some of it could be done with a script component in the data flow.Although it might be easier to load the data into a temp table and use a SQL statement to do some of the filtering. |
 |
|
|
Bhavika18
Starting Member
4 Posts |
Posted - 2011-04-16 : 02:20:28
|
| Please help.I have to check this condition : (select count(distinct columnName) From tablename) > 1 Which transformation should i use for it . Thanks & Regards,Bhavika |
|
|
|
|
|
|
Which SSIS transformation to used