no i have not , new to SSIS , would be gr8 if you explain me how its is done

i am pulling the date column from flat file which is in yyyy-dd-mm format , which i need to convert to yyyy/dd/mm

well you can include the columns as they are from the source and use a data conversion transformation down the road ......

regards

greg

well totally agree to steve .... it seams to be the best best

regards

greg

yeh i do have an OLEDB command.... well any ways its fixed ..... it was causing troubles because of the business key that was assigned to the columns that was...

can you be a little more specific .... because its heard to figure

yeh there is no date clolumn

and the type of attribute i am using is CHANGING attribute

works great thanks

regards

greg

yes they are the same

i did but now its throwing the arithematic over flow error

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type datetime.

after i replaced the...

yeh i do know what they are

ok WILL DO

thanks

regards

greg

can you tell me how i can use parameters for the where clause in the following query

thanks

regards

greg

so its going to be

create proc myproc

as

(the same select statement that i have posted )

go

is that it ?