Viewing 15 posts - 1 through 15 (of 77 total)
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...
December 4, 2019 at 7:14 pm
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....
May 27, 2019 at 8:37 pm
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...
May 27, 2019 at 5:14 pm
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...
May 27, 2019 at 4:56 pm
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.
February 5, 2019 at 7:40 am
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...
February 1, 2019 at 5:50 am
I had thought of that, but was hoping there was a way to do it and stay consistent with the template. Thanks!
January 25, 2019 at 7:08 am
I take your point on the sample not being consumable.
Thank you both for your suggestions. I'll give them a try.
May 22, 2018 at 12:19 pm
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...
December 13, 2017 at 10:00 am
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...
December 13, 2017 at 8:52 am
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)?
December 8, 2017 at 8:01 am
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...
October 27, 2017 at 10:21 am
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...
June 21, 2016 at 11:31 am
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...
December 11, 2015 at 7:27 am
Viewing 15 posts - 1 through 15 (of 77 total)