April 14, 2011 at 10:05 pm
I'm having a problem,
I have to bring Excel data to SSIS 2005, but has text fields in the spreadsheet that reach 22475 characters but when put in SSIS the field is as follows:
DataType: Unicode string [DT_WSTR]
Length: 255
I've tried to force conversion in the Advanced Editor for text stream [DT_TEXT] and Unicode text stream [DT_NTEXT] but returns error because I can change in OLE DB Source Output both the External Columns and Output Columns, but in OLE DB Source Error Output I don’t change, when I try it return an error message saying: “Property value is not valid”.
And if you change only in OLE DB Source Output returns the following error:
“Validation error: OLE DB Source [3262]: The output column "Nome_da_Coluna" (3297) on the error output has properties that do not match the properties of its corresponding data source column.”
Another way I thought is that as the data is in Excel, SQL syntax I use to bring data to the SSIS is the same as Access, so I searched the intenet a function of Access to convert text fields to memo, but also not found.
As you noticed I'm using the OLE DB connection to Source, because the spreadsheet is in Excel 2007 and SSIS version is 2005, then it's impossible to connect using Excel source, I do not know if this can have some influence.
Does anyone have any idea how to fix this?
I appreciate everyone's attention.
April 15, 2011 at 2:18 am
Maybe this thread can help you:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 15, 2011 at 9:49 am
Is not resolving.
I am using Excel 2007 (xlsx).
I have to change the "DisabledExtensions" of "! xls" to "! xlsx"?
Or Excel 2007 has some other file that I have to change?
April 18, 2011 at 1:25 am
Since you are using excel 2007, did you modify the properties of the JET provider or of the ACE provider in the registry?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply