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 |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2011-01-19 : 14:23:48
|
| First i can't change my source file, My source files 99% data come like this below is example:P.K OR ID Table.Date_a Table.Date_b Table.Date_c Table.Date_d1 Null 12/23/78 null null2 12/4/98 null null null3 null null 3/24/90 null4 null null null 2/2/02In this example i want to grab only date that is not null, How i can accomplish this approach in SSIS. Hope my question is clear? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-19 : 14:57:51
|
| Easiest to import it all to a staging table, then query that table WHERE [DATE] IS NOT NULL; |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-24 : 11:42:48
|
| do you mean collapsing all of above rows to single row of not null values?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
NULL Value Issue