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-08-23 : 07:03:42
|
| Hi,I am getting the following error message when i try to import multiple dbase files.TITLE: Microsoft Visual Studio------------------------------Error at Package [Connection manager "C:\DailydbaseBackup\Gold"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not find installable ISAM.".Error at Data Flow Task [OLE DB Source 1 [319]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "C:\DailydbaseBackup\Gold" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.------------------------------ADDITIONAL INFORMATION:Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)------------------------------BUTTONS:OK------------------------------Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-08-23 : 07:48:55
|
| Thanks. But, it is working fine with single dbase file.That is the reason am confused. Please help me |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-23 : 07:54:01
|
| is there some difference in names of other files ie some special characters etc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-08-23 : 08:59:12
|
| no special characters in the files. If i import one dbase file one by one, it is working fine. I am getting the errors, while importing multiple files. I need to fix this issue ASAP.Could you please help me to resolve this issue.Thank you so much |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-23 : 09:27:09
|
| is the structure of files different?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-08-23 : 09:34:48
|
| no. Structure will be same for all files. |
|
|
|
|
|
|
SSIS