Viewing 15 posts - 541 through 555 (of 5,111 total)
Nice reminder to those that use IDENTITY that it's supposed to be nothing more than an arbitrary number. 🙂
February 27, 2020 at 12:25 pm
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
February 20, 2020 at 9:29 am
Viewing 15 posts - 541 through 555 (of 5,111 total)