The script component is used to redirect the rows to another table. The problem with changing the datatype on a column is it will have a cascading effect and will...

Thanks for the prompt response.

I'm converting it to DT_DBTIMESTAMP.

I used a script component to get it to work, but just wanted to find out if there was some workaround.

--P

Had the same issue. Stopping the SQL Server Reporting Services worked for me.