Viewing 15 posts - 3,616 through 3,630 (of 13,855 total)
Once the varbinary data has been SELECTed, what do you want to happen to it next.
Using poorly defined terms like 'read' and 'extract' does not make it clear exactly what...
May 21, 2019 at 2:53 pm
What do you wish to read it with, or how do you wish to process it?
May 20, 2019 at 5:37 pm
Hi Phil, I can assure you I did a google search before reaching out to the forum. If you can't assist with the inquiry, then please don't insult users...
May 20, 2019 at 5:33 pm
Which kind of raises the question of why he would need to have different permissions in access vs whatever other application. Or if there are only certain tables he needs...
May 17, 2019 at 7:49 pm
ZZartin wrote:You can explicitly deny write access to his specific login.
Wouldn't that also (badly) affect his rights in GP?
Yeah the deny on his personal...
May 17, 2019 at 7:28 pm
You can explicitly deny write access to his specific login.
Wouldn't that also (badly) affect his rights in GP?
May 17, 2019 at 7:17 pm
Out of interest, what is stopping him from connecting right now?
May 17, 2019 at 7:06 pm
I'm dating myself here, but:
Bill or George! Anything but Sue!
I just noticed this in one of the OP's earlier posts – maybe it's what triggered Steve
And I could use...
May 17, 2019 at 6:25 pm
What is the text of the error message you receive when running this?
May 17, 2019 at 6:03 pm
Thanks, But my original question is not about how to use the tabs from advanced step about success quit, and fail continue etc. I know all those. It is...
May 17, 2019 at 5:42 pm
It's time for you to do some work yourself, rather than relying on me to spoon-feed you with every single detail.
May 17, 2019 at 4:38 pm
Thanks, I know the condition and the process, but how can I construct the sql to let it know if it is 0 then on success, if 1 failure....
May 17, 2019 at 4:15 pm
I like Sue's approach but honestly, I'd avoid the LIKE. If this changes, it would likely be quicker to just update all rows inserted.
Sue?
May 17, 2019 at 4:00 pm
No code required. It's in the Advanced properties for the step.
May 17, 2019 at 3:48 pm
Viewing 15 posts - 3,616 through 3,630 (of 13,855 total)