GustavoLira
Programmer
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.
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.