Andrew P (7/20/2015)

---

For some companies, for example those dealing in health, I'd need to know how old a client is on a certain date, to identify that I would need...

In my opinion, the first design you've had wasn't far off. I would do the following:

PAYMENT

PAYMENT_ID (INT, PK)

CLIENT_ID (INT foreign key to client table)

ACCOUNT_ID (INT)

DATE_OF_PAYMENT (DATETIME)

INVOICE_ID (INT)

PAYMENT_TYPE_ID (INT)

AMT_PAID (DECIMAL)

PAYMENT_TYPE

PAYMENT_TYPE_ID (INT,...

Phil Parkin (7/16/2015)

---

Some ideas:

1) Add a script task to conditionally delete the file before trying to import it.

2) Call a batch file to delete all files of 0 bytes before...

Async...

I also typically use a script task to send email. Have found the built in SMTP task to be buggy and unreliable.

Yes, the table should still be indexed...otherwise a table scan will be performed for all queries and you won't see any performance benefits from your partitioning strategy.

In my opinion you...

Apologies for the shameless plug, but have a look at the following blog post which will describe your issue and how to test potential solutions:

http://did-i-say-that.com/2015/04/16/mdx-testing-with-settostr-function/

pietlinden (7/2/2015)

---

I think you can, it's just that the interface is extremely unfriendly. (Another reason it works much better against a DW).

After posting this, I got off my lazy butt...

How about using a "junk dimension" for the free text answers? Your answer dimension could contain the "Other" option, but if something was entered as free text you could still...