Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chapo
Starting Member
39 Posts |
 Posted - 2008-11-19 : 09:42:47
|
| I have two identical databases in different servers I'm trying to copy tables from the Prod to the Dev server but I keep getting the following messagesMessagesError 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Incorrect syntax near 'collate'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.". (SQL Server Import and Export Wizard) Error 0xc0209029: Data Flow Task: The "input "Destination Input" (53)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (53)" specifies failure on error. An error occurred on the specified object of the specified component. (SQL Server Import and Export Wizard) Error 0xc0047022: Data Flow Task: The ProcessInput method on component "Destination - AllHours" (40) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. (SQL Server Import and Export Wizard) Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0209029. (SQL Server Import and Export Wizard) Error 0xc02020c4: Data Flow Task: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. (SQL Server Import and Export Wizard) Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - AllHours" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. (SQL Server Import and Export Wizard) Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038. (SQL Server Import and Export Wizard)Any light on the above errors would be greatly appreciated. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-11-19 : 09:53:21
|
On your dev server, what do you get when you run the following script?sp_dbcmptlevel yourdatabasenamegoselect @@version Did you edit the SSIS package before running it, at all, or was this a straight copy? |
 |
|
|
chapo
Starting Member
39 Posts |
Posted - 2008-11-19 : 10:39:34
|
quote:
Originally posted by mcrowley
On your dev server, what do you get when you run the following script?sp_dbcmptlevel yourdatabasenamegoselect @@version Did you edit the SSIS package before running it, at all, or was this a straight copy?
I get the following messageMsg 15010, Level 16, State 1, Procedure sp_dbcmptlevel, Line 47The database 'yourdatabasename' does not exist. Use sp_helpdb to show available databases.It was a stright copy using the import data option on SQL server management. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-19 : 10:41:30
|
quote:
Originally posted by chapo
quote:
Originally posted by mcrowley
On your dev server, what do you get when you run the following script?sp_dbcmptlevel yourdatabasenamegoselect @@version Did you edit the SSIS package before running it, at all, or was this a straight copy?
I get the following messageMsg 15010, Level 16, State 1, Procedure sp_dbcmptlevel, Line 47The database 'yourdatabasename' does not exist. Use sp_helpdb to show available databases.It was a stright copy using the import data option on SQL server management.
you need replace yourdatabasename with your actual database name. |
|
|
|
chapo
Starting Member
39 Posts |
Posted - 2008-11-19 : 11:26:42
|
quote:
Originally posted by visakh16
quote:
Originally posted by chapo
quote:
Originally posted by mcrowley
On your dev server, what do you get when you run the following script?sp_dbcmptlevel yourdatabasenamegoselect @@version Did you edit the SSIS package before running it, at all, or was this a straight copy?
Here is the output Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) also I try to do the same but imported it onto a different database and it work so there is something going on with theses database I just can figure it out.I get the following messageMsg 15010, Level 16, State 1, Procedure sp_dbcmptlevel, Line 47The database 'yourdatabasename' does not exist. Use sp_helpdb to show available databases.It was a stright copy using the import data option on SQL server management.
you need replace yourdatabasename with your actual database name.
|
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-11-19 : 14:08:19
|
What was the result of this??sp_dbcmptlevel yourdatabasename Remember, I do not know your database's name. You must supply that where it says yourdatabasename. We can only help you as much as you help us. |
|
|
|
|
|
|
|
|
Help With Import and Export Wizard