I didn't want to deal with any truncation issues so I edited the SQL created by the Import Wizard. I made the fields VARCHAR instead of NVARCHAR and changed the size from the default 50 to 250.
Now I have a triangle warning on the OLE DB Destination control. So I am wondering, is it limited to only handling 50 characters?
IanO
What's the warning? You can see it by hovering your mouse over it.
The OLEDB destination will work with fields much larger than 50 characters.
|||Ian,
You need to recreate the destination because it still thinks the incoming metadata for those fields is 50 bytes. Just delete the OLE destination and add a new one. Should be pretty simple for ya. Or, (I can't remember now) if there is an advanced editor for the OLE destination (in the properties pane) you can go there and edit the data types. Make sure that all components have the correct metadata (sorts, derived columns, etc...) as well.
No comments:
Post a Comment