Viewing 15 posts - 10,576 through 10,590 (of 13,874 total)
Can you provide us with DDL & sample data that will allow us to replicate this?
July 31, 2012 at 1:27 am
ColdCoffee (7/30/2012)
DECLARE @FilePath VARCHAR(100)
SET @FilePath = 'C:\Users\abcd\AppData\Local\Temp\Temp.txt'
SELECT REVERSE(LEFT ( REVERSE(@FilePath) , CHARINDEX('\',REVERSE(@FilePath))))
Instead of finding the...
July 30, 2012 at 11:26 am
Doesn't the execution plan give you any clues as to which index it is using?
July 30, 2012 at 4:16 am
One option you can consider is to use Dynamic SQL to script out the "SET part in UPDATE" for the 26 columns
But you have to ignore the computed columns, identity...
July 27, 2012 at 12:47 am
Can OdcFlag ever be NULL?
July 26, 2012 at 5:39 am
DerbyNeal (7/26/2012)
My SQL 'Table1' needs an update to a single column 'STCount'. The update needs to be applied
grouped by 'Sales_Resp', 'Sales_Order', 'Sales_Type'.
So,
'Sales_Resp', 'Sales_Order', 'Sales_Type', 'STCount'
TWells, 123, 4, 0
TWells,...
July 26, 2012 at 5:37 am
July 26, 2012 at 5:29 am
In your dataflow, add a Conditional split to split the data stream into three outputs.
Each of the outputs will go to its own file destination.
July 26, 2012 at 4:47 am
Sean Lange (7/25/2012)
Phil Parkin (7/25/2012)
July 25, 2012 at 10:39 am
That's a good informative post.
Have you isolated the part or parts of the package which are taking a long time? If not, it might be worthwhile adding some logging to...
July 25, 2012 at 10:34 am
WILLIAM MITCHELL (7/25/2012)
what should the expression return if ColA is not null? if the desired result is ColA, then how aboutCOALESCE(ColA,ColB,ColC,'Other')
COALESCE is not an SSIS function, unfortunately.
July 25, 2012 at 7:18 am
Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong word 🙂
July 25, 2012 at 7:14 am
ChrisM@Work (7/25/2012)
Don't forget that TOP is meaningless without ORDER BY, and...
July 25, 2012 at 5:35 am
Jeff Moden (7/24/2012)
SGT_squeequal (7/24/2012)
you could achieve your reslutls by using patindex
PATINDEX('%[0-9]%',col1)=0
if there is a value between 0 and...
July 24, 2012 at 5:30 pm
Viewing 15 posts - 10,576 through 10,590 (of 13,874 total)