I've gotten a little further

Step 1 query gets me this:

c_iD1 c_rep c_Date

11111 23 ...

Ok, I had to refer back to my actual code and you're right; Step 1 should be asking for a MIN DISTINCT c_dt. I've revised the mytable example code,...

Correct, it is not the PK. I should have adjusted the code to reflect that, but neglected to when I copy/pasted and just inserted my own example data.

I have provided the code and an example of the expected result set...so I am not sure what doesn't make sense? Maybe a step-by-step would help...it took me several conversations...

Hi, I hope this is what you wanted to see:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

Hi, I was not able to make it work from my system, however I did get it to work properly by putting the desktop file on the server where the...

Ok, I now see that the "Desktop" file workaround fixes a "save as" exception, and my exception occurs when opening the Excel file. I am going to convert my...

Hi,

Thanks again, it ran the script but wouldn't save:

"Exception calling "SaveAs" with "1" argument(s):"SaveAs method of Workbook class failed"

The script runs fine outside of job agent, it creates an...

Hi,

I haven't but I wouldn't think it would get to line 17 of the script (see original post) if Powershell was the problem?

Are you thinking that if I can...

Hi, Step 1 is to execute the SSIS Package (using 32-bit DTExec per your suggestion)

"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /DTS "\MSDB\SSIS_Pkgs\ExcelModifer" /SERVER sqlreport /CHECKPOINTING OFF /REPORTING E

The package contains...

Interesting, I tried that and now get this error:

"The process could not be created for step 1 of job...

The system cannot find the path specified" Step failed.

If I am...

HI, Thank you for your input and time!

I'm having alot of trouble (errors) getting it to run properly though. I had added my Powershell script to an "Execute Process...

Hi, I actually have this code working well now, however, I would love to change it to vb and put it in a pkg.

$objExcel = new-object -comobject excel.application

$objExcel.Visible =...

Thank you, I will give that a try, and update you if I can get the results I require.