December 12, 2008 at 2:17 am
Hi,
I created a SSIS for transferring sql objects but it doesn't work. I check the progress log and found that the transferring progress is always 0 percent complete without any error.
The SSIS is try to transfer all objects in the source database (Test_Sync_Stag) to the destination database (Test_Sync_Prod) includes tables, store procedures and so on. At least after executing this SSIS the destination database (Test_Sync_Prod) should have 2 tables as well as the source database (Test_Sync_Stag). But it's always one table there.
I made some screen shot of this project.
Transfer object task parameters
Source and destination databases
Could anyone please help me to identify the problem? Thanks~
December 12, 2008 at 7:20 am
If you do a refresh on the destination database in SSMS does the missing table appear? SSMS does not dynamically refresh when you add tables using script or an SSIS package.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 12, 2008 at 5:08 pm
Hi Jack,
I do refresh the tables all the time and the problem still there. I think the problem is caused by the SSIS package is always 0 percent complete but I don't know the reason of this.
Wayne
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply