yes its just going from 1 column in flat file to 1 column in a table just with the new fix up data.

so say its security name in the flat...

sorry should have stated that but yes you have it spot on it reads in a flat file then i clean it up and into a db table

im new to ssis so i dont really know how i can do this, so looking for advice help to do this

im new to ssis so i dont really know how i can do this, so looking for advice help to do this

no im having a shocking day. when i saw your first post i felt like an idot now i did it twice i might as well give up.

Thanks again

can anyone see anything wrong with this

(FINDSTRING(UPPER(AttributeNames),"Future Notional",1) > 0) && ((TRIM(INV_SECTYPE_COD) == "75"))

o my god i cant believe i didnt sopt that

thanks

no not really just connected to to the database. that seems find as it runs other stuff before it hits this and that all creates and loads data as expected

there was 2 more things on it below i here they are

[Attributtes Table [85]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (98)" failed because error...

i thought so i just wanted to make sure

im getting this error and i have no idea why

[Attributtes Table [85]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error...

well i way trying to use a dervied column

this was the code i was trying

(TRIM(INV_SECTYPE_COD) == "75") && (TRIM(AttributeNames) == "")?[(SHARS/MULTIPLIER) * (MKT_PRC_BASE) *(MULTIPLIER/100)]-[UNREALIZED_APP_DEP_BASE]: Notional AMount

but there is errors...

well the whole logic is this

Change the calculation of the Notional Amount for Future securities for all funds

a) If INV_SECTYPE_COD equal to ’70’, ‘71’, ‘72’, ‘73’, ‘74’, or ‘75’

i. NotionalAmount...

ya i dont think i can use identity for now anyway. its not working the way i want it to and i have tried it. it was my first idea...

i want to add data to a table and have the number in the sectionnumber part to increment by one every time it finds new data.

the code i used for...

where would i put it in the first slect

SET @MAXVALUE =

(

SELECT MAX(sectionnumber)+1,

FROM dbo.BNYWorkingSecTable

)