Viewing 15 posts - 61 through 75 (of 3,232 total)
Reported as spam.
May 18, 2016 at 8:13 am
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...
May 9, 2016 at 8:28 am
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...
May 5, 2016 at 11:25 am
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...
May 3, 2016 at 11:05 am
ReplaceNull() function usage based on your current example expression:
REPLACENULL([Copy of F21], 0.00) - REPLACENULL([Copy of F18], 0.00) > 0.17
May 3, 2016 at 10:28 am
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...
May 3, 2016 at 9:53 am
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...
April 29, 2016 at 9:47 am
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...
April 29, 2016 at 9:20 am
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...
April 25, 2016 at 12:49 pm
* collection enumerator = "ForEach ADO .NET Schema Rowset Enumerator"
How are you populating the object variable that you are using for your collection enumerator?
April 25, 2016 at 12:25 pm
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...
April 25, 2016 at 12:12 pm
What I learned then was that, in analyzing and fixing a problem with any application, there was usually a good reason for every technical decision.
Good article Phil. This is...
April 25, 2016 at 11:35 am
Can you post the links related to what you read about those folders?
April 22, 2016 at 2:52 pm
Viewing 15 posts - 61 through 75 (of 3,232 total)