Viewing 15 posts - 2,416 through 2,430 (of 5,685 total)
Jeff Moden (10/25/2011)
As for the string manipulations of CLR, I agree but only in some cases. Several years ago, Matt Miller and I engaged...
October 25, 2011 at 6:08 pm
john-671083 (10/25/2011)
Thanks Craig, when I turned of the Mesh it all worked. Thanks John
My pleasure. Glad to help. I don't know Mesh itself well enough to answer why...
October 25, 2011 at 6:01 pm
Different queues will not operate in tandem. The broker overall doesn't operate by timestamps, but by queues. My guess is each of these structures have a different queue...
October 25, 2011 at 5:55 pm
jared-709193 (10/25/2011)
And then if you cannot prive it is a SAN problem, how do you prove it is an SQL problem?...
October 25, 2011 at 2:37 pm
Derive the column that you've swapped to characters as a replacement for itself, and setup an if statement:
[Column] == "NA" ? NULL(DT_WSTR, «length») : [Column]
Keep it as WSTR...
October 25, 2011 at 2:35 pm
Jack Corbett (10/25/2011)
October 25, 2011 at 2:30 pm
john-671083 (10/22/2011)
October 25, 2011 at 2:24 pm
Elliott Whitlow (10/25/2011)
October 25, 2011 at 2:16 pm
kiran23330 (10/25/2011)
Can Any one tell me how to force the package to fail when it is not found Envi variable???
Unfortunately no, but I can give you a way to end...
October 25, 2011 at 2:04 pm
Elliott Whitlow (10/25/2011)
I am very glad it worked out for you but I would strongly encourage moving away from linked servers in nearly all cases.CEWII
I'm afraid I'll have to disagree...
October 25, 2011 at 1:55 pm
drew.georgopulos (10/25/2011)
To administer a reporting services server?Must you be sysadmin?
To administer the server... in short: Yes. To administer the reports, no. There's specific security in reporting services that...
October 25, 2011 at 1:20 pm
kramaswamy (10/25/2011)
yeah definitely agreed Craig. Just posted that incase he's looking for something quick.What's this synchronous script component you speak of? Is that something new in 2008?
Nope, it's in '05....
October 25, 2011 at 1:09 pm
jared-709193 (10/25/2011)
October 25, 2011 at 1:01 pm
Duplicate posting. Please send all replies and responses here:
http://www.sqlservercentral.com/Forums/Topic1195900-145-1.aspx
October 25, 2011 at 12:36 pm
It's not that hard, it's a matter of doing a sub-query as a joined table getting the MAX() for each of the primary items, then rejoining to the primary table.
IE:...
October 25, 2011 at 12:35 pm
Viewing 15 posts - 2,416 through 2,430 (of 5,685 total)