Solved

SSIS Script Task

Posted on 2010-08-18
2
742 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
Comment Utility
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
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

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.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

771 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

12 Experts available now in Live!

Get 1:1 Help Now