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

If you use the grouping() functions, you can do this without the temp table.

SELECT

CASE WHEN Grouping(ID2) = 1 THEN ID END AS ID

, CASE WHEN Grouping(Val) =...

It's probably easier to change your aggregate to a distinct count.

Count(DISTINCT Staff_Seq_Num)

You may also need to use another field if that doesn't give you the correct counts.

Drew