Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SSIS Term Lookup
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.- silensvir
- Post #5
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS Term Lookup
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
- Post #4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS Term Lookup
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]...- silensvir
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS Term Lookup
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...- silensvir
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
