Viewing 15 posts - 376 through 390 (of 1,353 total)
from elder versions (SQL Server 2003).
SSIS changed A LOT in the 2005 version. There is no more activeX script. I used to be able to do a...
April 19, 2017 at 8:19 am
it has few shortcomings
--from article
The inability to access package variables renders Package Parts pretty useless, actually
--reader comment
I think you meant to say, it has a...
April 19, 2017 at 6:59 am
For that reason, it's not really comparing apples to apples because with that same logic, who's to say your constraints ALSO don't get removed between environments too.
I'm...
April 18, 2017 at 6:40 am
As I said earlier, since, as you say, you like being the black sheep, there's likely no explanation I can give. I suspect if I could examine your system and...
April 17, 2017 at 11:42 am
Feel free to explain why a simple script as something like SELECT WHERE NOT EXIST or even MERGE would totally fail it's checks and still insert records WHERE IT...
April 17, 2017 at 10:12 am
I can give you a scnerio [sic] where I have no PK. I like being the black sheep.
I have had large tables where 15+ uniques are needed...
April 13, 2017 at 6:53 pm
Your lineage requirements are more complicated than mine. I do have some individual columns simple to record the ETL Process ID that updated them as they are critical one time...
April 7, 2017 at 7:58 am
I have also seen this before, unfortunately. At a previous place I had to deal with an architect who said keys on tables weren't necessary. No, there is not a...
April 3, 2017 at 12:59 am
It sounds like maybe you fellas selected only one answer?
I did miss the choose 2. I knew multiple choice was possible because of the check boxes versus the...
March 31, 2017 at 6:50 am
Will have to think about this more, but my first hunch is that this is just word play. If you search "Output Parameters" you get a clear answer from a...
March 30, 2017 at 7:30 am
"Never"? Again, that was the business term they used for...
March 8, 2017 at 1:48 pm
If that happens to be a reserved word, so be it. I don't go out of my way to avoid reserved words.
I never do this. ...
March 8, 2017 at 12:10 pm
You're welcome. I've also learned something else you both probably already knew. I've wondered why there was a required setting with the parameters. My thinking is "of course it's required,...
March 3, 2017 at 8:47 am
I'd be curious to hear more specifics about what issues you ran into. What type of setting were you using those params/variables for? Possibly a connection string?
Just...
March 2, 2017 at 8:13 am
I run Windows Authentication wherever I can. The control in a central location as well as a central enforcement of password rules is a significant benefit. I also like that...
February 23, 2017 at 8:58 am
Viewing 15 posts - 376 through 390 (of 1,353 total)