sorry misunderstood.....it´s fine and works! thanks for you this....

thanks for this!

where in the flow do i insert this command:

(DT_WSTR,4)YEAR(GETDATE())

RIGHT(”00? + (DT_WSTR,2)MONTH(getdate()),2)

RIGHT(”00? + (DT_WSTR,2)DAY(getdate()),2)

....sorry i´m newbie to sql!

i´m experiencing the same problem with derived columns.

The Source Column has larg Text and is of Data Type "four-byte signed integer [DT_I4]". Then when i try the RAPLACE like =...

WOW what a shame on SQL 64bit! then back to 32bit....

If you get an Resolution from MS, you are wolcome to inform us !!

thx.

Ok the reason for this problem suprised me really, x64 SQL Integration Services is just unable to import a small csv flat file - on ther contrary x32 SQL IS...

Hi,

thanks for answers, here comes the source data as a sample.

The Field Delimeter is set to = Row Delimeter ({CR}{LF}), Column Delimeter (Semicolon {;})

"Name";"Date";"Month";"Year";"Client";"Project";"In";"Out";"Description"

"Mc-Taylor, Tom";"9.1.2006";"Jan06";"2006";"Company-West";"Testing";"8,5";"2,75";"Testing the Source Environment"

"Ruiz-Garcia, John";"12.1.2006";"Jan06";"2006";"Company-West";"Testing";"8,0";"4,75";"Testing the...