Can you provide us with DDL & sample data that will allow us to replicate this?

ColdCoffee (7/30/2012)

---

I use it mostly to parse out the file names from a long file path. Example:

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...

Doesn't the execution plan give you any clues as to which index it is using?

Can you describe what the problem is?

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...

Can OdcFlag ever be NULL?

DerbyNeal (7/26/2012)

---

Hi all,

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,...

Personally, I'd stick with OLEDB.

You might like to read this[/url] for attempts at comparisons.

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.

Sean Lange (7/25/2012)

---

Phil Parkin (7/25/2012)

---

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...

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...

COALESCE is not an SSIS function, unfortunately.

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 🙂

ChrisM@Work (7/25/2012)

---

This looks very much like a homework question, in which case Anthony's reply is a good place to start.

Don't forget that TOP is meaningless without ORDER BY, and...

Jeff Moden (7/24/2012)

---

SGT_squeequal (7/24/2012)

---

excuse double post i replied to the other post before seeing the link

you could achieve your reslutls by using patindex

PATINDEX('%[0-9]%',col1)=0

if there is a value between 0 and...