Viewing 15 posts - 8,881 through 8,895 (of 9,725 total)
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
BTW, BOL has this to say about Table Valued Functions:
Books Online:
Specifies that the return value of the table-valued function is a table. Only constants and @local_variables can be passed to...
April 8, 2008 at 4:25 am
I'll look at the proc in a moment, but in regards to getting your table valued function to run in SSIS, what T-SQL do you use to get it to...
April 8, 2008 at 4:20 am
Does it look like a Connection Manager issue?
If so, go to connections. Choose New Connection->SMTP (Connection Manager for the Send Mail Task). A popup box will appear. ...
April 8, 2008 at 4:18 am
Please give us an example of the data from each of the tables and the conditions you're trying to pull the data together with. It's hard to answer your...
April 8, 2008 at 4:13 am
Michael,
You're BRILLIANT!!
It took me a little more work at first, but given the way the task is executing right now, I really really like your multiple conditional split idea.
I've got...
April 7, 2008 at 11:29 am
BTW, I should add that I just got a look at the other developer's package and he has everything set to "Ignore Failure" on his package so he doesn't have...
April 7, 2008 at 10:26 am
Michael,
As much as I would love to do as you've just listed, I can't. I have things in my data such as FirstName of "Ace Insurance" and LastName of...
April 7, 2008 at 10:24 am
I have four servers, all of which have the same problem. It's not a server issue as far as I can tell.
March 31, 2008 at 3:52 am
Did yours get installed properly to begin with or did you have to manually install it like I did?
March 28, 2008 at 7:43 am
I have never figured out what the problem was. Even posted on Microsoft and got a lukewarm response. THough someone suggested the issue had to do with Temp...
March 28, 2008 at 7:08 am
Viewing 15 posts - 8,881 through 8,895 (of 9,725 total)