SSIS Term Lookup

[silensvir]

I'm new to SSIS, but I've spent a few hours reading and trying to get this working before I'm posting here.
I'm trying to get a simple instance of a Term Lookup that is fed from a Flat File Source to read correctly.

I was following this guide:

http://netindonesia.net/blogs/kasim...ct-Particular-Word_2F00_Phrase-with-SSIS.aspx

I am getting this error and can't seem to figure out what's wrong:

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Data Flow Task [Term Lookup [110]]: The reference column can only have DT_STR or DT_WSTR as its data type.

Error at Data Flow Task [SSIS.Pipeline]: "component "Term Lookup" (110)" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------




Any help would be GREATLY appreciated.

 

[may333]

Probably you have missed to change the data type of column from "string [DT_STR]" to "Unicode string [DT_WSTR]" when you have created Flat file connection.

 

[silensvir]

I do have that set as DT_WSTR and that's the message it returns.


When I set it to DT_STR, it returns:
Error at Data Flow Task [Term Lookup [110]]: The input column mapped to a reference column can only have DT_NTXT or DT_WSTR as its data type.

Error at Data Flow Task [SSIS.Pipeline]: "component "Term Lookup" (110)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".




When I set it DT_NTXT, it returns:
Error at Data Flow Task [Term Lookup [110]]: The reference column can only have DT_STR or DT_WSTR as its data type.

Error at Data Flow Task [SSIS.Pipeline]: "component "Term Lookup" (110)" failed validation and returned validation status "VS_ISBROKEN".

 

[silensvir]

it looks like it's telling me that the column in the table that i'm using to store the lookup word is in the wrong format but i've tried every data type i can think of: varchar, text, nvarchar, ntext.

 

[silensvir]

apparently it wasn't the column data type that was the problem, it was the length which i had set to (max). ssis apparently doesn't like "max".
thanks for the help.