I think this is what you are looking for.

WITH Test(TestField) AS (

SELECT 'aaa'

UNION

SELECT 'abc'

UNION

SELECT 'bbb'

UNION

SELECT 'bcd'

UNION

SELECT 'ccc'

UNION

SELECT 'cccccc'

UNION

SELECT 'cccccccccccccccccccccccc'

)

SELECT *

FROM Test

WHERE NOT TestField LIKE '%[^' + Left(TestField,1) + ']%'

It basically...

I never said anything about adding square brackets. Those tell SQL to treat your filter as if it were the name of a single item.

You may want to put...

Set the DelayValidation property of your File Connection to True.

Drew

You're probably missing the space between the "WHERE" and your filter.

Drew

Instead of using "SQL command" try using "SQL command from variable". The variable would need to contain the entire SQL command rather than just the filter.

Drew

You should be using Package Configurations to read values from the dtsConfig file. Why re-invent the...

I've never done it, but this link claims that it is possible.

http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/d6052ef3-a5ce-46b2-a15e-c3200186fe55

Drew

Why would you want to? That's like building a table only with columns not with rows.

Drew

Have you considered using a view? That's also a way to reuse code, but it's still set-based.

Drew

In your "Lookup" transformation, you need to "Configure Error Output..." to "Ignore Failure" for the lookup error.

Drew

I don't understand why you're even using a UDF for this update. It looks like you should just be able to join your tables directly to perform the updates.

Drew

Maybe the problem is that you are using a cursor in the first place. Cursors are horribly inefficient and are rarely the optimal solution to the problem.

Drew

Here is a good example of dynamically changing the connection string to a server connection using the foreach ADO enumerator. It can easily be adapted to dynamically set the...

Just adding an alias isn't enough. The original solution assumes that the records are unique for MonthYear and Location within their respective...

You indicate no extension by ending your Regex with a period, e.g., "Filename*." The trailing period is optional if there is no extension, so it is usually omitted, but...