SQL 2005 - SSIS
Hi All,
I have a SSIS package that is suppposed to copy a few views and stored procedures from one SQL 2005 server to another SQL 2005.
I run the package, no errors appear, but the items are not copied at all. In the process information it states 0% objects transfered, but no errors mentioned.
If I choose the option to drop if object exists, then if there is an object, I do get the error that there is an object and the package fails. Then, if I go and manually drop the object, and re-run the package, I get the same as mentioned further up, it gives no errors, but no objects are copied.
I know this is vague, but maybe I am missing something really obvious?
Any info will be appreacited.
Michael
Hi All,
I have a SSIS package that is suppposed to copy a few views and stored procedures from one SQL 2005 server to another SQL 2005.
I run the package, no errors appear, but the items are not copied at all. In the process information it states 0% objects transfered, but no errors mentioned.
If I choose the option to drop if object exists, then if there is an object, I do get the error that there is an object and the package fails. Then, if I go and manually drop the object, and re-run the package, I get the same as mentioned further up, it gives no errors, but no objects are copied.
I know this is vague, but maybe I am missing something really obvious?
Any info will be appreacited.
Michael