Hi,
I am trying to copy the data and tables from My server(SqlServer2000) to another Server(MSDE2000A) using DTS, after some time i am getting an Error " the login PDD Doc handler doesnot exist" failed to copy the data. How to fix this, appreciate your help
Thank You
Hello,
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server "
I keep getting this when trying to copy stored procs from one db to another on the same server. I am using the DTS wizard. I have been able to copy the tables but I need the sp's too, and there are too many to copy one at a time.
Help!
TIA,
Bruce
it took 1h 30 min as usual to execute. But this job failed. any ideas.
-----------------------------------------------------------------------
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Logins; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Users; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 25 Percent Completed; PercentComplete = 25; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 13 Percent Completed; PercentComplete = 13; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 35 Percent Completed; PercentComplete = 35; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 13 Percent Completed; PercentComplete = 13; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 1 Percent Completed; PercentComplete = 1; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 3 Percent Completed; PercentComplete = 3; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 5 Percent Completed; PercentComplete = 5; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 7 Percent Completed; PercentComplete = 7; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 5 Percent Completed; PercentComplete = 5; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 50 Percent Completed; PercentComplete = 50; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Rules; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Rules : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Defaults; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Defaults : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting User defined datatypes; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 25 Percent Completed; PercentComplete = 25; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 27 Percent Completed; PercentComplete = 27; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 31 Percent Completed; PercentComplete = 31; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 33 Percent Completed; PercentComplete = 33; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 36 Percent Completed; PercentComplete = 36; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 37 Percent Completed; PercentComplete = 37; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 39 Percent Completed; PercentComplete = 39; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 41 Percent Completed; PercentComplete = 41; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 42 Percent Completed; PercentComplete = 42; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 44 Percent Completed; PercentComplete = 44; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 45 Percent Completed; PercentComplete = 45; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 47 Percent Completed; PercentComplete = 47; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 48 Percent Completed; PercentComplete = 48; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 50 Percent Completed; PercentComplete = 50; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 36 Percent Completed; PercentComplete = 36; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 51 Percent Completed; PercentComplete = 51; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 38 Percent Completed; PercentComplete = 38; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 53 Percent Completed; PercentComplete = 53; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 40 Percent Completed; PercentComplete = 40; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 55 Percent Completed; PercentComplete = 55; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 42 Percent Completed; PercentComplete = 42; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 56 Percent Completed; PercentComplete = 56; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 44 Percent Completed; PercentComplete = 44; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 58 Percent Completed; PercentComplete = 58; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 46 Percent Completed; PercentComplete = 46; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 59 Percent Completed; PercentComplete = 59; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 48 Percent Completed; PercentComplete = 48; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 61 Percent Completed; PercentComplete = 61; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 51 Percent Completed; PercentComplete = 51; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 62 Percent Completed; PercentComplete = 62; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 53 Percent Completed; PercentComplete = 53; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 64 Percent Completed; PercentComplete = 64; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 55 Percent Completed; PercentComplete = 55; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 57 Percent Completed; PercentComplete = 57; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 67 Percent Completed; PercentComplete = 67; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 59 Percent Completed; PercentComplete = 59; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 68 Percent Completed; PercentComplete = 68; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 61 Percent Completed; PercentComplete = 61; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 70 Percent Completed; PercentComplete = 70; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 63 Percent Completed; PercentComplete = 63; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 72 Percent Completed; PercentComplete = 72; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 73 Percent Completed; PercentComplete = 73; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 67 Percent Completed; PercentComplete = 67; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 75 Percent Completed; PercentComplete = 75; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 69 Percent Completed; PercentComplete = 69; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 76 Percent Completed; PercentComplete = 76; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 71 Percent Completed; PercentComplete = 71; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 78 Percent Completed; PercentComplete = 78; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 73 Percent Completed; PercentComplete = 73; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 79 Percent Completed; PercentComplete = 79; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 75 Percent Completed; PercentComplete = 75; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 81 Percent Completed; PercentComplete = 81; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 77 Percent Completed; PercentComplete = 77; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 82 Percent Completed; PercentComplete = 82; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 79 Percent Completed; PercentComplete = 79; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 84 Percent Completed; PercentComplete = 84; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 81 Percent Completed; PercentComplete = 81; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 86 Percent Completed; PercentComplete = 86; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 83 Percent Completed; PercentComplete = 83; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 87 Percent Completed; PercentComplete = 87; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 85 Percent Completed; PercentComplete = 85; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 89 Percent Completed; PercentComplete = 89; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 87 Percent Completed; PercentComplete = 87; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 90 Percent Completed; PercentComplete = 90; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 89 Percent Completed; PercentComplete = 89; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 92 Percent Completed; PercentComplete = 92; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 91 Percent Completed; PercentComplete = 91; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 93 Percent Completed; PercentComplete = 93; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 93 Percent Completed; PercentComplete = 93; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 95 Percent Completed; PercentComplete = 95; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 95 Percent Completed; PercentComplete = 95; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 96 Percent Completed; PercentComplete = 96; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 97 Percent Completed; PercentComplete = 97; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 98 Percent Completed; PercentComplete = 98; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Views; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Views : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Stored Procedures; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Stored Procedures : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting User Defined Functions; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting User Defined Functions : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Beginning Transfer of Data; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Beginning Transfer of Data : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLWORK]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLWORK]') : 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLYRPD]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLYRPD]') : 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 1 Percent Completed; PercentComplete = 1; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CMPANY]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CMPANY]') : 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CURCNV]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CURCNV]') : 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSADS]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSADS]') : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 3 Percent Completed; PercentComplete = 3; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCLS]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCLS]') : 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCNT]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCNT]') : 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSMST]') : 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 5 Percent Completed; PercentComplete = 5; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0101]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0101]') : 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0311]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0311]') : 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP05]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP05]') : 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 7 Percent Completed; PercentComplete = 7; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP50]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP50]') : 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDS35]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDS35]') : 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOBCOD]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOBCOD]') : 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 9 Percent Completed; PercentComplete = 9; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR02]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR02]') : 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR08]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR08]') : 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR09]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR09]') : 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 11 Percent Completed; PercentComplete = 11; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR10]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR10]') : 36 Percent Completed; PercentComplete = 36; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR05]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR05]') : 38 Percent Completed; PercentComplete = 38; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR106]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR106]') : 40 Percent Completed; PercentComplete = 40; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 13 Percent Completed; PercentComplete = 13; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR46]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR46]') : 42 Percent Completed; PercentComplete = 42; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR56]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR56]') : 44 Percent Completed; PercentComplete = 44; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR57]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR57]') : 46 Percent Completed; PercentComplete = 46; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 15 Percent Completed; PercentComplete = 15; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR63]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR63]') : 48 Percent Completed; PercentComplete = 48; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRA01]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRA01]') : 51 Percent Completed; PercentComplete = 51; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 17 Percent Completed; PercentComplete = 17; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRM10]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRM10]') : 53 Percent Completed; PercentComplete = 53; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA05]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA05]') : 55 Percent Completed; PercentComplete = 55; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA06]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA06]') : 57 Percent Completed; PercentComplete = 57; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 19 Percent Completed; PercentComplete = 19; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA32]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA32]') : 59 Percent Completed; PercentComplete = 59; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVDET]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVDET]') : 61 Percent Completed; PercentComplete = 61; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVHDR]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVHDR]') : 63 Percent Completed; PercentComplete = 63; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 21 Percent Completed; PercentComplete = 21; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVMST]') : 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[LSTKEYV99]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[LSTKEYV99]') : 67 Percent Completed; PercentComplete = 67; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[MRKPRD]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[MRKPRD]') : 69 Percent Completed; PercentComplete = 69; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 23 Percent Completed; PercentComplete = 23; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[NOTES]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[NOTES]') : 71 Percent Completed; PercentComplete = 71; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDDET]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDDET]') : 73 Percent Completed; PercentComplete = 73; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDMST]') : 75 Percent Completed; PercentComplete = 75; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 25 Percent Completed; PercentComplete = 25; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCDETV99]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCDETV99]') : 77 Percent Completed; PercentComplete = 77; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCSUM]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCSUM]') : 79 Percent Completed; PercentComplete = 79; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESMST]') : 81 Percent Completed; PercentComplete = 81; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 27 Percent Completed; PercentComplete = 27; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESUBC]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESUBC]') : 83 Percent Completed; PercentComplete = 83; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SHPHST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SHPHST]') : 85 Percent Completed; PercentComplete = 85; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSGRP]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSGRP]') : 87 Percent Completed; PercentComplete = 87; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 29 Percent Completed; PercentComplete = 29; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSREP]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSREP]') : 89 Percent Completed; PercentComplete = 89; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SYSWHS]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SYSWHS]') : 91 Percent Completed; PercentComplete = 91; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TALFLI]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TALFLI]') : 93 Percent Completed; PercentComplete = 93; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 31 Percent Completed; PercentComplete = 31; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TERMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TERMST]') : 95 Percent Completed; PercentComplete = 95; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[UMCONV]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[UMCONV]') : 97 Percent Completed; PercentComplete = 97; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[WHREGN]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[WHREGN]') : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147199225 (80045707)
Error string: [SQL-DMO]The Bulk Copy execution failed.
Error source: Microsoft SQL-DMO
Help file: SQLDMO80.hlp
Help context: 1131
Error Detail Records:
Error: 0 (0); Provider Error: 0 (0)
Error string: [SQL-DMO]The Bulk Copy execution failed.
Error source: Microsoft SQL-DMO
Help file: SQLDMO80.hlp
Help context: 1131
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun: Package execution complete.
=============================
http://www.sqlserverstudy.com
I'm trying to start a new publication. When the snapshot agent runs, it stops on a table with the error "Bulk Copy Failed". If I remove the table from the publication, it just moves the error to the next table it tries to copy. What could cause a bulk copy to fail during a snapshot?
View 4 Replies View RelatedHello,
I'm trying to migrate a SQL 2000 database to SQL 2005. I'm using the Copy Database Wizard and can copy the database using the detach and attach method, but I would rather use the SQL Management Object method. I get the following error when trying to use this method:
Package "ShellPackage" failed.
This error occurs directly after the following step:
Event Name: OnInformation
Message: Transferring data to database RestoreTest from RestoreTest
Operator: <WANfirst.lastname>
Source Name: BP-BLM-TESTSQL2_BLM-JCAMPVSSQL2_Transfer Objects Task
Source ID: {E6765B9E-1B40-49ED-B0CE-F99252AA34B6}
Execution ID: {213272C4-37E9-4A1E-A5B9-A2F9A61348B3}
Start Time: 12/20/2005 3:05:58 PM
End Time: 12/20/2005 3:05:58 PM
Data Code: 0
The database is created successfully but the data is not transfered. Also, the logins are created on the new server successfully. Has anyone seen this error or have any ideas on how to solve this problem? I would greatly appreciate any help!
Thanks,
Joseph
Hello,
I connect from SQL Server on Windows 2000 to Progress
Database on UNIX.
The database name of SQL Server is cstarsql and the
name is cstarint on UNIX.
I would like to schedule to copy data from
cstarint(Progress) to cstarsql(SQLServer). I did for
one time, but I want to control if the data has
already copied or not. If not, it will copy.
In DTS Query Builder to copy from Progress to SQL
Server,
SELECT * from calls WHERE call_date = TODAY
The name of table of calls is the same for both
database.The above calls is cstarint(Progress
Database)
This command is enough for one time. But I need to
control if the record has already copied.
In SQL Server, I control if the record is available or
not with @@FETCH_STATUS .
Now I would like to mix two queries, but I couldn't.
Can anybody do this?
DECLARE calls_cursor SCROLL CURSOR
FOR SELECT * FROM calls
WHERE call_date = TODAY
OPEN calls_cursor
-- Perform the first fetch.
FETCH NEXT FROM calls_cursor
-- Check @@FETCH_STATUS to see if there are any more
rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This is executed as long as the previous fetch
succeeds.
FETCH NEXT FROM calls_cursor
END
CLOSE calls_cursor
DEALLOCATE calls_cursor
Alice
When a user deletes a row from table "A", I would like to copy that row to table "B", so I can restore it if I need to.
TIA
Hello,
I have a sql database server (let call it server A) which has SQL program files installed on C:, and SQL data structures MSSQL (include subdirectories BAckup, DATA, FTDAT, JOBS, LOG, REPLDATA) on F:. A new server (call it server B) was cloned of server A but only at the C: partition. I still need to manually copy the SQL data structure on F: drive from A to B. The purpose of setting up server B is to test the restore of backup of server A and eventually want it to serve as the standby server should server A crashes. My questions are
1. Can MSSQL directory be copied from A to B without stopping the SQL server service on A first?
2. I will use robocopy for copying data over, what switches should I use to retain all database file security, permission, etc..
3. Currently I can not start the SQL service on server B because part of MSSQL directory is missing from the F: drive. so theorically, after I manually copy that folder over, I should be able to start the sql service. Am I right? Is there any steps that I might have overlook here. Any errors I might encounter doing it this way
Once I can get the sql started, I can take care of the restore part.
Thanks for any insights or suggestions you can provide on this.
Hello
I'm developing an application that need to create everyday information to be stored in a SQL Mobile Database.
The SQL Mobile database will have:
Last schema from tables (in SQL Server database);
Last information in the tables;
I don't want to copy all the tables from SQL Server database than this mecanism should give me the way to choose the tables.
I have been reading about the SqlCeReplication but I don't undestand what is InternetUrl property. The SQL Mobile database is created in the PC and after is copy to the the Mobile Device.
How can I avoid the InternetURL property?
tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal
Hi,
I am facing a great problem. I have a DB about 80GB. There are 217489811 number of records which include 2005, 2006 and 2007 data in 1 table. Now I want to split the table into by quarter tables 2005Q1, 2005Q2.....etc. It is because it is easier for me to housekeep the old data. (It takes about few hours to housekeep 3 month data currently, so that it affect my server performance a lot)
so I start my work, however it is failed every times. Actually, if I copy 3 month data to a new tables, it is nearly about 30 million records which needs about 1 GB space. However, it takes about 8 hours to complete the job and failed because of not enough space allocated. Actually, my Server has about 50GB space, but when the job complete and fail, all the space is occupied. But i wonder why this happen because the data only need about 1 GB, how come it use 50GB?
it seems that nothing i can do to housekeep the old data. because housekeep the current table takes too long time while splitting tables use up all the space. So how can i do?
For your information, the table has non-clustered index on the data date field
need your help
thanks,
Linus
I'm a web developer who writes transact-SQL to make my web applications run properly. I'm not real strong in other areas of SQL. Let me explain our set-up and then I'll explain what I want to do:
We have an ecommerce web site and all sales are saved in a SQL Server 2008 R2 database at our hosting company. We also have a local Windows 2012 network that has SQL Server 2014 Express installed.
Here is what I want to do:
I want to copy sales rows from the SQL Server 2008 database at our hosting company and save them in the SQL Server 2014 Express database on our local Windows 2012 server. I'd like to automate this if possible so that it happens each night perhaps. I know there is a way to schedule SQL jobs but I've never actually done this. I also would need to know how to attach to our hosting company DB as well as our local network DB.
Greetings,
I have two SQL Server tables on the same server and in the same database. I'll call them table A and table B. They have identical schemas. I need to insert all rows in table A into table B. (Don't laugh - this is just for testing and long run the tables will reside on different servers.)
Can someone please tell me the correct task to use for this and the connection type I need for both the source and destination?
Thanks,
Black Cat Bone
Copy objects and data between SQL Server databases
"
Display the Select Objects to Transfer dialog box, where you can specify both objects and data to copy, if both the data source and destination are Microsoft® SQL Server™ databases. The objects you can transfer include tables, views, stored procedures, defaults, rules, constraints, user-defined data types, logins, users, roles, and indexes. You can transfer objects only between multiple instances of SQL Server version 7.0, from an instance of SQL Server 7.0 to an instance of SQL Server 2000, and between multiple instances of SQL Server 2000.
"
can I apply "Copy objects and data between SQL Server databases"
to run in two different sqlserver 2000 ( not an instance ) . what I mean is I have two different sql servers located in two different locations( I am not using an instance installation) can I still run the copy and get an identical database in both servers.
Q2. if I have two sql server 2000 with different collations (one is binary and the other is the default) will I be able to run the copy wizard and still have an identical copy of sql server in both servers.
I personally tried to run the copy wizard and IT NEVER WORKED FOR ME and I really do not know the reason.
Thanks for your input.
ali
I am an authenticated user of a remote data base
I can log in and add tables and even I can back up the database .
Good.
But I want to get a copy of the database to my local computer
Is there any way to do this?
_sujithsql_
Ok, here is my dilemma
I have an application that has many sites. Each site has it's own database. The databases have common tables (ie the name and fields are the same) What I want to be able to do is when creating a new database, I want to be able to copy certain common table data from one database to another. I have run into an error because the table have an IDENTITY so this is not working
INSERT INTO Containers SELECT * FROM ADMS2_Indian_Point.dbo.Containers
I also tried
USE ADMS2_RSCS
GO
SET IDENTITY_INSERT Containers ON
GO
INSERT INTO Containers SELECT * FROM ADMS2_Indian_Point.dbo.Containers
GO
SET IDENTITY_INSERT Containers OFF
GO
I got an error saying that I need to have a column list. I am trying to use this for any tables, so my question is this..
Is there any way to get around using a column list or is there a way to dynamically create the column list?
Or, Is there a better way that I should be doing this?
Please keep in mind I am not a dba and everything I have learned about SQL is from my good pal Google :)
Thanks for any help
Is there a way to use SSIS to copy data from a SQLServer CE database to a SQL Server 2005 database?
I have a database that has only been used on a mobile device, but now I want to use it among several devices, so I want to copy the structure and data to a SQL Server 2005 database and expand it's scope.
I am trying to copy/update a table which is in server2 based on a similar table which is in server 1. I can't use replication,
so I am thinking which are the best ways to do without affecting the performance as the source table is busy with inserts or updates. I am thinking of following options:
1. SQL server 2000 DTS packages: As I am trying to copy the data from the source table(server1) into a destination table which is a similar table in server2, if I use dts first I want to take the complete snapshot and then on I only want to copy the new transactions or updated transactions, please let me know how I can do this.
2. Does trigger affect the performance as the server1(source table) is a busy server.
Please let me know. Thanks.
Hi there,
Can u please tell me how to copy data from table A(database A) to table B(databaseB) which table A contain 10 fields but table B consist of 11 fields. I have to insert current date and time into another field in Table B (which has extra field compare to tableA) automatically every hour or so.
Please help.
Thanx
how to copy a content of a table from one remote server to another,. server A does not see server B (B doesn't see A) - I cannot even ping to one from another.I do have SQL Studio installed on server C, which IT team configured to allow access to both A and B.So what I did so far is to periodically:
1. connect from the studio on server C to server A
2. run the following script on server A: SELECT * FROM A.myTable FOR XML PATH('ROOT')
3. copy the result
4. connect from the studio on server C to server B
5. to write something like
DECLARE @xmlData XML;
SET @xmlData = pasting here my result from item 3 above
6. INSERT INTO
SELECT
ref.value .....
FROM @xmlData.nodes('/myElemnet/ROOT')
xmlData( ref );
so it works. now there is a requirement to schedule this update to run periodically and I need to implement it..
Hi... Please help. I am having problem with my hard drive so I git a new one. I installed a new instance of SQL Server 2005 and copy over all my projects from the old hard drive into the new.
The problem is, when I open my packages specifically the data flow task it is empty. All my dataflow items are gone.
I am not sure what I am missing during the copy. Please help how I can recover my complete packages.
Thanks a lot!
Concon
I notice when I copy an SSIS package 'A' to a new package 'B', the new package 'B' will generate a "login failed for user" message in the data flow components. To copy I "save copy of Package 'A' as."
Some config info:
Package ProtectionLevel = EncryptSensitiveWithPassword
Connections are Data Sources
Connection strings with password are stored using PackageConfigurations to an SQLServer table. I've verified Package 'A' is in fact using the config table (e.g. it is not using a password or user stored in the package)
Data connectios are all SQLServer Native OLE DB Client
The account is an SQLServer account (not integrated security)
The original Package 'A' works flawlessly and I get success when I test the connections in Package 'B'.
But executing package 'B' I get: The error message I get is: [Connection manager "MyConnection"] Error: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'dwuser'.".
Does anyone know why this would occur and/or how to work around it? I saw another thread where a potential workaround is to create a new data flow task and copy all the data flow components to that task. That won't work well for us because the data flow is moderately complex and when you copy and paste it, SSIS completely re-orders the layout.
This is a typical data warehouse ETL setup where there is a master package that executes child packages (e.g. 'A', and 'B' mentioned above) that each perform the ETL for a specific dimension or fact table.
Thanks for any help,
Lee Cascio
Friends
Any one of you share your knowledge how to transfer data from a database to a excel using dts packages in sqlserver 2000.
I want clear steps how to create a dts package
Appreciate your help
Thanks
satish
I want to be able to reproduce my production execution plans on development with copying data.
[Source - chn_employee_vew_test_txt [1]] Error: Data conversion failed. The data conversion for column "Column 42" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Source - chn_employee_vew_test_txt [1]] Error: The "output column "Column 42" (136)" failed because truncation occurred, and the truncation row disposition on "output column "Column 42" (136)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
I using Locale (People's Republic of China) and code page of 936 (Simplied Chinese GBK) with header row delimiter {CR}{LF}.
I am using flat file import method.
Whenever the server process the Column 42 with value "11,Nanjing Rd.W, China" which contain 'comma' or '.' it will hit error importing with above message. When i manually change the column value to non comma or '.' (11 Nanjing Rd W China) in the flat file it is ok.
I am using SQL server 2005.
Please advise what need to be done to avoid this error ?
Thanks in advance and any idea or suggestion is very much appreciated as i have try to solve this issue for over a week but still not able to find any answer on it.
Please help.
regards,
kong
[Source - chn_employee_vew_test_txt [1]] Error: Data conversion failed. The data conversion for column "Column 42" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Source - chn_employee_vew_test_txt [1]] Error: The "output column "Column 42" (136)" failed because truncation occurred, and the truncation row disposition on "output column "Column 42" (136)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
I using Locale (People's Republic of China) and code page of 936 (Simplied Chinese GBK) with header row delimiter {CR}{LF}.
I am using flat file import method.
Whenever the server process the Column 42 with value "11,Nanjing Rd.W, China" which contain 'comma' or '.' it will hit error importing with above message. When i manually change the column value to non comma or '.' (11 Nanjing Rd W China) in the flat file it is ok.
I am using SQL server 2005.
Please advise what need to be done to avoid this error ?
Thanks in advance and any idea or suggestion is very much appreciated as i have try to solve this issue for over a week but still not able to find any answer on it.
Please help.
regards,
kong
Hopefully there's an easy answer for this. I'm totally new to SQL server and I'm trying to upsize an Access database. Whether I use the upsizing wizard or try to create a data source through the ODBC Data Source Administrator, I get a connection failed error. It tells me the server does not exist or my login is incorrect. I'm using NT authentication to connect to the server on my local drive. I just installed the whole 2005 express edition and the only thing that came up during the install was that I didn't have IIS installed. I didn't see how that would be relevant, so I went ahead with the install.
Shouldn't this work with the default setup? I've searched around trying different "solutions" although I doubt they were specifically related to this very basic problem. I tried giving my login every right I could find through in the database engine properties in the server management studio, which connects fine itself with just my network login name and no password. What am I missing?
I am doing a Case statement to create a unified field for account type and vendor, in the code below I am receiving the error in the subject, because the account numbers have alpha characters in the string, I need to make them as OTHER if the first 2 left chars are Alpha, I thought how I have ISNUMERIC would do that but I am still getting the error.
I am also including example of how the account_numbers are formatted.
R222209
R222220
R222222
R222212
R221123
F707768
[Code] .....
I have a windows 2008 with SQL Server 2008 R2 VM on Azure. I am trying to connect to the SQL server for the first time using SSMS, but have not been able it. I have a VPN tunnel, so I am connecting using Windows authentication. The error I get back from SSMS is:
Login failed for user 'domainusername'. (Microsoft SQL Server, Error: 18456).In the event viewer I see this error message: Login failed for user 'domainusername'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
I have done the following:
- created an endpoint for port 1433
- opened port 1433 in the firewall
- Ran the MSSQLSERVER service as the build-in users Network Services, Local System, and Local Service, and as a local and domain administrator, with the same exact result each time.
- I get the same result trying to connect locally or remotely.
- I get the same result trying to connect using sqlcmd.
I have lots of problems with the connection. I've connected many dropdownlists to the database and i didn't have problems at all. I also try an example of an ASP.NET book:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString= "<%$ ConnectionStrings:CIPPEC%>"
InsertCommand=
"INSERT INTO
[member] ([first_name], [last_name], [malefemale], [yearborn])
VALUES
(@first_name, @last_name, @malefemale, @yearborn)">
<InsertParameters>
<asp:FormParameter Name="first_name" Type="String"
FormField="FirstTextBox" />
<asp:FormParameter Name="last_name" Type="String"
FormField="LastTextbox"/>
<asp:FormParameter Name="malefemale" Type="Int32"
FormField="MFRadioButton" />
<asp:FormParameter Name="yearborn" Type="Int32"
FormField="YearDropDown" />
</InsertParameters>
</asp:SqlDataSource>
And it worked well. But when i try to connect my page with:
Dim connect As New Data.SqlClient.SqlConnection( _
"Server=glgrand-arSQLEXPRESS;UID="WindowsStartupUser";password="WindowsStartupPass"; database=CIPPEC")
connect.Open()
Dim cmd As New Data.SqlClient.SqlCommand( _
"INSERT PRUEBA (PersonaJuridica, NombreRazonSocial, Nombre, Segundo_nombre, Apellido) " & _
"VALUES (txtPerJur, txtRazSoc, txtName, txtSecondName, txtApellido)", _
connect)
cmd.ExecuteNonQuery()
connect.Close()
The error message says: Login failed for user 'username'.
I tried lots of things but it didn't work:
In SQL Configuration Manager:
Client Protocols: TCP/IP and Named Pipes are enabled.
In SQL 2005 Services: Server Properties: Built-in Account: Local System
SQL Server Surface Area Configuration: Remote connections: Using both TCP/IP and Name Pipes connection is selected.
In SQL Management Studio i created a new login glgrand-ar/UserStartupName , with sysadmin server role and user mapping my CIPPEC database.
I don't know what else i could try, i tried it at home and at work and i couldn't connect to my database and make an INSERT. It stops at Connect.Open() with the error that i wrote in this subject message.
It's evident that i'm doing something wrong (because i'm new): Could you please help me with a solution and explain me what are the data that i have to put on the Data.SqlClient.SqlConnection ?? I'm using the Windows authentication: i'm putting my username and password and it doesn't worked.
Thank you!!
Hello
I have recently downloaded Orcas beta VS product and had no previous version of VS before. The install went clean and I have been able to generate Window apps and web apps with very little issues; however, I have one issue with running a web app using the "view in browser" option for checking an aspx page for validity. If I use the default Northwind database provided and generate an aspx form using the "DataSet" toolbox widget, the tool prompts for the datasource etc. required to generate the required code. I can select the Northwind database and select the desired columns from one of the tables. Once completed, I build the project (clean build) and then select the "view in browser" option to verify the results. The result is an error page indicating a server error ->
Failed to find or load the registered .Net Framework Data Provider.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.
I created on odbc connection to an iSeries(as400) box and was successfull in displaying the table on the webpage! I looked into the web.config file and it appears that all the required XML data is present. Any help would be appreciated as I am fairly green when it comes the .NET world.
Thanks
I have created and deployed my first report. It renders fine for me and the other database admin. When others attempt to view it, we get the error
Query execution failed for data set 'periods'. (rsErrorExecutingCommand), For more information about this error navigate to the report server on the local server machine, or enable remote errors
Initially, We created a local group on the machine that hosts both the database and webserver and added the individuals to that group. Then, within SRS Report manager, we added that group to the Browswer role of the report.
The error message was slightly different, in that it couldn't even open the Datasource.
We then added an individual to the database as dbreader, and got the above message. It apprently is starting to render, and when it encounters the first query (dataset "periods", which populates a drop down list for a parameter), it chokes. BTW, the Periods dataset executes a stored procedure dbo.Period_List that has no parameters. It returns a list of reporting periods.
I could not figure out how to "enable remote errors" or find an error log on the server. The C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles Log files did not appear to record any errors.
Please advise!
Many a times see the below error in SQL Error log.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
Is this something to do here?
Note: If I run the below statement I know that the SQL Error log entry will go off, but wanted to know the real significance of this error?
CREATE LOGIN [NT AUTHORITYANONYMOUS LOGON] FROM WINDOWS
Hi,
I am administering several SQL Servers running SQL Server 2005 SP2 Build 3042.
I have a common maintenance plan that runs on each of the servers. The maintenance plan runs
fine on all the servers except for one. On the one server the Database Integrity check fails with the following error:
Check Database integrity on Local server connection
Databases: <list of databases>
Include indexes
Task start: 2008-02-21T00:05:42.
Task end: 2008-02-21T00:05:46.
Failed0) Alter failed for Server €˜XYZ€™
I created a test maintenance plan to just do the integrity check and selected one database only and this also failed with the same error message. I ran this test maintenance plan and configured it for each of the databases in question and it failed each time.
If I run the DBCC manually against the databases they all report fine.
I read some of the post that talked about the €œAllow Updates€? being set incorrectly but that does not apply to my problem since my configured and run values are set to 0.
Does anyone know what the problem could be?