Wayne,

Excellent job.

Thomas

I believe the admin access is needed to create ActiveDirectory information for the cluster like ServerName configured to the IP address. If your AD administrator can create those things before...

If you right-click a database in Management Studio and go to the Properties of the database, there is a Permissions menu choice.

You can Grant Permissions for a login to Delete...

read the Security Considerations on this link for this information.

http://technet.microsoft.com/en-us/library/ms179410(v=sql.105).aspx

thomas

You probably need to stage the data in a table, then use T-SQL as Source Component and write CASE statement in T-SQL.

Thomas

I am glad you found something helpful.

Thanks also for posting your solution because now other people can use it and Bing It! 😛

Thomas

yes

I have never seen that happen, so I am not sure why.

Sorry,

Thomas

yes, this guide should help you

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc

thomas

If you go to Tools menu choice then Options, you should see a Source Control on the Tree View on left.

On Plug-in Selection you should be able to choice TFS,...

You probably want to read SQLSkills posting from Paul Randall and Kimberly Tripp to understand the effects of what you want to do.

http://www.sqlskills.com/blogs/paul/

Yes, it sucks but on a cluster that is the case. It is for failover and usually cluster setups should have a new instance on a different cluster node.

The...

Yes there are, if you right click the connection in Management Studio and go to Properties then go to the general tab.

Of course, these are system settings that usually should...

If you are selecting to connect to a table in the OLE DB (or ADO) Source, try use a SQL Command instead and build the SQL yourself without the collate.

Not...

Wow, I was already formulating follow-up questions. You got me.

Thomas