RE: Repost: Sql Server 2005: SSIS "OleDb Data Source" problems (MSDN Universal Subscriber)

Hello Barry,

I am not quite sure about for Informix because there is on buitl in OLE
provider for it but you could try the following steps:

1. Open the existing SSIS project.
2. On the right panel, right click Data Sources, and click New Data Source.
3. Click New button to create a new Data souce.
4. On Provider, select the Informix oledb provider you want to use
5. Select the server name, username, password etc which is UI provided by
Informix oledb provider.
6. Click OK
7. You could double click the data connection you created to see the
connection string.

Hope this is helpful.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Reply-To: "frostbb" <barry.b.frost@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
| From: "frostbb" <frostbb@xxxxxxxxxxxxxxxxx>
| Subject: Repost: Sql Server 2005: SSIS "OleDb Data Source" problems (MSDN
Universal Subscriber)
| Date: Mon, 7 Nov 2005 08:29:14 -0800
| Lines: 87
| Organization: Oregon Water Resources Dept
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OnZ$1g74FHA.744@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: 159.121.113.234
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:15971
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| I'm trying to use the SSIS "OleDB Data Source" object to create a
| connection to our Informix DB. I'm not having any luck. I'm totally
unsure
| about how to translate our working connection string parameters into
| SSIS OleDB Object properties.
|
| Any help would be greatly appreciated ... Thanks in advance!
|
| Barry
| in Oregon
|
| THE SPECIFICS ...
|
| ENVIRONMENT: We have a major data entry (and bunches of other) C# .Net
| applications SUCCESSFULLY CONNECTING to our Informix DB on a daily basis
| with no problems what so ever using OleDB. The connection string
paramaters
| are similar to those below. I have the newest (2.90) Informix OleDB
drivers
| loaded and they work fine with our C# & Web apps. So I know for certain
| that OleDB connections can be successfully established from MS Apps to our
| Informix DB.
|
| CONNECTION STRING:
| PROVIDER=Ifxoledbc.2;
| DATA SOURCE=owrd;
| User ID=xxxxxx;
| HOST=xx.yy.zz.aa.us;
| SERV=owrd_service;
| SRVR=owrd;
| PRO=onsoctcp
|
| QUESTION: I can't figure out how to configure an SSIS "OleDB Data Source"
| object to connect to our Informix database ... the OleDB Source Editor
| presents totally unfamiliar Lingo and Options ... So I've got a number of
| questons ... I'm definitely a stranger in a strange land with this SSIS
| stuff.
|
| 1st and formost is how to I translate the above connection string into
SSIS
| "OleDb Data Source" Editor fields & options.
|
| MY RESEARCH EFFORTS THUS FAR: If I click NEW a few times from the OleDb I
| eventually come to a Connecton Manager window. There I can click the
Data
| Links button and select our Infomix OleDB data provider. Clicking the
Data
| Links button again causes a Data Link properties window to appear ... dual
| purpos button - kind of wierd/unexpected behavior, plus it removes the
| ability to change your Data Link selection if you just happened to click
on
| an incorrect option ...
|
| The Data Link properties window provides 3 Tabs "Connection", "Advanced" &
| "All"
|
| The "Connection tab" asks for a Data Source and/or Location of the data
...
| I've tried bunches of guesses here but I've had no success.
| The Advanced Tab provides one option that can be edited "Connection
| Timeout" - I'm assuming the 0 seconds value means basically no time out.
| The All Tab provides Connection Time, Data Source, Extended Properties,
| Password, Persist Security Info, and User ID options - again I've tried a
| bunch of guesses here with no success.
|
| If I select the All Option from the Connection Manager side panel I get
the
| following options
|
| [Extended Properties] - can't find anything in the BOL or online to
explain
| what might work here (I'm guessing that their Informix Extended property
| options)
| [Connecton Timeout] - seems to be a favorite option and always defaults
to 0
| [File Name] - which I figured after some searching around wants the file
| name for a UDL file ... I created a UDL file that successfully connected
| with the UDL editor I'm using but wouldn't connect with the SSIS
Connection
| Manager "Test Connection".
| [OleDB Services] - which is set to default - don't have a clue as to what
| options might want to go in here.
| [Password] - I have a pretty good guess what might go here
| [Persist Security Info] - don't think it's really a part of the Informix
| OleDB provider
| [Data Source] - who know's, I've tried just about every incantation I can
| think of. (i.e. Connection string permutation / combination)
| [Provider] - is hard wired to Ifxoledbc.2 which should be correct.
|
| ANY HELP anyone may be able to provide getting the "OleDB Data Source" to
| use the Informix OleDB connector to connect directly to our Informix DB
| would be greatly appreciated.
|
| Thanks in advance,
|
| Barry
| in Oregon
|
|
|

.