Viewing 15 posts - 8,341 through 8,355 (of 9,715 total)
sriram979 (4/14/2009)
After getting all the error rows just keep an aggregate transformation task.
< blink > I didn't even think of that one. Thanks! I'll give it a try.
April 23, 2009 at 4:32 am
Check whichever port your endpoint uses. If it's the default (5022), check that. But there is usually 2 ports involved (ISTR) in the creation of endpoints, so make sure they...
April 23, 2009 at 4:14 am
Danb7183 (4/22/2009)The db_datawriter & db_reader gives the 'users' that are external to the domain all the rights that I believe they currently have (i.e. right to connect, add, delete, modify...
April 23, 2009 at 4:12 am
Glad I could help. @=)
April 21, 2009 at 11:13 am
Just went back to my old "Upgrading DBA skills to SQL 2005" book.
Before establishing a mirroring session, you must configure the communication mechanism through which mirroring will occur. This involves...
April 21, 2009 at 11:09 am
Ah, yes. You're absolutely correct on that. @=)
April 21, 2009 at 10:46 am
If it's an Active / Passive cluster, Steve, there won't be necessarily be multiple instances. One instance that swaps back and forth between the cluster as it fails is the...
April 21, 2009 at 10:34 am
Gift Peddie (4/21/2009)
April 21, 2009 at 10:30 am
Dan,
I'm a little confused. Are you trying to create logins on a user-by-user basis or on an application-by-application basis?
I previously thought you were talking about the later. Now it sounds...
April 21, 2009 at 10:25 am
Mackempete (4/21/2009)
April 21, 2009 at 8:54 am
DOH!
Ignore this problem / question, please. Sorry for wasting the bandwidth.
The developer who created the package forgot to put the destination connection strings in the config file, so on those...
April 21, 2009 at 8:22 am
Question, do you have your mirroring looking at the literal server name for the source? Or are you using the virtual cluster name for your mirrored source?
I'd say, at a...
April 21, 2009 at 8:07 am
Consider creating individual Domain User (plain vanilla, not admin) accounts and grouping them together in a AD Security Group. This way, you can manage all the actual group policies all...
April 21, 2009 at 8:01 am
All eight rows will show the same output. But package design was already completed a couple of weeks ago. I'm hoping to avoid major redesign given the dependencies on this...
April 13, 2009 at 6:11 am
This post is in the wrong forum. It should be in the T-SQL Forum, not SSIS. Ask the moderator to move it.
April 13, 2009 at 5:19 am
Viewing 15 posts - 8,341 through 8,355 (of 9,715 total)