April 15, 2009 at 12:48 pm
Hello Everyone,
I started creating the SSIS package in my local machine, i am using OLE DB Source and assigned the connection and table, after that OLE DB Source showing me the below error:
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [DTS.Pipeline]: The LocaleID 127 is not installed on this system.
Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB Source" (1204)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
Could anybody please let me know the solution.
Thanks,
Subba Rao.
April 15, 2009 at 1:40 pm
Hi,
Did you check if the table exists.When you create the connection.There will be a button "TestConnection" to ensure that teh connection is right. I would start from there....
April 16, 2009 at 7:06 am
Hello,
Thanks for the response.
Connection is working well. Table is available. After assigned the table to the OLEDB source or destination, am getting this error.
Thanks,
Subba Rao.
April 16, 2009 at 7:18 am
Check out this link.
Oh and if you get the answer from your post on SQLTeam please post it here as well.
Thanks,
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 17, 2009 at 10:02 am
Did you check the 'LocaleID' in the properties of the Ole DB Source component? Maybe it's defaulting to something that you have not installed or that has become corrupt in some way?
wallythep
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply