Reported as spam.

I'm not sure about your cast error, but here's an example of a script source that I wrote to pull database users from an Oracle instance. Hope this helps...

#region...

Is the connection manager parameterized? It may be that it works in BIDS because your parameters are filled out, but the package may not have the parameters configured on...

reported as spam

OK, then we'll need to use a conditional check for ISNULL on each column...

(ISNULL([Copy of F21]) ? 0 : [Copy of F21]) - (ISNULL([Copy of F18]) ? 0 : [Copy...

ReplaceNull() function usage based on your current example expression:

REPLACENULL([Copy of F21], 0.00) - REPLACENULL([Copy of F18], 0.00) > 0.17

You likely have a NULL value in one of your two fields in your expression. Try to use the REPLACENULL() function on both of your columns to set the...

Reported

OK, I think I understand you now. First off, the top part with the @myTable declaration and INSERT statement (with UNION ALL) is purely to set up an example...

I think I'm a bit confused on your requirements. If not, this is a pretty easy query. I've mocked up an example to show what I think you...

Well, this is more of a work around than a fix, but since you know the exact naming convention of the tabs, you could write a query to return the...

How are you populating the object variable that you are using for your collection enumerator?

So every iteration of the loop shows the variable containing this hidden tab value? You said your for each loop was configured to hit an ADO recordset. How...

Good article Phil. This is...

Can you post the links related to what you read about those folders?