Viewing 14 posts - 4,936 through 4,949 (of 4,949 total)
Toreador (11/4/2015)
Larnu (11/4/2015)
Asking if you would avoid calling an sp 1MyProc, the simple answer is yes, because you can't do it.
But you can do it - I gave you the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 4, 2015 at 3:14 am
Toreador (11/4/2015)
tripleAxe (11/4/2015)
I also agree with these comments above. If they give syntax errors then you have no choice but to avoid them.
You do have a choice - you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 4, 2015 at 2:16 am
There are clearly 5 rows in the create table script, if "all" the rows are returned, then all = 5.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2015 at 2:58 am
Thanks Resender.
I've included the script that one of the guys passed to be as well. I have a feeling he found it only, but there's no annotations to say where...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 14, 2015 at 4:08 am
happycat59 (10/7/2015)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2015 at 2:00 am
Apparently SSIS, and my PC needed a restart. I shutdown at the end of the day last night, and booted up this morning, to find it quite happy to find...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 9, 2015 at 7:26 am
Joie Andrew (7/8/2015)
Is the project running in 64-bit mode? For some reason I thought Excel support only worked in 32-bit mode.
32bit. i have a feeling that the error for running...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 9, 2015 at 1:52 am
Mohamed IDTTALBE (7/8/2015)
hidid you check if a sheet is hidden on your excel file ?
None of them are hidden.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 8, 2015 at 10:15 am
I got around this in the end, by setting the task to run in as an Agent Job. This isn't really the solution I wanted, as it's now on a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 4, 2015 at 3:32 am
What does the execution log tell you? It'll give both the taskthat the error occured on, and the error that was returned.
To view the log, expand the Integration Services Catalogs...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 26, 2015 at 8:29 am
Eirikur Eiriksson (5/23/2015)
Quick question, are you using absolute or relative path?😎
I'm defining the full address, with the server name, and directors, rather than the shared directory name.
I'm already running SSMS...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 26, 2015 at 1:54 am
Jack Corbett (5/22/2015)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2015 at 8:41 am
There's not on Standard, no.
I execute a stored procedure prior to the RS Execution, which another one of the DBAs we have made, which is as follows:
Create Proc [dbo].[UpdateRSOutputFile_sp]...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 20, 2015 at 9:58 am
That's great, thanks.
Having a further fiddle with your code, showed me that the literal string after the then is always returned as a varchar, regardless as to what the variable...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 14, 2015 at 3:44 am
Viewing 14 posts - 4,936 through 4,949 (of 4,949 total)