Viewing 15 posts - 1,111 through 1,125 (of 4,272 total)
I don't think I have all your answers but I do have some.
I don't believe named pipes can fix this, it is using the shared memory provider which is a...
August 12, 2011 at 9:38 am
Where to begin...
Isolation level only relates to databases, file sources don't count.
The out of the box transforms will not let you do it because they want to exclusively lock the...
August 12, 2011 at 9:22 am
BlueTiger (8/11/2011)
August 12, 2011 at 8:46 am
You might consider setting the MAX sql memory to something like 24-26GB and see if that resolves it. Keep in mind that if SQL does not have a max...
August 11, 2011 at 8:57 am
I generally avoid composite primary keys, however, it depends..
I almost always build the primary clustered index on the single field that will always be unique. If my primary access...
August 11, 2011 at 8:47 am
I would say no, using TSQL you could NOT get that data. It is contained within the contents of the package.
You could probably do it by using the DTS...
August 11, 2011 at 8:33 am
In many corporate environments you don't really have access to the drives directly either, since you are connected to a SAN. Virtual or not..
However, the statement that there...
August 11, 2011 at 8:17 am
Phil Parkin (8/9/2011)
Elliott Whitlow (8/9/2011)
August 9, 2011 at 9:36 am
You are very welcome. There are some things that are not real obvious and just having another set of eyes and ears can make all the difference.
CEWII
August 9, 2011 at 9:30 am
I agree Koen, this is a good methodology. The only thing better would be to be able to determine that there would be nothing to do in the first...
August 9, 2011 at 9:25 am
I have long been a fan of letting the database engine handle those kind of operations before they even get into the pipeline. For this reason I don't think...
August 9, 2011 at 9:18 am
SSIS tends to be a little sensitive to spaces at the end of fields, since it looks like you are using text for the locations you need to be aware...
August 5, 2011 at 9:13 am
Yeah, really easy, apparently nothing left for us to do..
CEWII
August 5, 2011 at 9:10 am
Do a google search on: BACKUP SERVICE MASTER KEY
Your passwords and other critical information stored in master will not be decryptable without doing this step.
CEWII
July 29, 2011 at 1:34 pm
Viewing 15 posts - 1,111 through 1,125 (of 4,272 total)