Solved

SSIS Script Task

Posted on 2010-08-18
2
743 Views
Last Modified: 2013-11-10
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
0
Comment
Question by:YRKS
2 Comments
 
LVL 16

Accepted Solution

by:
vdr1620 earned 300 total points
ID: 33467524
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
 
LVL 30

Assisted Solution

by:Reza Rad
Reza Rad earned 200 total points
ID: 33467912
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

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql query 107 30
SQL - SP needs a little help 9 25
Sql Query 4 19
ISDATE() not working properly on my table? Any suggestions. 7 14
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now