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 |
|
joy_hw
Starting Member
8 Posts |
 Posted - 2010-02-02 : 23:56:21
|
| I'm using SQL Server Management Studio. I was wondering if anyone has ever gotten an error while importing the multiple tables to SQL server. The error codes that I got were 0xc02090f5 or 0xc0047038.There is a workaround in my case, but I thought I asked.Thank you in advance. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-02-03 : 08:40:14
|
| You need to be more specific. What method of importing are you using and what is the error text?- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-03 : 11:11:23
|
| it seems like an error thrown by export import wizard ssis package |
|
|
|
joy_hw
Starting Member
8 Posts |
Posted - 2010-02-03 : 15:06:34
|
| I'm sorry.I was using the import and export wizard. Whether I import the excel files or tables through ODBC, if I try to import more than one table, I was getting an error. If I import them one out of the time, I don't get any errors.Please see below.- Executing (Error)Messages· Error 0xc02090f5: Data Flow Task 1: The component "Source 1 - TABLETEST" (171) was unable to process the data. Attempted to read or write protected memory. This is often an indication that other memory is corrupt.(SQL Server Import and Export Wizard)Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source 1 - TABLETEST" (171) returned error code 0xC02090F5. 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. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)Thank you.[/navy] |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-03 : 16:10:10
|
| what version, edition, build of SQL Server? Also, what version management studio (go to help, about)? |
|
|
|
joy_hw
Starting Member
8 Posts |
Posted - 2010-02-04 : 09:35:21
|
| It's Microsoft SQL server 2008, and the SSMS version is 10.0.1600.22.I don't know this is enough information.Thank you. |
|
|
|
|
|
|
Import error