Viewing 15 posts - 541 through 555 (of 5,109 total)
So does the USER not have permission to SELECT on the schema? If you need a USER/ROLE to be able interact with a new object, you normally set that in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2020 at 9:10 am
I can tell you from my experience with it, I saw several issues which timewise prevented us from being able to migrate to the Catalog once we upgraded SQL...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2020 at 8:57 am
And before anyone asks, the customer whose packages I was working on, when I've pushed them towards migrating their packages to the SSIS Catalog?
"We've got to much other work...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 26, 2020 at 9:22 am
We personally use Subversion at the office. It's fine for other Visual Studio Projects, and VSCode, however, it isn't great with SSRS and it's literally awful with SSIS. Unfortunately I'm...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2020 at 3:21 pm
You're not going to want to use a Flat File Source for this. You're going to (very likely) want a Script Component, and will need to write your own code...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2020 at 10:07 am
How do you know when one data set begins and another ends? Is the first line always a different dataset to the rest, or could you have something that looks...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2020 at 9:09 am
Is that a statement, or a question? It reads like a statement, but ends in a question mark.
What are you actually after here? Are you looking for table names that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2020 at 3:35 pm
I just re-read this ….. "only use numerical types for maths"??????? how about a foreign key to person.status - if there are only 3 statuses then tinyint…. massive storage...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2020 at 10:01 am
Staging tables - always...
but i'm sure Joe celko could help you out on the ISO standards for field lengths of things like names(seriously who has a varchar(80) name)
Joe will...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2020 at 9:32 am
are we allowed to post links to "let me google that for you" ? lmgtfy.com 🙂 🙂
I've posted a lot of questions in the last few days relating to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2020 at 2:52 pm
Little bit of amusement for you all. Was going through some old processes, that out date me at the business, they're being "questioned" (aka, people have forgotten what they asked...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2020 at 11:30 am
Sounds like the SQL Server Agent doesn't have permissions to do what ever you're asking it to do. For all those scenarios, the package would be using the same credentials...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2020 at 9:30 am
I'm using 2012.
SELECT SYSDATETIMEOFFSET() AT TIME ZONE 'India Standard Time' AS [FullISTDateTime],
convert(time, SYSDATETIMEOFFSET() AT TIME ZONE 'India Standard Time') AS [ISTCurrentTime];
This returns incorrect syntax near 'TIME'
AT TIME ZONE was...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2020 at 8:58 am
Note, as well, that many places that use EST also observe DST, meaning that it's not always UTC-5, but sometimes UTC-4. If something like this is important, seems you should...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 20, 2020 at 9:29 am
If you're using SSIS, I assume Visual Studio, you need to download and install the 32bit version. Visual Studio is still only a 32bit application, so only supports the 32...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2020 at 4:52 pm
Viewing 15 posts - 541 through 555 (of 5,109 total)