Convert FROM SQL BOOLEAN TO ORACLE INT

• hi.shobhit76

  SSC-Addicted

  Points: 420

  More actions

  July 20, 2009 at 12:18 am

  #202681

  Hi ,

  I am making a SSIS job to transfer data from SQL Server to Oracle database which have the same schema.

  Now in one of my tables in SQL a column is of data type BOOLEAN but the corresponding column in the same table in Oracle is Integer.

  So while transferring the data from SQL to Oracle i want to typecast this column value from Boolean to Integer.

  Can you guys please help me doing the same in SISS.

  Thanks and Regards

  Shobhit Bansal

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  August 29, 2009 at 6:09 pm

  #1046556

  Did you check SSIS cast? http://msdn.microsoft.com/en-us/library/ms141704(SQL.90).aspx

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

• jacksonhana

  Valued Member

  Points: 55

  More actions

  September 10, 2009 at 7:19 pm

  #1052047

  PaulB (8/29/2009)

  ---

  Did you check SSIS cast? http://msdn.microsoft.com/en-us/library/ms141704(SQL.90).aspx

  Glad to read such a nice piece of information.

  This is exciting news.

  what a great info, thanks.

  property asset project | document internet management software [/color]Utilizing your internet resources effectively through internet management software. property asset project | document internet management software [/color]

• becklery

  Hall of Fame

  Points: 3315

  More actions

  October 20, 2009 at 9:25 am

  #1068292

  Imports System

  Imports System.Data

  Imports System.Collections

  public class MainClass

  Shared Sub Main()

  Dim A As Boolean

  Dim I As Integer

  A = True

  I = CInt(A)

  Console.WriteLine("True Value of Boolean in Integer is: " + I.ToString())

  A = False

  I = CInt(A)

  Console.WriteLine("False Value of Boolean in Integer is: " + I.ToString())

  End Sub

  End Class

  RAQ Report: Web-based Excel-like Java reporting tool[/url]