Viewing 15 posts - 1 through 15 (of 65 total)
Thank you for your response Sue. I appreciate it.
I'm still getting reports from the old server even after disabling the SQL jobs that ran last night. I knew...
January 25, 2019 at 9:39 am
So that I can narrow down what fixes it, I've re-enabled the SSRS service but I disabled the SQL jobs that corresponded to the subscriptions. I'll find out tomorrow morning...
January 24, 2019 at 4:11 pm
March 29, 2018 at 10:35 am
March 29, 2018 at 10:16 am
Sorry...I should've posted this in the T-SQL section.
Anyway, while the ID is a number (stored as a varchar(15) data type), it's not always going to be the largest...
March 29, 2018 at 10:15 am
I did figure out an SSIS solution. The manual SSRS subscription blogs/posts I've found were confusing and I wasn't quite sure how to set them up. I'm going to come...
March 20, 2018 at 2:50 pm
Ok....After some more verifying of settings, it looks like I was trying to use the object variable in the ole db source container as a variable. Instead I need to...
March 14, 2018 at 2:02 pm
Rather than trying to explain what I meant by that, let me try and reword my original question...
How do I take the first value of the my variable named Recordset...
March 14, 2018 at 12:28 pm
I'm not using CAST() or CONVERT() anywhere in my scripts.
Turns out I had the wrong variable setup in the Variable Mappings section of the Foreach Loop editor.
March 14, 2018 at 11:50 am
I'm finding stuff like this...
http://geoffbi.blogspot.com/2012/04/data-driven-subcriptions-in-standard.html
...but not entirely positive it will work the way I need it to work. I'm going to tinker with the above...
March 1, 2018 at 3:36 pm
I've tried a few variations of this...
The File System task operates on a single file or directory. Therefore, this task does not support the use of wildcard characters to perform...
May 3, 2016 at 10:02 pm
@Ed and Jacob
Thanks for your responses. I love explanations as why things work and I'm all for making scripts run faster.
Thanks again.
John
December 16, 2015 at 1:59 pm
Phil Parkin (12/16/2015)
Try this:
select DATEADD(mm,-4,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))
Awesome thanks!
December 16, 2015 at 1:57 pm
After spending almost another entire day trying to force the idea to use a data flow task with a Script Component, I had to look for another method because I...
August 5, 2015 at 5:13 pm
I've followed the steps mentioned but I'm stuck on number 5. I can't find a straight forward article or how to on how to setup a Script Component as...
August 4, 2015 at 3:50 pm
Viewing 15 posts - 1 through 15 (of 65 total)