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 |
|
AnuVijay
Starting Member
32 Posts |
 Posted - 2011-09-20 : 03:54:54
|
| HiI am importing multiple dbase files. I am getting the following errors only for few files. SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. 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.Other files are importing successfully.I need to resolve this issue very soon.Could you please help me to resolve?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-20 : 05:50:35
|
| what are datatypes of data involved in files which have failed?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-09-20 : 06:03:59
|
| char, numeric and date.All other files which is having similar data types and column structure imports sucessfully. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-20 : 06:28:01
|
| is there some really long char data coming?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-09-20 : 07:01:02
|
| No...i checked the data also...only 2 files are failed because the above the error. All other files are working fine.Could u pls help me? I need to resolve this ASAP.Thansk |
|
|
|
|
|
|
Error in Import dbf files in SSIS