OLE DB Error in SSIS

Hi All,

We are using IBM iseries OLE DB provider and once we make a source connection using the same we get an error saying that the "Default Code Page" property is not defined and a default code page will be used.

Any ideas?

Thanks

Manish

Set AlwaysUseDefaultCodePage=TRUE on the source component.

-Jamie

|||

Thanks Jamie.

Tried it out but it also does not seem to work, though there are no validation warnings, the job runs and give a Pipeline PrimeOutput Error()

|||

That's probably a different error. i.e. Related to something else.

-Jamie

|||

I still feel its an OLE DB error because it starts with an error saying OLE db error with a hexadecimal value.

Any ideas?

|||

Yes, that was my point. i.e. The default code page is not the problem.

I personally have no experience of extracting from these systems.

You may want to try the data access forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

-Jamie