1. ksmith992 New Member

   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!!
   

   ksmith992, May 29, 2009

   #2
2. satya Moderator

   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.
   

   satya, May 31, 2009

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in