July 20, 2009 at 12:18 am
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
August 29, 2009 at 6:09 pm
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.September 10, 2009 at 7:19 pm
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]
October 20, 2009 at 9:25 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply