Koen Verbeeck (7/30/2014)

---

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

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

Koen Verbeeck (7/30/2014)

---

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

I added calls to MessageBox before each statement in...

Sure! Though note that the DataFLow task fails just before this code begins to execute:

/* Microsoft SQL Server Integration Services...

SQLRNNR (7/28/2014)

---

I like Koens suggestion.

I have seen that error due to receiving too many columns for the defined script component or for receiving data too large for the output defined...

Evil Kraig F (7/28/2014)

---

Check to make sure they didn't alter your row terminators. IE: CR/LF became LF. I usually see this when an entire document loads up as...

I went even further: I disabled the current dataflow then...

Jeff Moden (7/28/2014)

---

gbritton1 (7/28/2014)

---

Jeff Moden (7/28/2014)

---

g.britton (7/27/2014)

---

Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday'...

Jeff Moden (7/28/2014)

---

g.britton (7/27/2014)

---

Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday' or 'IsWeekend' as...

I'm not sure what that means, but my philosophy is to let the business tell me what their fiscal periods are and give me the data in a spreadsheet. ...

Why use formulas at all? I just get the business subject matter expert to give me spreadsheet each year with the values filled in. I bear no responsibility...

You've given far too little information to answer your question.

For example:

1. Do you have specific, measured performance problems with specific queries today against your table?

2. What...

another user deleted the rows