Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GustavoLira
Starting Member
1 Post |
 Posted - 2011-04-15 : 00:54:53
|
| 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: 255I'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. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-04-18 : 19:20:34
|
| Nome_da_Coluna is what data type? are all fields text or numeric? try it with length max for starters and see what happens.If you don't have the passion to help people, you have no passion |
 |
|
|
Dimka
Starting Member
1 Post |
Posted - 2011-05-04 : 16:45:41
|
| I have same problem. Have you solved this problem? |
|
|
|
|
|
|
SSIS - text field with many characters