Need Help with SSIS data loading from flat file | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Need Help with SSIS data loading from flat fileI have a column in a flat file which is an 2power(x) integer.I need to convert this integer into binary number and push into different columns into a sql database table. e.g. 2pow3=8 =1000.I need to push 1 into a column,0 into another,0 into another and 0 into another i have the max number as 2pow15.How to do this using SSIS.Please Help!!
Welcome to the forums.
I believe you have to control or process the calculations on a staging table then use actual process to import into relevant columns.
To some extent you may take help of UNPIVOT http://www.mssqltips.com/tip.asp?tip=1761 kind of process.