Viewing 15 posts - 7,141 through 7,155 (of 9,715 total)
irobertson (10/20/2010)
One thing you might like to try is to pre-calculate the two correlated subqueries that you're using to generate criteria and hold the values in variables.
Also,...
October 20, 2010 at 8:14 am
I'd still like the OP to answer. Assumptions about this sort of thing are dangerous.
October 20, 2010 at 7:25 am
I'm a little confused. What exactly are you trying to map?
Are you just trying to show the "guts" of a SSIS package? Or is this something else?
October 20, 2010 at 7:18 am
Pitso,
You should be able to do it just fine using Parameters in SSRS, unless something changed in 2008 that I don't know about. I believe you make the value as...
October 20, 2010 at 7:15 am
Riiiggght. Quite a DUH moment for me here.
Bulk Insert Task doesn't work if the table has more or less columns than the file has.
To make it work, I had to...
October 20, 2010 at 7:10 am
Grateful to both of you for helping out. Thanks!
October 20, 2010 at 6:09 am
It was causing all sorts of errors for me, though. Too many to count. I was trying all sorts of variations on the expression.
LEN() was the magic bullet. I ended...
October 20, 2010 at 5:48 am
Chris Morris-439714 (10/20/2010)
October 20, 2010 at 5:20 am
Now see, I've tried the ISNULL(effDt) without the == TRUE and while it didn't "bleed", it did error out on me. But then again, I haven't tried the entire line...
October 20, 2010 at 5:00 am
Mitch Small (10/19/2010)
Thanks for your replys. I think what da-zero said makes sense as far as checking to see if the file exists before downloading it.
Just an FYI: This...
October 20, 2010 at 4:52 am
But if you aren't on the same server, does SSIS always skip past the Source and go straight to the Destination during Debug?
Or am I just seeing strange behavior?
October 20, 2010 at 4:49 am
Steve,
I don't think IF...THEN...ELSE works in SSIS. That's why I'm trying to use the ? : conditional. And it's not evaluating correctly...
I'm trying to format an 8 character string into...
October 20, 2010 at 4:43 am
Tom.Thomson (10/19/2010)
Some of the things to see or do on LZ:
I'm a little brain-dead this morning. LZ?
October 20, 2010 at 4:39 am
Bill_CCAC (10/19/2010)
October 19, 2010 at 11:39 am
Viewing 15 posts - 7,141 through 7,155 (of 9,715 total)