SSIS - load data from informix source to sql server source

Question

0.00/5 (No votes)

See more:

Hi All,

(I am using SQL Server 2005.)

I have to load data from Informix data source to Sql server data source.I have managed to create connection manager. Create a source as oledb provider using IBM Informix
write a query.. Query was successfull.. but giving me an error while clicking on Ok.
Warning message:

Warning at {EE28B0F3-B7BC-4311-8E7D-F809EAD92902} [OLE DB Source [1]]: 
Cannot retrieve the column code page info from the OLE DB provider.  
If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.

Please assist me in this regard.

Thanks.

Posted 14-Dec-11 19:38pm

sandeepa rout

Updated 14-Dec-11 19:49pm

Mehdi Gholam

v2

Add a Solution

Comments

Al Moje 15-Dec-11 1:49am

Could you post your query or any script you had made in your package?

sandeepa rout 15-Dec-11 2:09am

Thanks For responding. The query is:
select a.t_dim1, a.t_dim2, a.t_orno, a.t_pono, a.t_invd, a.t_cuno, d.t_nama, a.t_amta, a.t_damt, a.t_iper, a.t_item, b.t_dsca,
t_invn, t_ttyp, b.t_citg, t_dfpr, a.t_cwar, d.t_comp
from ttdsls951010 a, ttiitm001010 b, ttdsls950010 c, ttccom010010 d
where t_invd between date('2010-11-01') and ('2010-11-28')
and a.t_cuno=c.t_cuno
and a.t_cuno=d.t_cuno
and a.t_item=b.t_item
and a.t_item=c.t_item
and d.t_comp = '10'
order by a.t_invd

sandeepa rout 15-Dec-11 2:12am

It is giving me this error now : An OLEDB record is available, Source: "(null)" Hresult: 0x80004005 description: "(null)".

Exception from HRESULT: 0xC020801C(Microsoft.SqlServer.DTSPipelineWrap).

What is the process to build the SSIS package. I am new to SSIS.

Al Moje 15-Dec-11 2:38am

Hi,
You are using an alias...
but wait some has no alias like: t_invn, t_ttyp

sandeepa rout 15-Dec-11 2:46am

yeah but it is executing. And not giving any error. I have run it in WinSQL as well..

Can you please tell me the flow how to build the package to load the data . May be it will helpful.

Al Moje 15-Dec-11 3:02am

Hi, I think the simple interpretation of building the SSIS Package is
Extract Tranform and Load (ETL). As I see in you code your are in the way of
tranforming the data from your temporary table to your target table and maybe there should be needed fixing on it...

sandeepa rout 15-Dec-11 3:07am

Yeah.. But not getting how to do it. In control flow I have selected "Execute SQL Task". There I have used the IBM Informix SQL OLEDB Provider. After this I am not getting it how to proceed further.

Thanks.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Al Moje · Accepted Answer · 2011-12-14T21:46:00

Solution 1

Hi,

See this link if could help...
Loading data from Informix 2000 into SQL 2005

Regards,

Posted 14-Dec-11 21:46pm

Al Moje

Comments

sandeepa rout 15-Dec-11 4:16am

The link is really helpful..

But I am completely new to SSIS and technically not strong in PL/SQL can you please provide me with any sample.

Thanks.