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

Login Failed For User Message When Executing A Copy Of A Working Package

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

How To Copy Database And Local Package?

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

Using A DTS Package To Copy Data From Database On Remote LAN

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

Copy Database Wizard Error- SQL Server Agent Cannot Execute The SSIS Package

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

Package Failed : Failed To Decrypt Protected XML Node DTS:Password With Error

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

The Package Execution Failed. The Step Failed.

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

Execute Package Task Can't Continue When The Child Package Failed?

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

Failed To Acquire Connection When Running A Package From Within Another Package.

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

The Remote Copy Of Database X Has Not Been Rolled Forward To A Point In Time That Is Encompassed In The Local Copy

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

Dts Copy Object Failed

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

Sql Server Failed To Copy The Data

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

Bulk Copy Failed During Snapshot

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

Copy A Database With Copy The .mdf File And Attaching It With A New Name?

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

Error Creating Package - Failed To Save Package File ... Emp EmpD4B.tmp With Error 0x80040154 Class Not Registered

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

Can I Copy A DTS Package?

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

Maitenace Plan Check Database Integrity Task Fails With Failed:(0) Alter Failed For Server 'xyz'

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

How To Copy DTS Package From One SQL Server To Another?

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

How To Copy A Package DTS From A Server To Another

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

Transfer Or Copy A DTS Package From One Server To Another?

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

Copy Annotations Out Of Xml/ Dtsx Package

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

How To Copy A Database Table And Copy It Into A Different Database?

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

Deployment Package Failure - Could Not Copy File

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

Save Copy Of Package Option Missing

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

Truncating The Package Buffer After Each Table Copy

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

Why Does Add Existing Package Make A Copy Of The Dtsx?

Aug 9, 2005

How do we sync up dtsx files with Visual Source Safe? best practices?

View 10 Replies View Related

Embedding A DTS Package Which Contains A 'Copy SQL Server Objects Task'

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

BUG: Integration Services Project-can't Click On Save Copy Of Package As...

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

Copy Data To Excel File Using Dts Package In Sql Server 2000

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

Execute DTS Package From ASP Failed

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

Package Failed To Execute

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

Package Execution Failed

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

Failed To Start Package

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







Copyrights 2005-15 www.BigResource.com, All rights reserved