Showing posts with label quotdefault. Show all posts
Showing posts with label quotdefault. Show all posts

Wednesday, March 7, 2012

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