case when source = 'hyderabad' then 'bangalore' else ' ' end as hyderabad, case when source = 'mumbai' then 'delhi' else ' ' end as mumbai, case when source = 'bangalore' then 'hyderabad' else ' ' end ...
Don't let an error message or two stop you from getting what you need. Here's a quick trick to keep things running. When building an SSIS package, you probably find ...