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 file

I 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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |