Viewing 15 posts - 76 through 90 (of 257 total)
I'm late to the party but I do send scheduled emails with HTML formatting using SSIS.
It's a bit involved since I need to use XML to create the table and...
November 15, 2016 at 10:01 am
Grant Fritchey (11/15/2016)
VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.
Personally I like the NVARCHAR(1) fields....
November 15, 2016 at 9:56 am
I'm a fan of Notepad++ and the Poor Man's T-SQL Formatter. While I could spend the time to make pretty code I'd much rather take my messy working code and...
November 15, 2016 at 9:42 am
Google being Google means the preferred method is using their APIs and components. Which means they would need to be installed on the server running the process.
I did find a...
October 10, 2016 at 11:44 am
Phil Parkin (9/28/2016)
My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option.
I'm interested. Can you explain why, please, in a...
October 3, 2016 at 8:40 am
Using the SSISDB catalog requires project level deployment. That's something to consider when researching this. For companies that have been doing package level deployment for years this is going to...
September 28, 2016 at 8:58 am
I'm curious why you don't like nested REPLACE statements and why you feel that a single large expression would be better than the very simple expressions Luis provided?
August 31, 2016 at 9:21 am
GilaMonster (8/23/2016)
Luis Cazares (8/23/2016)
Gail, you just made my day with this answer. http://www.sqlservercentral.com/Forums/FindPost1811748.aspxI can't stop laughing. 😀
I was fully expecting to get a reply like "Tried that and it won't...
August 23, 2016 at 1:02 pm
Short answer - You can't. Microsoft removed this from Visio 2013.
Longer answer - If you can get a license for Visio 2010 Professional you can still do database diagramming.
Here's a...
August 11, 2016 at 11:36 am
One of the DBAs here refers to this as 'landfill data'. It's especially prevalent when reorganization happens and no one knows why the data was created but no one wants...
August 9, 2016 at 7:35 am
At the package level you can do it from Project Properties, debugging.
I don't have a package with a configuration file handy so I can't point you to where that would...
August 3, 2016 at 9:57 am
The standard question is "Does the account running the package have access to that file?" It's just one of those things you have to ask.
The next one is whether or...
August 2, 2016 at 10:53 am
This is pretty basic update/insert stuff.
Stage the data.
Update existing.
Insert new.
Rather than force it all to happen in SSIS I prefer to use a data flow to get the staging data...
August 1, 2016 at 2:10 pm
ChrisM@Work (7/25/2016)
Alan.B (7/25/2016)
Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:
[Gender] varchar(100) NULL,
It's fine! I've seen NVARCHAR for gender...
July 25, 2016 at 9:47 am
I've found it's time to leave when I stop getting the opportunity to learn new things. If I see all the new projects being assigned to other people and get...
July 25, 2016 at 7:44 am
Viewing 15 posts - 76 through 90 (of 257 total)