Viewing 15 posts - 3,991 through 4,005 (of 4,272 total)
Right! That was the exact path I was thinking too. He might put a data reader on the pipeline between the lookups and see the data flowing and...
July 21, 2009 at 2:39 pm
My thought is that is a fantom error, because in reality when the package is opened, it CAN'T decrpyt the credentials for that connection (from your development work) and therefore...
July 21, 2009 at 2:35 pm
That is probably the easiest way, but if you are asking about a cluster you have to fail the cluster over to each node and re-run it because they all...
July 21, 2009 at 7:47 am
What error?
And how many rows are in [ACDB].[Linkedable703].[dbo].ac_Categories?
If it is very many you are incurring a HUGE penalty every time the trigger is called.
CEWII
July 20, 2009 at 4:14 pm
The issue I have seen with SSIS and transaction is two different pipelines in the dataflow can block each other, they do not exist in the same locking space. ...
July 20, 2009 at 4:09 pm
I do think the questions are getting worse, mainly because people post without searching first, like their problem is always going to be the first occurrence of something..
What...
July 20, 2009 at 4:01 pm
What version of SQL do you have? It sounds like a subscription in SSRS. However, if you want to pass different parameters to each copy of the report...
July 20, 2009 at 3:54 pm
For an NULL row it will take probably 1-2 bytes per record to record the NULL, for a non-null row it will take at LEAST 16bytes for the pointer +...
July 20, 2009 at 1:16 pm
Still 500MB is pretty measly, if you are generally running that tight on space you are seconds away from something more dire that low disk space.. Find something a...
July 20, 2009 at 1:13 pm
Questions:
1. What is used for the connection manager for the package that points at the remote server, do you specify a username/password or is it set to integrated security?
2. What...
July 20, 2009 at 12:30 pm
{soapbox engaged} Is that really company policy or policy put in place by the DBAs themselves. Because most companies don't have a policy that sets the largest size of...
July 20, 2009 at 12:19 pm
I thought every developer edition from 2000 onward was configured with only shared memory turned on at default. You probably have to turn TCP/IP on as well as what...
July 20, 2009 at 12:10 pm
If the sproc has no errors it will return 0 automatically at the end..
CEWII
July 20, 2009 at 12:08 pm
I too am looking for some good guidance on this..
CEWII
July 20, 2009 at 12:02 pm
Viewing 15 posts - 3,991 through 4,005 (of 4,272 total)