locked
JDBC Connection to SSIS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    Does anyone know how to use SSIS to connect to a datasource that only allows for JDBC Connections? Is this possible?

    Using SQL 2008 btw.

    Thanks in advance,

    - Vimal
    Tuesday, September 29, 2009 4:41 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Unproven idea, but you might try creating a J# assembly to access the JDBC and wrapping that in a script component.  Or you should be able to write a custom source using J#, but this would take more time.  There are some sample custom sources in C# at http://sqlsrvintegrationsrv.codeplex.com/.
    Matt Carroll (MSFT) -- This posting is provided "AS IS", with no warranties, and confers no rights.
    • Proposed as answer by Matt Carroll Wednesday, September 30, 2009 4:15 PM
    • Marked as answer by Tony Tang_YJ Monday, October 5, 2009 9:09 AM
    Wednesday, September 30, 2009 4:15 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    JDBC by definition is a Java API to let you connect to a RDBMS like SQL. The client code is Java only though. Its like ODBC, but for Java apps.

    SSIS does not have java lanaguage support (Script Task & Script Component can do VB and C#, but no J# or java)

    I don't think its possible.

    What kind of data source do you have?

    Thanks, Jason
    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
    Wednesday, September 30, 2009 4:40 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Unproven idea, but you might try creating a J# assembly to access the JDBC and wrapping that in a script component.  Or you should be able to write a custom source using J#, but this would take more time.  There are some sample custom sources in C# at http://sqlsrvintegrationsrv.codeplex.com/.
    Matt Carroll (MSFT) -- This posting is provided "AS IS", with no warranties, and confers no rights.
    • Proposed as answer by Matt Carroll Wednesday, September 30, 2009 4:15 PM
    • Marked as answer by Tony Tang_YJ Monday, October 5, 2009 9:09 AM
    Wednesday, September 30, 2009 4:15 PM