Data Mining Part 38: Text Mining - The term lookup

Question

Post reply

Data Mining Part 38: Text Mining - The term lookup

Daniel Calbimonte

SSCertifiable

Points: 6200
More actions
April 27, 2016 at 12:02 am

#316087

Comments posted to this topic are about the item Data Mining Part 38: Text Mining - The term lookup

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

akljfhnlaflkj

SSC Guru

Points: 76202

April 27, 2016 at 6:26 am

#1874903

Another good piece in the series, thanks.

maroon-78 Ten Centuries Points: 1014 More actions · Answer 2

so I am getting an error:

An error occurred while setting up a binding for the "text" column. The binding status was "DT_NTEXT".

any suggestions?

I am on Windows 7 Pro, Sql Server 2014 Express, and using Visual Studio 2013 with SSIS Designer version 12.0.2430.0

Daniel Calbimonte SSCertifiable Points: 6200 More actions · Answer 3

The problem is the data type. Are you using my sample tables?

maroon-78 Ten Centuries Points: 1014 More actions · Answer 4

I used the script at the bottom of the article. There was no terms table in the script so I used the test in the article. The only change I made was the terms column is nvarchar(10). Your article has it as nchar(10) which didn't seem correct.