Viewing 15 posts - 3,136 through 3,150 (of 5,111 total)
September 15, 2017 at 8:31 am
September 15, 2017 at 8:02 am
Hi Folks,
I have a login with 'public' server role and mapped to many databases . ...
September 15, 2017 at 6:56 am
I can query [SSISDB].[catalog].[executions] to find when my packages...
September 15, 2017 at 4:12 am
When using dt_str, you need to specify the code_page; normally this is 1252. Have you used the correct one?
September 15, 2017 at 4:10 am
September 15, 2017 at 2:10 am
You need to ensure all the objects on your report line up. If you have multiple tablixs, they need to all have columns of the same width. If you have...
September 14, 2017 at 3:44 pm
Nevermind me, miss read 🙂
September 14, 2017 at 3:02 pm
Why have a schedule another process to check for the existence of something, and then run the package? You can run SSIS packages from Agent, then there is no need...
September 14, 2017 at 9:27 am
Sounds like the Server could not authenticate the Login. Most likely the SQL Server couldn't reach the Domain Controller to authenticate, thus "didn't know" if the user had permissions.
September 14, 2017 at 8:30 am
This is one solution. you don't need to do it in 2 CTE's, you could do it in one, but split it for readability:--Put the Places in...
September 14, 2017 at 3:57 am
Can the following accounts be ignored for password rotation;