Hi All, I'm extracting data from an Oracle DB to create a flat file for loading into a new DB. I'm using a SQL statement in the OLE DB source, then applying lookup's, etc to massage the data into the format I require. I've defined a select statement with say select A from table_B where, etc... I now need to change this to select function(X) from table_B where.... this changes the length of the first column to 2000 chars, but my initial column length was 5 characters. The following scripts and lookups already have this column defined as 5 chars, and therefore fail. How do I easily change the following items in my flow to cater for the larger length? SSIS seems to hang onto the original column length and wont let me change it.

I've had this issue before. Unfortunately I cannot tell you what the formal answer is, but what I've normally done is to delete my OLE DB Source and add a new one with the new query. when you then connect the new source to the existing transformations, they will see the old column as deleted. when you reapir the following transformations, they should adjust to the new size. HTHCraig Bryden - Please mark correct answers

Thanks - I've found I've had to do this with a few different items (eg, flat file destinations to re-order fields, etc).