May 14, 2009 at 8:05 am
Hi @ll,
I need your help!
we are trying to import large data ( approx. 19 million data sets) from a sybase table into a SQL Server database with the Integration Services via Sybase driver (OLE DB). (registered drivers : dboledb10.dll and
dboledba10.dll ; SQL Server Enterprise Edit. X64; Windows Server 2003)
The packages works fine und results successfully, but it imports data sets between 7-9 Million rows....instead of 19 million rows.
We also tried it with a data import in SQL Server (-> linked server; and then with OPENQUERY), the import finishes successfully but the result delivers again between 7-9 Million rows. The amount of rows which is delivered through the import is varying;
Has anyone experienced such a problem with Sybase? Or can anyone tell me an other way to import the 19 million rows? I do not want to import them via flatfile.
My problem is: I do not get all the data rows i need....i need 19 million and i just get rows between 7-9 millions....any ideas?
Thanks in Advance
Ahmet
May 14, 2009 at 8:26 am
May be you dont have the needed disk space
:-):-D:crazy::blink::ermm::-P;-):w00t::cool::hehe::smooooth:
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
May 14, 2009 at 10:44 am
Hi Blade, disk space is available and is not the problem....;-)´
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply