I found another way of running this. I'm testing in query analyzer before running it in the ActiveX script.

The xls file is about 358 kb and contains about 1569 rows.

I...

I have the following code within the ActiveX: script:

sRptFileName = "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" & iRowCount1.Value & ".xls"

Dim vCsvFile

Dim vZipFile

Dim mcrZip

vCsvFile = "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" & iRowCount1.Value & ".xls"

vZipFile = ...

Thank you so much. It worked.

This is what I have in the step of the job:

DTSRun /~Z0x5E56B39F4C6708C1ED6526B79578EB7B15BFFE13F26DAD8967476E759E98E3C96741230F26D576E4DFC4C145DA3A3410241E31C1211AC65B9AFCF15A32B85B7F5295AA7589086A3C20CE37C279D6CE1FF20242170E978ECF820E68546B68A1D0EA7191D42C8AA2B4D907BBCC8BCEE0615E6789D35509D68A339062E83FBA9CBBD555A1258F0D55DE595FCD4ACDA5D356AD6A54

Does that look right?

I dug a little deeper and found the following error on the job history:

Executed as user: ITIC\itiadmin. DTSRun: Cannot create COM Server to load and execute DTS Package. Error -2147024770...

I dug a little deeper and found the following error on the job history:

Executed as user: ITIC\itiadmin. DTSRun: Cannot create COM Server to load and execute DTS Package. ...

In job history:

The job failed.The job was invoked by Schedule 88. The last step to run was step 1.

I right clicked on properties and looked under the steps tab. There...

It doesn't matter. They are identical except for the Id field.

Someone posted a response on another forum that worked perfectly...

select * from #amount where amountID in

(SELECT distinct coalesce(a.amountID, b.amountID)

FROM (select a.amountID, a.amount, num = (select count(*) from #amount a2...

Thank you so much for your help. That solved half of my issue. It turns out that the projects are created all the time. Is there a way to do...

I think maybe I miscommunicated.

In my sample there are 2 employees who have project EACQ6. One is at site 1 with 1.5 hours and the other is at site...

I need to do the following: Can a case statement help me here?

I have a table TABLE1. My company has 2 sites. This table contains employees with the amount of...

Can you please give me an example?

I found this query which works, but it updates all records that have a time.

UPDATE A

SET logout =

(SELECT TOP 1 logout =

CASE

WHEN b.logout IS NOT NULL THEN...

I came up with this. It works, but I'm sure it's not even close to being a good way of doing this.

[Code]

UPDATE #LOGTIMES

WHERE EMPLOYEEID IN (SELECT Max(EMPLOYEEID) FROM #LOGTIMES...