Viewing 15 posts - 2,206 through 2,220 (of 11,678 total)
Hmmm, seems difficult to do out of the box.
Maybe you could add some task after Task B that kills the SSIS process in some manner, but that seems quite dangerous...
July 31, 2014 at 12:50 am
SQLRNNR (7/30/2014)
Good Question.I do think the answer is a dead give away if you have familiarity with sys.objects though.
+1. Dead easy once you know which column you need.
Still nice question.
July 31, 2014 at 12:32 am
asranantha (7/31/2014)
using the MyODBC driver, the configuration UI has an...
July 31, 2014 at 12:26 am
patrickmcginnis59 10839 (7/30/2014)
Evil Kraig F (7/30/2014)
This debate is going for... four pages now? ...
July 30, 2014 at 2:06 pm
Anyway, if this SO discussion is going to endure any longer, we will reach 45,000 posts real quick 😀
July 30, 2014 at 2:01 pm
patrickmcginnis59 10839 (7/30/2014)
If its a fish, why are the solutions still working? Shouldn't they only have lasted the extent of a single meal?
Yeah, there is a big difference between systems...
July 30, 2014 at 2:00 pm
gbritton1 (7/30/2014)
Here's another thing that doesn't work as I expect:
While in VS, with my Master package in focus, I hit Ctrl-F5. VS does a build...
July 30, 2014 at 1:42 pm
Grant Fritchey (7/30/2014)
Koen Verbeeck (7/30/2014)
Grant Fritchey (7/30/2014)
Koen Verbeeck (7/29/2014)
Grant Fritchey (7/29/2014)
July 30, 2014 at 11:50 am
gbritton1 (7/30/2014)
July 30, 2014 at 11:32 am
There is no data mismatch.
The only downside is increased CPU usage (the data doesn't (de)compresses itself), but the advantages usually outweigh this.
The biggest advantage aside from disk savings are the...
July 30, 2014 at 7:30 am
If you want to execute packages from the project deployment model through the SQL Server Agent SSIS jobstep, you need to deploy them to the SSIS catalog.
The command line you...
July 30, 2014 at 6:39 am
karthik M (7/30/2014)
I am not still clear.Once I create the subscription view, how should i access that view from the user database?
With a SELECT statement.
You can automate this through...
July 30, 2014 at 6:32 am
Phil Parkin (7/30/2014)
Koen Verbeeck (7/30/2014)
Create a Subscription View (Master Data Services)+1 - beat me to it.
I just had myself a cup of caffeine 😀
July 30, 2014 at 6:12 am
You said your table is about 20GB. Suppose your data file is 50GB.
After page compression it is likely your table has a size of about 12GB. So you gain 8GB.
However,...
July 30, 2014 at 5:50 am
Viewing 15 posts - 2,206 through 2,220 (of 11,678 total)