Viewing 15 posts - 8,866 through 8,880 (of 9,720 total)
Okay, the Execute SQL Task might be the way to go. Since your suggestion didn't seem to like me, I tried adding a Lookup to the first pipeline (right...
April 8, 2008 at 11:12 am
Okay. Just verifying. It never hurts to check every angle just to be sure. @=)
April 8, 2008 at 9:14 am
Not necessarily. What about the difference between signed & unsigned integers? If you have columns in your flat file connection defined as unsigned, this could be a problem.
Of...
April 8, 2008 at 8:31 am
Here's a question, what is your mapping on the Flat File Connection set up as? Is it set to a datatype that doesn't allow negative values?
April 8, 2008 at 8:07 am
BETWEEN has a very nasty habit of dropping records. I don't use it at all. I prefer Greater Than / Equal and Less Than or the reverse. ...
April 8, 2008 at 7:58 am
Frank,
Hmmm. Multicast doesn't like being put after my Merge. It comes up with a totally blank screen on both sides of the divide. Apparently it can't see...
April 8, 2008 at 7:54 am
Actually, I think Matt just hit it. I don't know why I couldn't see that. It's sitting right in front of me.
DOH!
Thanks, Matt. I think that'll work.
As...
April 8, 2008 at 7:50 am
Honestly, it sounds like the function is simply not reaching the first statement. It sounds like it's always evaluating the ELSE when other people run it.
Which doesn't make sense...
April 8, 2008 at 7:37 am
Michael,
You've almost got it.
I don't want to use option 1. I have too many records and I want to keep the column width down to what's necessary. However,...
April 8, 2008 at 7:34 am
Ann,
Can you post the table structures and some sample data for each table? This would help us help you test it.
April 8, 2008 at 6:31 am
And there's no actual physical table by the same name that might have different values than the function uses?
EDIT: And have you tried the stored procedure without a CTE? ...
April 8, 2008 at 6:12 am
Unfortunately, since I don't have the table structure you do (or the data), I can't test this. Have you verified the Execute permissions on the Function?
And is there another...
April 8, 2008 at 5:53 am
Given what BOL says about functions and variables, Frank's statement makes sense to me. Try building your function SELECT as a dynamic SQL Statement.
Do you know how to do...
April 8, 2008 at 5:32 am
Oh, and it just occurs to me. Don't import the data. Use an Execute SQL Task on the Control Flow. Easiest and simpliest way to do what...
April 8, 2008 at 4:42 am
FYI, Microsoft is threatening to discontinue the version of JOINing that you just posted, so you might want to update it to the format most people use these days. ...
April 8, 2008 at 4:40 am
Viewing 15 posts - 8,866 through 8,880 (of 9,720 total)