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-11-15 : 07:22:24
|
| Hi I am getting the following error when importing dbf files. "opening a rowset for FD011015.dbf failed". check that object existsin the database"fter this, if i stop the execution and run it again. It is not giving error. It is importing the same file.Can you pls help me resolve this?ThanksAnu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-15 : 07:27:50
|
| where are you trying to use this? in OLEDB source?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-11-15 : 07:46:55
|
| yes. After stop the execution of SSIS. Again, am trying the import the dbf files which is giving the error. This time, it succssfully imported the data into sql server destination.How to avoid this?ThanksAnu |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-15 : 08:17:20
|
| Need to nkow more about how the file is created.Could it be that the file exists but is still being built so cannot be accessed? You retry it after the locks are relaesed so it is ok.I always transfer files to a temporary name then rename. It's especially importatnt with ftp where often locks aren't taken and you can import a part file without realising.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-15 : 10:10:07
|
quote:
Originally posted by AnuVijay
yes. After stop the execution of SSIS. Again, am trying the import the dbf files which is giving the error. This time, it succssfully imported the data into sql server destination.How to avoid this?ThanksAnu
so every first time it works and then its throwing error for subsequent loads?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-11-16 : 04:47:35
|
| If we rerun the package, not getting the error.We need to stop the SSIS and rerun it again if the above error comes?How can i do it in SSIS?Can you pls help us to resolve this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 05:01:22
|
| is there parallel execution happening? Is the source dbf file static? or are you getting new dbf in each case?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-11-16 : 05:33:05
|
| I am importing multiple dbf files. On daily basis,updated dbf file will come.I would like to know the reason, why it is importing successfully once i rerun the package. |
|
|
|
|
|
|
SSIS Import