SSIS: Copy entire schema to another schema within same DB -
10-30-2006
, 04:01 PM
We have an application that is copying an entire schema (ie, bob) to another
one (ie. frank) within the same DB. Currently, this is done via client
software, but it is naturally very slow because of the bandwidth required. I
cannot determine a method to perform this task, via an SSIS process, running
entirely on the server, that would do this. Is is possible? |