Viewing 15 posts - 4,906 through 4,920 (of 5,109 total)
Would you mind pasting a link to where to data is located to on gov.uk (don't provide a link direct to the source, but the page which contains the download...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 23, 2016 at 9:22 am
Looks to be due to the "/" in the name is causing the rewrite rule to fail. 🙁
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 23, 2016 at 3:36 am
There will likely be more errors than just the one above. Check your Report Logs for an execution and copy all the errors out. Normally SSIS has a tendency to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 23, 2016 at 3:30 am
If the problem is still occurring, can you post the error you get?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 22, 2016 at 2:14 am
Although this works in your example, what is a "column" is blank. Does the file contain a blank line, or does it go straight column? Just want to make sure...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 21, 2016 at 3:59 am
crmitchell (9/20/2016)
I suppose you should be grateful you don't need to handle values formatted for France as well. i.e. 1.000.000,000.000 :w00t:
I never understand numbers that have multiple periods in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2016 at 10:00 am
Running IE as local administrator won't make any difference. You need to use a network account that has administrative privileges
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2016 at 8:27 am
That's because you're logged in as the user who has denied access. You can't changed a user's permissions, when that user has denied access.
Access the web address from an account...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2016 at 8:25 am
Eric M Russell (9/20/2016)
Hopefully none of is have printed reports in our desk drawers containing personal information about customers. :ermm:
Oh no, of course not... They sit on my desk!
Wait,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2016 at 8:15 am
For lack of better words, clearly your team did not give the user sufficient rights to access the report, regardless of what they might say.
Ensure that the user has access...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2016 at 7:15 am
If you're deploying to multiple environments, why not "parameterise" the connection string? Then you can simply pass the appropriate connection string parameter for the environment you are on.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2016 at 3:35 am
Looking at your two examples, can I assume that the date at the end is always in yyyy_MM_dd_HH:mm:ss format? If so, this would work:
Create table #examples (string varchar(100));
Insert into #examples...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 19, 2016 at 9:45 am
One thing you weren't really specific on is if a user has a email in column 1, and then appears in their (or someelse's) email 2. I've gone with if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 19, 2016 at 2:33 am
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 16, 2016 at 9:59 am
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 16, 2016 at 7:30 am
Viewing 15 posts - 4,906 through 4,920 (of 5,109 total)