Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TheLe
  • Order by date
  1. TheLe

    Fastest way to check 50,000 records against a DB?

    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...
  2. TheLe

    Fastest way to check 50,000 records against a DB?

    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...
  3. TheLe

    Fastest way to check 50,000 records against a DB?

    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...
  4. TheLe

    [How Do I...] use ASP.Net to call an SSIS Package on a different svr?

    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...
  5. TheLe

    [How Do I] use SSIS to find the current Directory?

    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...
  6. TheLe

    Word -to- PDF (acrobat 5) convertion issues (slow image scrolling)

    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...
  7. TheLe

    Why do I not have a password for Dev?

    All fixed now. Apparantly my filter picked it up. I am very sorry. Thanks ~Le
  8. TheLe

    Why do I not have a password for Dev?

    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
  9. TheLe

    .DAT file - what is it, how can I access it?

    Hold on. I think a lightbulb just came on in me head. Isn't Btrieve and Pervasive the same product?
  10. TheLe

    .DAT file - what is it, how can I access it?

    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?
  11. TheLe

    .DAT file - what is it, how can I access it?

    It is a ".DTA" file. Sorry for the mistake. Can anyone help?
  12. TheLe

    .DAT file - what is it, how can I access it?

    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...

Part and Inventory Search

Back
Top