July 15, 2014 at 10:32 am
i have a ssis package imports msaccess data to sql. i am getting an error as below. I checked the year datatype
in access. It shows text datatype and in sql it is in float. I am new to ssis. How to overcome this error
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [Lookup [1552]]: input column "Year" (1615) has a datatype which cannot be joined on.
Error at Data Flow Task [DTS.Pipeline]: "component "Lookup" (1552)" 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)
------------------------------
BUTTONS:
OK
------------------------------
July 15, 2014 at 10:39 am
You need to convert the year column being brought in from access from text to string. Text is a binary type, not a string type.
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
July 15, 2014 at 10:50 am
Jack,
I tried but gets the same error. Can you be specific?
July 15, 2014 at 11:59 am
It's been awhile since I've used a lookup transform, but is sounds like you need to have the data types match on the join columns. So either have them both be numeric or string. I'd lean toward putting a CONVERT() in the query in the Lookup to convert that value to string to match the incoming data.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply