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

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.

SSIS - load data from informix source to sql server source

1 solution

Solution 1

Add your solution here

Preview 0

SSIS - load data from informix source to sql server source

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us