SSIS Script Task

Hi There,

I need to use a system DSN to connect to the remedy database in a script task.

Has anyone done this before? Is this doable? would anyone have a sample code of connecting to remedy using a script task in SSIS.

YRKS
YRKSAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
vdr1620Connect With a Mentor Commented:
try this below code

Imports Microsoft.Data.Odbc

Dim conn As Odbc.OdbcConnection
Dim comm As Odbc.OdbcCommand
Dim conn As Odbc.OdbcConnection
Dim comm As Odbc.OdbcCommand

connectionString = "DSN=BI_Database;UID="  Login ";Pwd="  Password  ";"
conn = New Odbc.OdbcConnection(connectionString)
conn.Open()
0
 
Reza RadConnect With a Mentor Commented:
when you work with Remedy or any other database with ODBC, then in Script there is no different what the database is, because ODBC connection is counted here.
So,
you can use simply ODBCConnection, ODBCDataReader and other ODBC objects to connect to it.
just you need an ODBC connection sample from .net code:

http://support.microsoft.com/kb/310988

0
All Courses

From novice to tech pro — start learning today.