If you suspect bad data in your staging table, check to see if there are any non-null, non-empty values that are invalid dates:

SELECT DISTINCT [DateColumnName]

FROM [StagingTable]

WHERE [DateColumnName] IS NOT NULL

AND...

Have you considered using Service Broker? Not sure of your exact requirements, but it sounds like Service Broker might be of interest to you.

hth,

Tim

Not a lot of difference as far as efficiency. Where possible, I prefer persisted staging tables - I've found that it makes development and troubleshooting a bit easier.

hth,

Tim

You're using 2 different string lengths in your expression. Your NULL condition uses a 1-character string, but the WADAT column would be larger than that since '22.05.2009' is a possible...

Is it possible you've got one or more tasks disabled? They'll appear shaded in silver if they are.

It looks like your code sample is incomplete. However, I suspect that you're missing a .Value property when you reference the variables elsewhere in the code.

See the following URL for...

Sure... you can actually do a DISTINCT query on all items:

SELECT DISTINCT h.SOID, h.CustomerNumber, h.PoNumber

FROM SalesOrderHeader h

INNER JOIN SalesOrderDetails d ON h.SOID = d.SOID and d.ItemToSell = 'CAR'

This will return...

Hey Jack,

I finally figured this thing out. I found that what I needed to do was to use the Group Header function, but this is only available on the...

The query you've written appears to be valid. However, a better performing and more commonly accepted methodology is to use a JOIN rather than a subquery in a case like...

It sounds like you may have your SSIS package protection level set to "Don't Save Sensitive", which will not store any passwords and will prompt each time. You should...

Georg,

First, I don't see any connection information or the query string in your code. I assume you removed those for security reasons?

As far as the code, I would suggest...

Georg,

This could be due in part to how your script is written. Can you post some of the code (or at least pseudocode) from your script component source?

Tim

A couple of things to check. First, if the case of the data is different (upper versus lower or vice versa), you could have some issues. By default...

Jason, are you in a 32 bit or 64 bit environment? There are known issues with the 64 bit Jet driver. I doubt if that's the only issue...

Good article, and very good idea about planning ahead. This methodology takes more work to set up, but can save you hours or even days of work in a...