Share via

When following SSIS Tutorial on microsoft learn I receive a data type error

Adam 0 Reputation points
2024-07-31T10:19:36.55+00:00

I have following the Microsoft Learn SSIS tutorial and am currently on https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16 , trying to follow the below step:

User's image

My issue is the advice in yellow doesn't solve the following error:

User's image

I will put some screengrabs below just to show I have the correct settings as per the tutorial up to this point:

User's image

(LocaleID and DefaultCodePage match for data types.)

Below confirmed data types are correct for source and destination:

User's image

User's image

User's image

User's image

I really don't understand it. I have followed every step (starting from here) and it doesn't work as the docs suggest it does.

SQL Server Integration Services
SQL Server | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,541 Reputation points
    2024-08-01T03:05:10.5666667+00:00

    Hi @Adam,

    Please go to advance editor for flat file source and check the Output column to make sure the Datatype is correct.

    User's image

    User's image

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.