Post reply

Unable to connect UBD databases through SSIS

  • October 13, 2009 at 3:13 pm

    #212106

    Hi All

    I am trying to transfer data between to dufferent RDBMS. I am transferring data from UDB to SQL2005 using ssis.

    I dont know whether i can ask this question in this forumn, but still i hope some of you might have done it. So here is my issue.

    I got the following details for connecting the UDB.

    Host name : servername

    Database: dbname

    user id

    password

    These are the infor mation i got to connect the UDB. I installed the oledb drivers for DB2 provided by microsoft.

    I selected a oledb connetion source and opted oledb drivers for DB2 option and used the above credentials. and when i hit on test connection i am getting an error cannot initialize....

    I can understand that there is something wrong in the connection details. But i never saw a UDB and i dont have nay dea whether i need to use any port number or any server name (we use saql.ini for sybase through which we can get the server name and port name and update it in data links tab of source connection).

    If any one of you can help me proceeding further with the connection should be of great help.

    Sorry for posting this question realated to UDB. I posted this one since someone might have used UDB as connection source in ssis. Any information is highly appreciated.

    Thanks in advance

  • October 14, 2009 at 9:01 am

    #1065749

    Did u try connecting from an ODBC source (create one for DB2) withe the credentials u have.

  • October 16, 2009 at 10:12 am

    #1067026

    Have you tried using "IBM OLE DB Provider for DB2" ? Microsoft's driver is quite old and it may not work in all cases.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • October 16, 2009 at 3:01 pm

    #1067222

    Hi All

    Sorry for th elate response. I tried IBM driver but it didnt work. The doubt i have is whether DB2 uses default port and user defined port (i dont know db2 so plz bear my dumb question).

    If db2 is same as sybase then i thing it shd have a file like sql.ini where we can find the port and exact server name. Since i cannot login to the ibm box i am not sure how proceed further.

    Thanks

  • October 16, 2009 at 3:14 pm

    #1067237

    r_prasanna82 (10/16/2009)

    Hi All

    Sorry for th elate response. I tried IBM driver but it didnt work. The doubt i have is whether DB2 uses default port and user defined port (i dont know db2 so plz bear my dumb question).

    If db2 is same as sybase then i thing it shd have a file like sql.ini where we can find the port and exact server name. Since i cannot login to the ibm box i am not sure how proceed further.

    Thanks

    If you are using the IBM DB2 driver, I want to mention one confusing thing about the setup. In the dialog you have to enter the server name in the Location property and the database name in the Data Source property. Try to specify the port after the server name like this - ServerName:port

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply