Package ShellPackage Failed For Copy Database
Dec 21, 2005
Hello,
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
View 1 Replies
ADVERTISEMENT
Jul 27, 2006
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
View 3 Replies
View Related
May 16, 2007
Hi All,
I am new to sql server and the database concepts and just started learning. I want to copy a database and local package from a old sql server to a new server. can anybody guide me with the steps? I am very new to this field so if you could give me detailed steps i would very much appreciate it.
thanks in advance,
View 4 Replies
View Related
Jun 28, 2002
Hi there.
Here is my problem: I'm trying to copy a few tables from an ODBC database located on a PC on my LAN to a SQL Server on a remote server.
To do this I have created a DTS package on the SQL Server which runs smoothly, copying the data as it should, but only as long as it copies the data from the ODBC database on my own computer where I have Enterprise Manager installed. The moment I try to copy data from another PC in the network where Enterprise Manager is not used to execute the DTS package the task fails to run.
I'm quite at a loss here and would very much appreciate a notch in the right direction. Perhabs some source or book which I may read to solve the problem.
/Bakkegaard
View 3 Replies
View Related
Aug 3, 2006
I am trying to
copy a database from our company's external SQL
Server(production) to our local SQL
Server(development). The Copy Database wizard fails on the step
"Execute SQL Server Agent Job".
Following is the error in the log file.. Please advise
InnerException-->An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View 7 Replies
View Related
Apr 21, 2008
Dear all,
I've built SSIS package and made a job to execute it automatically but it always returns an error. The job returns OK but when we looked at the Log File viewer, it conatins this error log :
Key not valid for use in specified state
Failed to decrypt protected XML node "DTS Password" with error
What's wrong with the package ?
Thanks in advance.
Best regards,
Hery
View 22 Replies
View Related
Feb 2, 2006
when i right click and execute the package from the Management Studio, it runs fine, everytime. When i schedule a job to execute it, it fails, everytime.
"The package execution failed. The step failed."
i have made sure that the package and job ran using credentials with more than enough access to everything. Still, with no luck. PLEASE! I am at my wits ends here, and the boss is getting antsey...
Any and all help is greatly appreciated...
Anthony
View 13 Replies
View Related
Aug 25, 2006
I use a execute package task to run a child package in which I run some sql task.
as the error handle I insert a script task and link a line from execute package task to script task
of course the line is red,
but I found when the child package failed, the execute package task turns red,it stopped
the script task can't be run, I don't konw why?
View 9 Replies
View Related
Apr 26, 2006
I am receiving an error on my master package that executes a number of other packages. The individual packages work fine when executed by themselves. However, I am getting the following error when I attempt to execute it from another package:
Error: Failed to acquire connection "conneciton". Connection may not be configured correctly or you may not have the right permissions on this connection.
Thanks in advance for your help.
View 1 Replies
View Related
May 11, 2006
Hi,
I set up DB mirror between a primary (SQL1) and a mirror (SQL2); no witness. I have a problem when I issue command:
alter database DBmirrorTest
Set Partner = N'TCP://SQL2.mycom.com:5022';
go
The error message is:
The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy of the database log.
I have the steps below prior to the command. (Note that both servers' service accounts use the same domain account. The domain account I login to do db mirror setup is a member of the local admin group.)
1. backup database DBmirrorTest on SQL1
2. backup database log
3. copy db and log backup files to SQL2
4. restore db with norecovery
5. restore log with norecovery
6. create endpoints on both SQL1 and SQL2
CREATE ENDPOINT [Mirroring]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = PARTNER)
7. enable mirror on mirror server SQL2
:connect SQL2
alter database DBmirrorTest
Set Partner = N'TCP://SQL1.mycom.com:5022';
go
8. Enable mirror on primary server SQL1
:connect SQL1
alter database DBmirrorTest
Set Partner = N'TCP://SQL2.mycom.com:5022';
go
This is where I got the error.
The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy
Thanks for any help,
KT
View 8 Replies
View Related
Jul 31, 2007
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
View 1 Replies
View Related
Aug 18, 2004
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
View 1 Replies
View Related
Apr 20, 2007
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 Related
Nov 4, 2006
Hello,
if i have a given database (a model) and i want to copy this database in the same database instance. Is it ok to copy the mdf and ldf file and attach the files with a new database name in the same instance.
Or is the datebase name part of the .mdf file?
Regards
Markus
View 6 Replies
View Related
May 19, 2006
I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.
Following is the text of the error details:
TITLE: Microsoft Visual Studio
------------------------------
Error creating package
------------------------------
ADDITIONAL INFORMATION:
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
BUTTONS:
OK
------------------------------
I found a similar post that suggested that they try the following:
regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll
But msxml6.dll could not be found.
I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.
My concern now is what is the likelyhood of this being the only file missing from the installation.
I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.
Thanks.
Marshall
View 12 Replies
View Related
Nov 3, 2004
The scenario:
9 db tables populated by 9 Excel Import Files via DTS.
Will I need to create a DTS package for each import? Columns are identical in all 9 - the only thing different is the destination table name and source file name.
I've had to map over 80 columns using DTS and don't want to do it for each instance!
Any help would be appreciated..
View 3 Replies
View Related
Feb 21, 2008
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?
View 23 Replies
View Related
Sep 5, 2001
Hi Everybody,
I have SQL 2000 running on Windows 2000 server. I have created a DTS Package, which is running fine. Now I want to transfer/restore/copy this DTS Package to another SQL 2000 server(not an instance). How do I establish this?. Can anybody guide me?.
tks in advance,
John,
View 3 Replies
View Related
Nov 25, 2004
That sounds stupid but i cant find how to copy a package DTS from a server to another (how to deploy it in production environnement for example)
View 1 Replies
View Related
May 24, 2001
Is it possible to automatically or programatically transfer or copy a DTS package from one server to another? If so, could anyone out here give some pointers on how?
E. Hunter
Accenture, LLP
View 1 Replies
View Related
Jul 14, 2006
Is there a way to strip out the annotations from a dtsx package. I'm looking at quite a few and would like to automaticly pull those out and store them somewhere in either a table or a text file.
Is this possible or am I going to have to hand copy them out?
Thanks for the help
Saitham8
View 11 Replies
View Related
Oct 28, 2006
Hello I am a software developer with minimal SQL server administration skills. Currently I am using SQL Server 2000.I need to know if there is a way to copy a particular table from a database, and to copy the table into a different database.Basically on a project I am working on we are using a table named "Customers" from a database named QTR. We need to copy this database table into a different database named "Research". How can this be done? Is if very complicated?
View 1 Replies
View Related
Jan 18, 2008
Trying to build a deployment package. I have a number of dtsx in a project that share a connection config file. When I build, the error states: 'Could not copy file "whatever.dtsconfig" to the deployment utility output directory. ... The file already exists'
What am I doing wrong?
View 7 Replies
View Related
Mar 5, 2008
On my workstation the option is there, but on a couple other workstations that option is not available from the file menu. I tested doing the exact same thing and the option just isn't there. Anyone have any idea's?
View 3 Replies
View Related
Feb 8, 2007
Hi
I have a SSIS package that I run from dtexec command prompt in parallel. they run completely isolated.
Sometime when I push 3 instance of the packege at the same time, one of the instances will fail.
I have implemented detail Log on the package to see exactly where it's going wrong.
to brife you on what the package does, I can say in nutsheel that it does copy tables between servers.
due to the nature of the problem, the point in failer can is completely random.
if I run just one instance it will work fine (always). if it is more than one that there is a chance that it might fail. (but there is agood chance that they will run successfully).
my guess is, as this packages share resources (CPU,Mempry and disk I/O) sometimes is there is anyshortage on of the packages can fail.
is there anyway to specify how log for example a sql object transfer task will wait before raise and error message.
ALSO is there a way to truncate the memory bufferafter each table copy as it seems like when it is loops for differnet tables they data copy content get's piled up in memory and it get's truncated only when the whole instance is finished not after each table copy
Thanks
View 2 Replies
View Related
Aug 9, 2005
How do we sync up dtsx files with Visual Source Safe? best practices?
View 10 Replies
View Related
Jan 23, 2007
Hi,
I am getting an error when doing the above.
I create a new SSIS package, drag in an Execute DTS 2000 Package Task, select and embed a DTS package which consists only one one task (as above), and then change the source & destination details (svr + user/pwd). Then when I go to the Copy tab, I get the following error when I hit Select Objects, to view the objects which the embedded DTS package should copy:
SQL-DMO error 21776: general error.
On further inspection, none of the objects selected for copy within the atomic/original DTS package, remain selected for copy within the embedded DTS package.
I have googled to search for an answer to this one, but to no avail. Any ideas would be greatly welcomed.
Thanks,
Tamim.
View 8 Replies
View Related
May 19, 2006
Hi.
I found a possible bug. If I open/create a new Integration Services Project and then try to save a copy of the package to SQL Server I found that for the option to "save Copy of Package As..." is only available if I am in the package itself. If I click (highlight) on the package in the Solution explorer and then click on the File tab, the "save Copy of Package As..." option is not available.
I hope that I explained this well enough.
thanks.
View 1 Replies
View Related
Jul 26, 2007
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
View 1 Replies
View Related
Jan 19, 2005
I am trying to run DTS Package from ASP 3.0 with the following codes:
Set objDTSPackage = server.CreateObject("DTS.Package")
objDTSPackage.LoadFromSQLServer "serverName", "", "", 256,,,,"pkgName"
objDTSPackage.FailOnError = true
objDTSPackage.Execute
It failed with this message, "Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed".
I am using NT Authentication in both IIS and SQLServer, and both Web and SQLServer are in the same machine.
Can someone help? Thank you.
View 14 Replies
View Related
Jan 21, 2008
I've designed a package using 'SSIS import/export wizard'. This package just copy some tables from one server to another. First time the package execute successfully but next day it fails. I am not sure what am I doing wrong. Any ideas?
Thanks in avdance.
Error:
====
SSIS package "Refresh_Tables.dtsx" starting.
Error: 0xC002F304 at NonTransactableSql, Execute SQL Task: An error occurred with the following error message: "Could not find a part of the path 'C:Documents and Settingsadmin_dbaLocal SettingsTemp2 mp42.tmp'.".
Task failed: NonTransactableSql
SSIS package "Refresh_Tables.dtsx" finished: Failure.
The program '[4196] Refresh_Tables.dtsx: DTS' has exited with code 0 (0x0).
View 1 Replies
View Related
May 9, 2008
Hi everyone,
I just deployed my first interface and below is the error message
failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'EUROPExxx123$'.". End Error Error: 2008-05-09 11:01:13.00 Code: 0xC020801C Source: Load New Data Into TransDat... The package execution fa... The step failed.
The interface is just to copy the data from 1 database to another based on a date. I suspect that i could have missed a step during the deployment, can someone tell me if the error is caused me forgetting to configure something during the step up of the job or is it network related
Regards
Ash
View 2 Replies
View Related
Sep 22, 2006
Hi,
I am getting the following error message, when I was trying to execute an existing SSIS Package which was working properly before.
"Failed to Start Package
Cannot communicate with the debug host process. Failed to obtain child process active object. (Microsoft.DataTransformationServices.VsIntegration)"
So I tried creating a new package and execute it, still I am getting the same error message.
If anyone have come across this problem and rectified it, pls let me know.
Thanks in advance for your help.
Regards,
Prakash Srinivasan
View 6 Replies
View Related
