Viewing 15 posts - 1 through 15 (of 132 total)
Brilliant. I had no luck with the package but I made another Agent job that only runs the PowerShell commands on an existing spreadsheet.
Nothing opened, Excel starts in background. Kill Excel...
March 17, 2017 at 4:02 pm
Ok - I found that. Add a Reference. 15 or so years ago I was writing VB 5 apps. I don't know what I'm doing in this .Net vb editor, but...
March 17, 2017 at 3:04 pm
I found a post where someone says they are able to edit Excel from a Script Task: https://www.sqlservercentral.com/Forums/FindPost1553479.aspx
In their VB code, they have Imports Microsoft.Office.Interop.Excel
That is not...
March 17, 2017 at 2:58 pm
Yes, I did. In the package and also the Job's Execution Plan options. I also tried a Operating System Job and called dtexec from the x86 folder.
I created a...
March 17, 2017 at 12:51 pm
Yes, the service account running the Agent is a domain account and is also an Admin on the server. All files involved are local to the server.
March 17, 2017 at 11:53 am
The SQL Server service account is an Administrator on the machine.
All the files are on the SQL Server. Yes the folder is shared and yes I'm using UNC paths.
March 17, 2017 at 10:13 am
Sorry - topic should be Upgrade to 2012.
September 27, 2016 at 2:55 pm
Changing the service accounts through the Configuration Manager worked.
Thank you very much.
November 6, 2015 at 8:13 am
I'll have to do that after hours when the app is idle. I'll have to change it to the built in Network Service account then back. The services...
November 5, 2015 at 12:16 pm
Even if I back up to a local drive, I can't copy that file to the network.
November 5, 2015 at 9:15 am
Yes, using SSMS 2012. I used service.msc to change the service login. And yes, the account running SQL Server and the Agent have access to the network share....
November 5, 2015 at 9:14 am
You are right. I WAS trying to get a Boolean return from CASE before I came up with
(case when @get_date <= '06/04/2015' then 'R' else 'Z' end)...
June 8, 2015 at 11:47 am
Yes indeed. But I have to rely on our SysAdmins for that. Besides my being completely ignorant about today's hardware, it is their domain. The last time...
May 8, 2015 at 1:51 pm
Back online and all better. Thanks much for your time.
May 8, 2015 at 10:39 am
So I restored the full and all the logs I have and the dbcc ran clean. I just looked and the problem table has more rows in the live...
May 8, 2015 at 8:50 am
Viewing 15 posts - 1 through 15 (of 132 total)