SQL 2012 :: Backup Log Failed With Cannot Insert Duplicate Key In Object
Jun 17, 2014
One of my database transaction log backup jobs failed this morning, although the log backup was still taken, the job reported failure. The job has run successfully a number of times since. The job reported a primary key violation error on the msdb.dbo.backupmediaset table. The full error message was
Violation of PRIMARY KEY constraint 'PK__backupme__DAC69E4D599F1693'. Cannot insert duplicate key in object 'dbo.backupmediaset'. The duplicate key value is (401862).
Msg 3009, Level 16, State 1, Server myservername, Line 1
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
After investigating the backupset and backupmediaset tables in msdb I can see that value used for the failed insert was used previously for the last database log backup in the previous log backup run. The failure was reported for the first database log backup attempted. The SQL Log shows an entry for the log being backed up successfully.
I have checked the identify value in the backupmediaset table using DBCC CHECKIDENT and all looks OK.
DBCC CHECKIDENT ('backupmediaset',NORESEED)
Is there anything else I need to check?
View 6 Replies
ADVERTISEMENT
Jun 27, 2006
The following quote is the exact error message that I get when I attempt to create a pull subscription. The STAppointment is one of a 15 databases that need to replicate inorder for the application SalonTouch to run properly.
What is causing this error? Is it user rights? Is it a problem with sql2005? Am I missing a step? Is there a problem with the database I am working with? What else?
TITLE: New Subscription Wizard
------------------------------
SQL Server could not create a subscription for Subscriber 'D6LHWQ91PORTSUN9'.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot insert duplicate key row in object 'dbo.MSmerge_replinfo' with unique index 'uc1MSmerge_replinfo'.
The subscription could not be created.
The subscription properties table 'MSsubscription_properties' does not exist in the current database.
Changed database context to 'STAppointment'.
The statement has been terminated. (Microsoft SQL Server, Error: 2601)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=2601&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
View 3 Replies
View Related
Aug 21, 2006
I'm using SSRS 2005 on a Server 2003 machine.
Some of my reports run fine but others take a long time to run and sometimes fail with an http error 503.
After a report errror happens I find entries in the event log that says: cannot open a connection to the report server
When I look at the log files for Reporting services I see an error caused by a primary key violation on the Running Jobs Table:
Violation of PRIMARY KEY constraint 'PK_RunningJobs'. Cannot insert duplicate key in object 'dbo.RunningJobs'
Does anyone know why do I get such errors?
Bellow is the error message in the logs:
w3wp!library!6!21/08/2006-09:30:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_RunningJobs'. Cannot insert duplicate key in object 'dbo.RunningJobs'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.RunningJobsDb.AddRunningJobs(Hashtable runningJobs)
View 10 Replies
View Related
Feb 22, 2007
We continue to recieve he following error on our RS 2005 SP1 Reporting Services installation:
Violation of PRIMARY KEY constraint 'PK_RunningJobs'. Cannot insert duplicate key in object 'dbo.RunningJobs'
This causes our server to become unresponsive and some reports to not render, Its becoming quite common. We reset IIS to correct it but is causes a service interuption. I know that it had been talked about before as something that may be fixed in SP2. But I do not see this referenced.
Does anybody know of any fix for this?
Thanks
Ron
View 1 Replies
View Related
Jun 6, 2011
I have a SQL Server 2008 R2 on a windows 2008 server.After one failed backup, I started getting these errors:
Error: 2601, Severity: 14, State: 1.Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'.
Error: 3999, Severity: 17, State: 1.Failed to flush the commit table to disk in dbid 5 due to error 2601. Check the errorlog for more information.
From Microsoft, I found this:
A backup Operation On A SQL Server 2008 Database Fails If You Enable Change Tracking On This Database
[URL]
But this bug refers to SQL Server 2008. What should I do if in my case is a R2 version?
View 5 Replies
View Related
Feb 28, 2007
I have 1 client who keeps running into the following error on the subscriber and merge agents >
€śCannot insert duplicate key row in object 'MSmerge_genhistory' with unique index 'unc1MSmerge_genhistory'.€?
Last time we got this error I ran a reindex on table MSmerge_genhistory on the publisher database, I then successfully generated a new snapshot and the subscribers started to synchronize again. This time around I keep getting the error even after I follow these steps (I also ran all the jobs to clean up replication). The last time I ran into this error I created a job to reindex msmerge_genhistory on a nightly bases in an effort to avoid this problem. Can somebody please provide me with a workaround and also the reason why this error occurs in the first place.
Thank you in advanced,
Pauly C
View 6 Replies
View Related
Aug 22, 2007
Hi.
I have been recently redesigning my tables - creating FK
relationships from child tables to the PK userid in the Users table.
The specifics of what I did and why can be seen here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1968856&SiteID=1
But, now I am getting the below error:
Cannot insert duplicate key row in object 'dbo.lastlogin' with unique index 'IX_lastlogin'.
The statement has been terminated.
Or, for that matter, SavedSearches or any other table where I need to
insert the same userid twice. I can see why I would want to avoid duplicates in the Users table. But, for lastlogin, savedsearches, and
a few of my other tables, the same user may account for multiple rows.
Any suggestions as to where I messed up and how to deal with this?
Thanks.
DBO.USERS
Code Snippet
CREATE TABLE [dbo].[users](
[userid] [int] IDENTITY(1,1) NOT NULL,
[lastname] [varchar](50) NULL,
[firstname] [varchar](50) NULL,
[email] [varchar](50) NOT NULL,
[alternateemail] [varchar](50) NULL,
[password] [varchar](50) NOT NULL,
[role] [varchar](10) NOT NULL,
[securityquestion] [varchar](50) NOT NULL,
[securityanswer] [varchar](50) NOT NULL,
[zipcode] [int] NOT NULL,
[birthmonth] [tinyint] NOT NULL,
[birthday] [tinyint] NOT NULL,
[birthyear] [int] NOT NULL,
[gender] [varchar](10) NULL,
[city] [varchar](50) NULL,
[state] [varchar](50) NULL,
[country] [varchar](50) NULL,
[registerdate] [datetime] NOT NULL,
[editdate] [datetime] NULL,
[confirmed] [bit] NULL CONSTRAINT [DF__Users__confirmed__4CC05EF3] DEFAULT ((0)),
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
[userid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_email] UNIQUE NONCLUSTERED
(
[email] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[lastlogin] Script Date: 08/22/2007 14:16:16 ******/
SET ANSI_NULLS ON
DBO.SAVEDSEARCHES
CREATE TABLE [dbo].[savedsearches](
[savedsearchesid] [int] IDENTITY(1,1) NOT NULL,
[searchname] [varchar](50) NOT NULL,
[userid] [int] NOT NULL,
[date] [datetime] NULL,
[isdefault] [bit] NULL,
[gender] [char](10) NULL,
[startyear] [varchar](50) NULL,
[endyear] [varchar](50) NULL,
[country] [varchar](50) NULL,
[miles] [int] NULL,
[pictures] [varchar](50) NULL,
[postal] [int] NULL,
[sort] [tinyint] NULL,
[photostring] [varchar](50) NULL,
[orderby] [tinyint] NULL,
CONSTRAINT [PK_SavedSearches] PRIMARY KEY CLUSTERED
(
[userid] ASC,
[searchname] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[savedsearches] WITH NOCHECK ADD CONSTRAINT [FK_savedsearches_users] FOREIGN KEY([userid])
REFERENCES [dbo].[users] ([userid])
GO
ALTER TABLE [dbo].[savedsearches] CHECK CONSTRAINT [FK_savedsearches_users]
GO
SET QUOTED_IDENTIFIER ON
GO
The following insert statement returned the error in the subject because userid = 32 already exists in the Users table.
INSERT INTO lastlogin
VALUES (32, CONVERT(VARCHAR(26), GETDATE(), 109), 1, CONVERT(VARCHAR(26), GETDATE(), 109))
DBO.LASTLOGIN
Code Snippet
CREATE TABLE [dbo].[lastlogin](
[lastloginid] [int] IDENTITY(1,1) NOT NULL,
[userid] [int] NOT NULL,
[date] [datetime] NOT NULL,
[status] [bit] NOT NULL CONSTRAINT [DF_lastlogin_status] DEFAULT ((0)),
[activity] [datetime] NOT NULL CONSTRAINT [DF_lastlogin_activity] DEFAULT (getutcdate()),
[online] AS (case when [status]=(1) AND datediff(minute,[activity],getutcdate())<(30) then (1) else (0) end),
CONSTRAINT [PK_lastlogin] PRIMARY KEY CLUSTERED
(
[date] ASC,
[userid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[lastlogin] WITH NOCHECK ADD CONSTRAINT [FK_lastlogin_users] FOREIGN KEY([userid])
REFERENCES [dbo].[users] ([userid])
GO
ALTER TABLE [dbo].[lastlogin] CHECK CONSTRAINT [FK_lastlogin_users]
View 1 Replies
View Related
Oct 19, 2007
the point here that i have a small table with two fileds,
ID (guid) as primerykey
RAF(char)
and the table is empty when i add a new row i recieve this exception,
Violation of PRIMARY KEY constraint 'PK_tblType'. Cannot insert duplicate key in object 'dbo.tblType'.
i found no way to solve the problem.
thanks in advans
View 7 Replies
View Related
Sep 8, 2013
I have table variable in which I am inserting data from sql server database. I have made one of the columns called repaidID a primary key so that a clustered index will be created on the table variable. When I run the stored procedure used to insert the data. I have this error message; Violation of Primary key Constraint. Cannot insert duplicate primary key in object. The value that is causing this error is (128503).
I have queried the repaidid 128503 in the database to see if it is a duplicate but could not find any duplicate. The repaidID is a unique id normally use by my company and does not have duplicates.
View 9 Replies
View Related
Jan 16, 2007
We are developing a project that is expected to hold TB of data and the back end used is SQL Server 2005.
I have the following problem
I have applied Nonclustered index over a column on a table.
Designed a SP for insertion which caters for updation incase the criteria based on the input is met.
The logic goes like this
Incase there exists a row containing the value of the column that is indexed for uniqueness, there should be updation. If not there should be a new row created.
However often there is an error message that is placed above. This happens only on some of the SPs and only on rare occasions.
Can any body tell me if there is any problem with the SQL Server 2005
Thanks in advance
R Suresh, SQLDBA
View 8 Replies
View Related
Aug 23, 2013
On the SQL Server the Event Viewer shows the same messages and errors every evening between 22:05:00 and 22:08:00. The following information messages are shown for every database:
"I/O is frozen on database <database name>. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup."
"I/O was resumed on database <database name>. No user action is required."
"Database backed up. Database: <database name>, creation date(time): 2003/04/08(09:13:36), pages dumped: 306, first LSN: 44:148:37, last LSN: 44:165:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{A79410F7-4AC5-47CE-9E9B-F91660F1072B}4'}). This is an informational message only. No user action is required."
After the 3 messages the following error message is shown for every database:
"BACKUP failed to complete the command BACKUP LOG <database name>. Check the backup application log for detailed messages."
I have added a Maintenance Plan but these jobs run after 02:00:00 at night.
Where can I find the command or setup which will backup all databases and log files at 22:00:00 in the evening?
View 9 Replies
View Related
Oct 2, 2007
Hello Everyone:
I am using the Import/Export wizard to import data from an ODBC data source. This can only be done from a query to specify the data to transfer.
When I try to create the tables, for the query, I am getting the following error:
Msg 2714, Level 16, State 4, Line 12
There is already an object named 'UserID' in the database.
Msg 1750, Level 16, State 0, Line 12
Could not create constraint. See previous errors.
I have duplicated this error with the following script:
USE [testing]
IF OBJECT_ID ('[testing].[dbo].[users1]', 'U') IS NOT NULL
DROP TABLE [testing].[dbo].[users1]
CREATE TABLE [testing].[dbo].[users1] (
[UserID] bigint NOT NULL,
[Name] nvarchar(25) NULL,
CONSTRAINT [UserID] PRIMARY KEY (UserID)
)
IF OBJECT_ID ('[testing].[dbo].[users2]', 'U') IS NOT NULL
DROP TABLE [testing].[dbo].[users2]
CREATE TABLE [testing].[dbo].[users2] (
[UserID] bigint NOT NULL,
[Name] nvarchar(25) NULL,
CONSTRAINT [UserID] PRIMARY KEY (UserID)
)
IF OBJECT_ID ('[testing].[dbo].[users3]', 'U') IS NOT NULL
DROP TABLE [testing].[dbo].[users3]
CREATE TABLE [testing].[dbo].[users3] (
[UserID] bigint NOT NULL,
[Name] nvarchar(25) NULL,
CONSTRAINT [UserID] PRIMARY KEY (UserID)
)
I have searched the "2714 duplicate error msg," but have found references to duplicate table names, rather than multiple field names or column name duplicate errors, within a database.
I think that the schema is only allowing a single UserID primary key.
How do I fix this?
TIA
View 4 Replies
View Related
Aug 12, 2014
SQL server 2012, SP1
DB is in SIMPLE recovery mode (total size 124 GB). Log file Initial size is 650 MB auto growth set for 500 MB.
Below is the error I am facing.
Could not clear 'DIFFERENTIAL' bitmap in database 'DBSAPCAD' because of error 9002. As a result, the differential or bulk-logged bitmap overstates the amount of change that will occur with the next differential or log backup. This discrepancy might slow down later differential or log backup operations and cause the backup sets to be larger than necessary. Typically, the cause of this error is insufficient resources. Investigate the failure and resolve the cause. If the error occurred on a data backup, consider taking a data backup to create a new base for future differential backups.
A nonrecoverable I/O error occurred on file "//SQLDIFF/SAPCAD_DBSAPCAD.bak:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).BACKUP DATABASE is terminating abnormally.
In the weekend we faced an error on the DB backup.Drive K got full because of database log file grown and we have 4 MB free space left. I have no option to increase the drive space nor the log file size.
I am unable to perform, full or differential backup for this db.
View 9 Replies
View Related
Jun 17, 2014
I need to get the object type (view, table ...etc) for a synonym base object inside a script. The only place where I see something related to this stored is in column "base_object_name" in sys.synonyms but there I can see only the same with format [database].[user/schema].[name]. After some testing playing with different users without specifying database/schema I think that maybe the object_id must be stored in a another place, my first idea was parent_object_id in sys.synonyms but it isn't stored there.
know if object_id for the base object is stored in any other place ?
View 6 Replies
View Related
May 14, 2014
I am having an issue with sql server 2012 sp1 management, when ever i try to modify an existing maintenance plan i get the following error: "object reference not set to an instance of an object. (microsoft.datatransformationservices.vsintegration)".
View 3 Replies
View Related
Oct 1, 2007
Existing database (upgrade to SS2k5) has four tables with same primary key columns (UserID).
Using CREATE TABLE with a specified [databasename].[dbo].[table1] schema is giving the following error message:
Msg 2714, Level 16, State 4, Line 12
There is already an object named 'UserID' in the database.
Msg 1750, Level 16, State 0, Line 12
Could not create constraint. See previous errors.
I have duplicated the error with the following script:
USE [testing]
IF OBJECT_ID ('[testing].[dbo].[users1]', 'U') IS NOT NULL
DROP TABLE [testing].[dbo].[users1]
CREATE TABLE [testing].[dbo].[users1] (
[UserID] bigint NOT NULL,
[Name] nvarchar(25) NULL,
CONSTRAINT [UserID] PRIMARY KEY (UserID)
)
IF OBJECT_ID ('[testing].[dbo].[users2]', 'U') IS NOT NULL
DROP TABLE [testing].[dbo].[users2]
CREATE TABLE [testing].[dbo].[users2] (
[UserID] bigint NOT NULL,
[Name] nvarchar(25) NULL,
CONSTRAINT [UserID] PRIMARY KEY (UserID)
)
IF OBJECT_ID ('[testing].[dbo].[users3]', 'U') IS NOT NULL
DROP TABLE [testing].[dbo].[users3]
CREATE TABLE [testing].[dbo].[users3] (
[UserID] bigint NOT NULL,
[Name] nvarchar(25) NULL,
CONSTRAINT [UserID] PRIMARY KEY (UserID)
)
I have searched the "2714 duplicate error msg," but have found references to duplicate table names, rather than multiple field names or column name duplicate errors within a database.
I think that the schema is only allowing a single UserID primary key.
How do I fix this?
TIA
View 5 Replies
View Related
Feb 9, 2004
Hi,
I use the Transact-SQL BACKUP statement in Visual Basic to backup my local MSSQL Database. It give me this error
Error 3041
BACKUP failed to complete the command BACKUP DATABASE [BCFPC] to BCFPCBKP
I already created a backup device called BCFPCBKP and it is backup to the disk.
I tried to run the same BACKUP statement in SQL Query Analyzer and it worked fine. I tried to run my VB application in another PC. It worked fine when i use this command remotely. Can anyone tell me what's the problem?
Thanks in advance
regards,
M.Y. Yap
View 2 Replies
View Related
Jul 11, 2007
Using SQL Server 2005 Server Management Studio, I attempted to back up a database, and received this error:
Backup failed: System.Data.SqlClient.SqlError: Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the satement after the current backup or file manipulation is completed (Microsoft.SqlServer.Smo)
Program location:
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender)
Backup Options were set to:
Back up to the existing media set
Overwrite all existing backup sets
I am fairly new to SQL 2005. Can someone help me get past this issue? What other information do I need to provide?
View 11 Replies
View Related
Aug 4, 2007
Backup failed to complete the command backup database [ ] TO VIRTUAL DEVICE = ' { 853D3FC0 - 45EA -85B1 - 54F0EA379CAC } 24 ' WITH SNAPSHOT , BUFFERCOUNT = 1 , BLOCKSIZE = 1024
View 1 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
Apr 6, 2012
I'm trying to modify a specific row in a table.
$paper_id = 2A
$query = "UPDATE book SET paper_id='$paper_id', title='$title'";
I'm getting this error <<query failed: Duplicate entry '2A' for key 'PRIMARY'>>
Structure:
Column: paper_id
Type: Char
Length: 20
Deafult: None
View 5 Replies
View Related
Jul 20, 2005
I want to add the content of a table into anotherI tried to copy all fields, except the primary key:INSERT INTO table2(field2, field3, field4, ...)SELECT field2, field3, field4, ...FROM anotherDB.dbo.table1gives the following error:Violation of UNIQUE KEY constraint...Cannot insert duplicate key...Why?I didn't ask him to copy the key column; Isn't the SQL Server supposedto know how to increment the key ?
View 2 Replies
View Related
Feb 19, 2015
Using Ola Hallengren's scripts I do a full backup of a database on a Sunday. Then differential backups every 6 hours and log backups every hour. I would like to keep a full week of backups based off the full backup done on Sunday. Is there a way for me to clear out the diff and log folders after the successful full backup on Sunday nights?
View 2 Replies
View Related
Jun 27, 2007
Hello,
Is there any body who create a linked object in sql server 2005 SP2 to Oracle9i sucessfully? I create a link using MS OLE DB provider for oracle, it is ok but I can select the table. It gave me invalid object name linkname.owner.tablename error. If I create a link using MS OLE DB provider for odbc, it failed saying system error.
"ODBC Driver Manager: Invalid connection string attribute. Specified driver could not be load due to system error 5(oracle in oraHome92)(SQL server, error 7303)"
I installed oracle odbc 9.2 on sql server 2005 server and tested it ok. Why link server object can't create?
any help, thanks!
View 1 Replies
View Related
Feb 2, 2000
Hi all,
I want to transfer a database from one MS SQL Server 7.0 to another.
When I create a new database (SQL Server 7.0) and then try to load a backup, I always end up with a message that the backup database is not identical with the destination database. That is correct and I know it, so what!? Is there any other possibility to transfer a database other than Export/Import. Using this method took me about 48 hours for 6 GByte database!
All suggestions are welcome
Thank you
Karsten
View 3 Replies
View Related
Dec 29, 2014
I'm looking to schedule a maintenance plan for my databases which I have done.I'd like this database to be copied to another folder and the name altered to include the file name and the current date time stamp.Is this possible in the scheduled maintenance plan?
View 4 Replies
View Related
Aug 16, 2007
I am using SQL Server 2000. I have a table (tbDupes) with duplicate records. I want to populate another table (tbUnique) with unique records.
My tbDupes has about 50 columns and three of them make up my primary key in tbUnique. I thought I could get unique records by using the following SQL statement.
Code Snippet
INSERT INTO tbUnique
SELECT * FROM tbDupes
I received this error: Cannot insert duplicate key
Is there a database setting that will allow me to insert the first record and prevent any duplicates from being inserted? I thought this was the default behavior and think that maybe the DBA changed it.
I know I can achieve this by creating a cursor with tbDupes and then something like "IF NOT EXISTS(...) THEN INSERT". However, I would prefer to avoid using a cursor.
View 6 Replies
View Related
Nov 3, 2014
I scheduled automatic backup process but its only showing backup of the only one .sql file in the backup folder. Other created .sql files are not backed up. Why is it so?
View 5 Replies
View Related
Feb 26, 2007
We did configure reporting services to use a custom security extension on a Windows 2000 sp4 machine and using IIS 5.0.
The website for reporting services is not using the default website in IIS. It uses IP address : 192.168.1.20 and host header name is rpt2.compagny.com. When accessing the report manager at http://rpt2.compagny.com/reports$sql_2005 from another machine or on the machine where reporting services is installed we get an error message.
Error Message : The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
The RSWebApplication.config file looks like the following :
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://server name/ReportServer$sql_2005</ReportServerUrl>
</UI>
The RSreportserver.config file looks like the following :
<UrlRoot>http://server name/ReportServer$SQL_2005</UrlRoot>
We already tried replacing the server name with the ip address in both the RSreportserver.config file and RSWebapplication.config file and it still does not work.
here is the logfile information :
aspnet_wp!ui!1!2/26/2007-14:41:51:: e ERROR: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
aspnet_wp!ui!1!2/26/2007-14:41:51:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: Object Not Found.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
What should be the settings in IIS and the configuration files ?
Any help would be appreciated.
Chi
View 2 Replies
View Related
Oct 17, 2006
Hi
First up - my apologies if this is not the right forum for this question. Please let me know if there is a more appropriate one for this question.
I have come across an issue with my SQL Server 2005 Express Edition install. It has been running fine since the install (a few months back). And I can still interact (query, update etc) the databases just fine. However, SQL Management Server Studio Express has started to produce an error message when I attempt to connect the Object Explorer.
The error message is shown below.
I have tried to access the link shown in the error message but there is no information provided there.
I can use SQL Management Server Studio Express to run queries on the databases so it would appear that the underlying services are all running OK.
The SQL Server is installed using SQL Authentication only and I have not made any changes to Service accounts or the services themselves. The protocols all appear to be in order too - Shared Memory, Named Pipes, TCP/IP are all enabled.
I have restarted the SQL services and even rebooted the machine, but to no avail.
I would really appreciate if anyone out there could give me some guidance on what may be causing this issue.
Note: The SQL Server is installed on WinXP Pro SP2 running in a VirtualPC. All apps are release versions (no beta or CTP)
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
View 10 Replies
View Related
Jul 12, 2007
Here's the full story...
I'm trying to get some proof of concept reports made for a MOSS / SQL Server 2005 (sp2) Integrated solution. I have a simple report that displays everything in the 'incident' uploaded to the MOSS server, and it works fine.
I've made another report that uses a line chart to plot some averages. This report, called 'Average Control Time by Weekday' works 100% ok in VS2005 preview mode and both reports use the same datasource. The report is uploaded and the dataset is all linked up.
When I view the report (by clicking on it's link on my Sharepoint Site), however, I get an error:
An error has occurred during report processing.
Query execution failed for data set 'DataSource1'.
Invalid object name 'incident'.
I've checked the SQL that was run in the SQL Server Profiler to see what transactions were hitting the database. The query that the report makes when in VS2005 Preview mode is precicely the same as what Sharepoint makes when it tries to render the report.
I made another plain report (just a table view) that uses the same query as the 'Average Control' report and tested it on Sharepoint, and it works perfectly. Any ideas?
p.s. I even asked I-God (http://www.titane.ca/concordia/dfar251/igod/main.html) all he said was that I would need a court order to get rid of the recursion in AIML... and then asked for my credit card number.
View 1 Replies
View Related
Oct 18, 2007
How can I prevent duplicate inserts or entries to a table?
Thank you.
Note: I am using SQL Server and coding ASP.net pages in VB.
View 7 Replies
View Related
