Need to set Alwaysusedefaultcodepage as true?

Question

Post reply

Need to set Alwaysusedefaultcodepage as true?

ravi.s.kakumani

SSC Veteran

Points: 281
More actions
June 24, 2009 at 12:20 pm

#207467

When I was creatingOLEDB Source in SSIS, I got the warning like "Cannot retrieve the column code page info from the OLE DB Provider" . When I set Alwaysusedefaultcodepage property to true, It's gone. But I got the output both the times. Then why do we need to set Alwaysusedefaultcodepage property to true?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

duplicate post. post replies here

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

ravi.s.kakumani SSC Veteran Points: 281 More actions · Answer 2

ravi.s.kakumani

SSC Veteran

Points: 281

June 24, 2009 at 1:51 pm

#1014907

I knew that. I was not able to delete it..

WayneS SSC Guru Points: 95461 More actions · Answer 3

And yet you still bothered to double-post.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2