You can browse to the desired event handler using the Package Explorer tab.

Better ask in open source forums. This...

I don't think you can create a package in...

The variable part is unnecessary. You can directly configure the connectionmanager using the XML config file.

If you go to package configurations and go to the wizard, make sure you select...

What tasks do you use in the package?

The index part in the name columnstore index can be a bit misleading. It doesn't...

Nice question about something I will never ever use 😀

Eric Mamet (6/6/2012)

---

I suppose I could.

If I have to modify my package, I might even be tempted to simply store the configuration database connection string as a variable and...

I don't really see the issue.

Every component has an error path. You combine them with a...

ACinKC (6/6/2012)

---

michaeljharper (6/5/2012)

---

On balance it seems the best bet is to apply for jobs when I graduate and get some experience in the field, I'm pretty sure many companies provide...

I can't really think of a better way to do this.

In such a scenario I wouldn't use environment variables but an XML config file.

You can specify this XML config file in the jobstep.

You can write the header row once manually, and configure the flat file connection manager to not have a header row.

To wrap it up:

I changed the query so I don't join on the Date dimension but I filter on OrderDate directly, as Kevin suggested. I created a covering index by...

Very interesting question, but those answers were hard to read 🙂