I need to copy certain db Tables from one RMS db to another. I used to do the with SQL 2000 (use to be called DTS [data transformation]) and can still do with full-blown SQL 2005 or SQL 2008. But this functionality doesn't seem to be available with SQL 2005 Express. Is there a way to do data transformation (integration services) with SQL 2005 Express? How can I copy certain Tables from one RMS db to another? Thanks!
-Allen