"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
news:DGU4wWD5FHA.2880@TK2MSFTNGXA01.phx.gbl...
> 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@remove.this.wrd.state.or.us>
> | From: "frostbb" <frostbb@newsgroups.nospam>
> | 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@TK2MSFTNGP10.phx.gbl>
> | 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
> |
> |
> |
>