DBA12345 (4/3/2013)

---

I need to pull the info from excel to the Database table through SSIS. I need logic for below scenario.

Excel Look like below:

Server Cost Values

SAB245DRU200

SAB246DRU2001

SAB247TAPE300

SAB248TAPE3001

SAB249DISK100

SAB250DISK1001

Output table should be:

Server DRU TAPE Disk

SAB245200NullNull

SAB2462001NullNull

SAB247Null300Null

SAB248Null3001Null

SAB249NullNull100

SAB250NullNull1001

Please let me know if you need more explanation.

thanks