That’s an error on my part. The original Json is valid and gets processed correctly except for the nested data. I can’t share the original, unfortunately.

I guess my question boils...

There should only be one record for each file in the Media table, and there could be several hashes for each file. The complexity occurs when another import is conducted....

No, it will be one-to-many in most cases.  For some of these files, only the MD5 has was generated, but for others the SHA1 and PhotoDNA hashes were also generated...

The only way to determine whether an insert or update is needed is the presence of the MD5 hash in the Hashes table.  If it already exists, then the corresponding...

I figured it out.  You just have to set the SQLSourceType to Variable, and select the variable from the SourceVariable dropdown that appears.  Simple, once you know the option exists.

I figured it out earlier this morning.  You're exactly right.  That task had more than one avenue to it, and I had neglected to set the constraint to OR (any...

I had thought of that, but was hoping there was a way to do it and stay consistent with the template.  Thanks!

I take your point on the sample not being consumable.  

Thank you both for your suggestions.  I'll give them a try.

tbl_devices
device_uid                                                       ...

I actually am a domain admin, but I got it working.  It seems that for some reason it kept choking on the name I was using.  For example, TEST would...

So what I have looks like this:

Node 1 - LFSQL01
Node 2 - LFSQL02
Virtual Cluster - LF_FV_CL
SQL Cluster - LF_CL_SQL

All of the above are valid...

So this would be the name of the server I'm setting up the node on (in this case, it's the first node in the cluster)?

Yes, those assumptions are correct.  So, as I assumed, the cluster and its witness have no bearing on the sql mirroring at all, correct?  The mirroring, which I'm just setting...

To clarify, I use a query that specifies the schema to be used and this will return results, but I still can't get a list of tables. Does this...

Caching is not set up for this dataset.

I've run the report both in BIDS and in the report manager.

The dataset is using a stored procedure, and the parameters...