July 30, 2009 at 1:32 am
we have batch process from SQL 2000 on windows 2000, we do bulk insert from text files using ISQL commands
ISQL -E /d dbname /S servername /Q "BULK INSERT Tbl_20090726 FROM 'd:\GGS\GGSPROD\DIRDAT\TLCURR.DAT'" /E
when we migrated to sql 2005 on windows 2003, we had changed to ISQL to OSQL to run the batch. but it failed with this error
he OLE DB provider "BULK" for linked server "(null)" reported an error. The
provider did not give any information about the error.
Msg 7330, Level 16, State 2, Server servername , Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Please give me a quick solution as i am running out of time.
July 30, 2009 at 4:01 am
jymoorthy (7/30/2009)
we have batch process from SQL 2000 on windows 2000, we do bulk insert from text files using ISQL commandsISQL -E /d dbname /S servername /Q "BULK INSERT Tbl_20090726 FROM 'd:\GGS\GGSPROD\DIRDAT\TLCURR.DAT'" /E
when we migrated to sql 2005 on windows 2003, we had changed to ISQL to OSQL to run the batch. but it failed with this error
he OLE DB provider "BULK" for linked server "(null)" reported an error. The
provider did not give any information about the error.
Msg 7330, Level 16, State 2, Server servername , Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Please give me a quick solution as i am running out of time.
Have you tried specifying the fully qualified name for the destination table. So "Bulk Insert ..tbl_20090726 etc
July 30, 2009 at 5:35 am
Thanks Paul. I just tried to run with fully qualified name. still the same 😉
July 30, 2009 at 6:01 am
Can you run the bulk insert statement in SSMS?
Maybe it needs the DATAFILETYPE specifying, if there are differences from 2000 to 2005.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply