Search results for query: *

I ran using the code above. It took 1 hr 13 minutes to process 1000 rows. This table contains 22,000,000+ rows.

Hi Mr. Denny, I am trying your suggestion on a 1000000 file. Do you know if this frees space after it processes a batch of 1000 rows?

I have a 22,000,000 table that has a field which is a concatenation of 3 other fields. I need to extract this information into 3 separate fields. What is the best way to do this without hogging memory and space on the server? Is there a way to loop through? SQL2000 server.

Thanks so much for trying. It would probably cost me my job to give you remote access. I don't think it's worth that. I will play around with it. I can't understand why it's not working. You know it has to be something very simple. That's usually the way. Thanks again.

Hi Frederico, I followed your instructions. The job ran without error, but the file was not transferred.

Thanks, I wish this was a challenge to our mainframe guys. They just raise their hands. Thanks so much for your help and efforts.

I did try it from the command prompt. That worked. However, I still get the error message when trying to do it from my code. I tried creating a .bat file and executing it. Call oScript.Run ("ftp.exe -s:" & Server.MapPath("RUNftp.bat"), 0, False) That also didn't work.

NOne of them have ever tried this. I must be missing something. What connections and tasks would I need in my DTS? Have you actually accomplished this? The DBA's and mainframe guys here don't have a clue.

Thanks Frederico, I am getting an error now 'Could not open file for reading'.

OK, I have the IP address for the mainframe. I understand that I will probably need to use the Dynamic Properties Task to specify the file to be downloaded. I am having trouble with that. What would the path for the file look like. Any examples? Any alternatives?

In setting up the FTP task, it asks there are two options for source, Internet or Directory.

I need a little help. How do I specify the mainframe file? Would I use the directory option?

Thanks so much for your help. I will try it.

I am not sure if I am in the right forum, but I need to transfer a text file from the mainframe to the SQL Server 2000 or in a directory daily. How would I do this without manual intervention?

I have taken responsibility for a intranet site. It has 3 main directories, each with several subdirectories and pages. I need to make changes to the templates. Let me mention we are using Contribute. I want to make this an easier task if possible. How easy is it to change an existing...

How easy is it to change an existing website to use SSI instead of templates? How would this work when the user creates a new page in Contribute using the templates?

Hello, I am working on a project that will be using Interdev to develop a intranet website. We will send an email to an Outlook email which will include a link to an Intranet page. Is it possible to determine the email address of the person linking back into the intranet? What information...