hi all, i am using data conversion transformation source of which is from one database using OLEDB SOURCE and the output goes to another database table using OLEDB DESTINATION. In OLEDB DESTINATION i want to use sql command instead of Table or View as Data access mode. The sql command would be written as INSERT destinatio table SELECT columns from SOURCE. Can we do this?? The reason i am trying to do this is because i want to add make modifications in one of the column values using the SQL command

If you are selecting SQL Command in Ole DB Destination then command will be like SELECT column names from destination_table_name then map in mapping tab Shailesh, Please mark the post as answered if it answers your question.

>>>Can we do this?? I do not think so. Import all data into SQL Server and make modifications there or perhaps add conversion control (make modif. here) before inserting into a destinationBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

If you are selecting SQL Command in Ole DB Destination then command will be like SELECT column names from destination_table_name then map in mapping tab Shailesh, Please mark the post as answered if it answers your question.