:-):-)

You are fine

You are helping

:-):-)

I used following statements and it worked fine

ALTER TABLE Test_Table ALTER COLUMN Test_Column varchar(200)

ALTER TABLE Test_Table ALTER COLUMN Test_Column int

But I am looking for one statement not two

Thanks

My SSIS package has a Months column with 2 digit values but my table has Months column in Date datatype I want to convert

Is there no straight forward answer?

why we have to change to varchar then to INT?