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...

+1. Dead easy once you know which column you need.

Still nice question.

asranantha (7/31/2014)

---

hi 64-bit ODBC client for MySQL driver not support in ssis 2012 (BIDS)version .i tried one more way in

using the MyODBC driver, the configuration UI has an...

patrickmcginnis59 10839 (7/30/2014)

---

Evil Kraig F (7/30/2014)

---

Good grief, guys. Hey Patrick, welcome to "the Swamp", grab a martini if the still's running.

This debate is going for... four pages now? ...

Anyway, if this SO discussion is going to endure any longer, we will reach 45,000 posts real quick 😀

Yeah, there is a big difference between systems...

gbritton1 (7/30/2014)

---

Good to know you're successful!

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...

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)

---

As long as we're talking about straight T-SQL commands, you should be fine. If you start trying to access objects...

gbritton1 (7/30/2014)

---

Out of curiosity, have you used agent to schedule packages from a project deployed to SSISDB? The reason I ask is because the Sql Agent Job GUI does not...

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...

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...

With a SELECT statement.

You can automate this through...

I just had myself a cup of caffeine 😀

Create a Subscription View (Master Data Services)

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,...