To say Goodbye to Excel - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

To say Goodbye to Excel

Author

Topic

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-04-13 : 12:48:34

I need to feed data with 904 columns, with markers in Excel to say NULL to some columns and Yes to others, resulting in 110 columns imported...

Which is the best transformation to use? Merge and Merge Join are not nice...??

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources