Post reply

Script componenet with OLEDB connection

  • May 11, 2011 at 9:19 am

    #145592

    I am using OLEDB connection in script componenet vb code. I am getting cast conversion error. I am using the following code:

    conMgr = Me.Connections.MyConnection

    sqlConn = CType(conMgr.AcquireConnection(Nothing), SqlConnection)

    I got to know that the script component support only ADO.NET. Please let me know how to change this code to support ADO.NET.

    Thank you for the help.

  • May 11, 2011 at 9:14 pm

    #1323459

    Check this post how to use OLEDB connections in script.

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

  • May 12, 2011 at 11:28 am

    #1323854

    Thank you for the reply. It is very useful. But, I found another easy process as I created a new ADO.NET connection to my database and connected through regular process. So, I didn't change the code even. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

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