Hi

The help i need is in showing the information on the form, can't firgure out how to show this information on my form. So how would you go about displaying...

I use this for a job that i have it get a file form a web site and put it into a network location.

This is an active x script

Function...

Sorry i just read what i had written and its confusion, i Already have a password on my excel file and want to refresh it so i neeed to say...

Hi Lynn,

Thanks i get the variable @month as 'march' which is the result am looking for thank you

Hi Ken, thanks for the links

I've pick this example but i don't understand one thing..

For the source file i use this line

strFilePath = "C:\TEMP\ASL_" & strFileDate

But where does ...

Hi Vladan,

Am working off the same table in this case. My problem is that i have duplicate logs with different sequence numbers and datetime so i use the max to...

ok here is my problem if you run this code see below you get the result which is incorrect

as the final result should be 60 and not 1860 for...

Hi guys, thanks for the reply. i;ve set up both logs and i will be able to see what other information its going to provide me with when the package...

hi, yes i see that my self and fixed it, No worries regards the reply. the code you gave me works fine now, many thanks.

Hi am getting this error when i run this activex script. "invalid task result value"

Here is my script , it works fine and downloads the file but i get this...

I tried that, and it does not work, your call to the procedure takes in date like a string,

EXEC AddSeconds '2006-09-06 09:10:03.000', '2006-09-06 11:13:21.000' 

But you've defined these as datetime

CREATE PROCEDURE...

Hi  John,

Here is a sample data whats in each column

idle_duration  .000763

idle_time        .479976

When i create a new column based on this data it formats into a normal datetime data...

Hi guys.

Thanks very much for your help with this, i would have found it very dificult to figure out on my own.

I've one last question, my table detials are as...

You say in your scenario  you get new data each month, do you get a new file or you get new data added into a file, base your update on...

I put the script into a ActiveX Script Task in a DTS package, and was getting a errror,

How do call the script from your DTS package ?