SQL Server Performance

Need Help with SSIS data loading from flat file

Discussion in 'SQL Server 2008 Integration Services' started by ksmith992, May 29, 2009.

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

Share This Page