Thank for all the comments so far.
I do not believe that reading the entire contents of the file into a temp table would be very beneficial. I suspect the main slow down is hitting the tables so often.
That being said, the HASH TABLE idea seems to be a great idea. Thanks for that idea -- I am...
Thank you for your replies.
AlexCuse, I cannot find all IDs to send to the database. That would require me to read through the entire file first, collect the IDs, send them to the database, then read through the file again to process one ID at a time (remember, each ID has dozens of other bits...
Hello, I have vb.net optimization question.
I am reading some 50,000+ records from a file, and each record contains a unique PersonID (numeric) along with other data.
Before I process the record, I need to check that personID against the database to make sure it exists in our system. If it...
Hello, I was wondering if someone can help me with an ASP.NET question. We have been having troubles with our web server, and I don't know where else to turn.
We are running an asp.net (vb.net) with IIS on our Web Server.
We are running Sql Server 2005 / SSIS on our Database Server.
SQL...
Hello, I am trying to use SSIS Script Task to get the current directly. I would like to know which directly the .dtsx file is located in.
The command line I use is:
dtexec.exe /file "\\MySever\Foo\Bar\myssis.dtsx"
I tried to use curdir(), but that gives me the directory that the dtexec.exe is...
I am using MSword 2000/2003 and Acrobat 5. I am embedding transparent gifs (or pngs) into my document, which allows my text to wrap around the critical parts of the image.
However, when I convert it to PDF, the pdf scrolls very slowly on pages that have that image. It sometimes takes 5-10...
Hello,
I downloaded the "Btrieve and VB6" zip file from the Dev Center, but the system has not sent me a password to unzip it. I have downloaded it several times.
What can I do?
~The Le
junk_of_the@hotmail.com
YEs, it is a pervasive file.
The division that sent it to us claims that there is NO DDF files with it (or will not give it to us).
Linda, the link you gave me was helpful, but did not really give me steps I need to take to recreate the DDF files. Is there other documentation somewhere?
one of my company's division sent us a pervasive .DAT file.
I have the workgroup engine, but I cannot find a way to load this file.
I tried to look at it and it is not a text file.
I think it is a table, but I am not sure because when I create tables in the workgroup engine, they are given a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.