Viewing 15 posts - 4,096 through 4,110 (of 4,271 total)
I'll preface this with "I haven't had this exact issue myself", BUT, I think you can use the command line from your old job BUT you need to find the...
July 9, 2009 at 5:21 pm
I have a different question, is it your policy to store that packages in the file system and not in the "Integration Server" (msdb), if you stored them there then...
July 9, 2009 at 5:15 pm
It *could* degrade performance. I would try it and see. As far as I can tell, there is no REAL hard and fast rule on whether to go...
July 9, 2009 at 5:08 pm
Oliver,
Did you read answers to your previous post?
CEWII
July 9, 2009 at 9:43 am
Then the RIGHT('00000' + a.order_no,10)=b.order_no comes to mind. I also thought of something else, but I'm not sure I would do it, you could create a table that had...
July 9, 2009 at 8:52 am
I don't know about MS best practice but I can comment on this.
For code that is not going to be used by a computed column in a table, I would...
July 9, 2009 at 8:16 am
Why don't you build a stored procedure that only allows inputs of things you want changed and can check for extraneous characters in the inputs. The you just publish
EXE...
July 9, 2009 at 8:09 am
I am also getting the error but I've noticed that my replies ARE getting posted..
CEWII
July 9, 2009 at 8:06 am
How big are the tables? Are the lengths of the numbers in the table that doesn't have leading zeroes consistent?
Three thoughts, you can convert both to int with this CONVERT(int,a.order_no)=CONVERT(int,b.order_no)...
July 9, 2009 at 8:04 am
Don't you need to do some OCR before this is even slightly usable? A TIFF file created from a fax, espcially an incoming fax is just a graphic. ...
July 9, 2009 at 7:51 am
Well you could do it in a single but the case statement would be ugly and I think it would be more costly in terms of CPU and IO than...
July 8, 2009 at 8:45 pm
If File Type is a field from the database then you could use a CASE statement in the source select statement
Like:
RECTYPE = CASE WHEN [File Type] = 'SSA' THEN 'Y'...
July 8, 2009 at 8:39 pm
If File Type is a field from the database then you could use a CASE statement in the source select statement
Like:
RECTYPE = CASE WHEN [File Type] = 'SSA' THEN 'Y'...
July 8, 2009 at 7:17 pm
Excellent article. I particular like the "So, what should I use?" section.
I had a case where I had a process that used all table variables and to see if...
July 8, 2009 at 10:11 am
First of all your subject is sketchy, I didn't know what this was about until I opened it..
Second, I am unsure what you are asking could you clarify exactly what...
July 8, 2009 at 7:40 am
Viewing 15 posts - 4,096 through 4,110 (of 4,271 total)