Viewing 15 posts - 3,136 through 3,150 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 8:02 am
Hi Folks,
I have a login with 'public' server role and mapped to many databases . ...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 6:56 am
I can query [SSISDB].[catalog].[executions] to find when my packages...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 4:10 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 14, 2017 at 3:44 pm
Nevermind me, miss read 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 14, 2017 at 3:57 am
Can the following accounts be ignored for password rotation;