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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy