No.

Re-install the BIDS portion from the SQL 2005 install first. This should fix the project type in Visual Studio.

Then, install the SQL 2008 tools.

This should also allow you to...

They are correct, I just tried it.

You can keep VS2005 installed and install VS2008. The RS project types can remain on your machine and it works fine (I am...

I may take you up on the co-sourced config-thingy. Not this week though.

I've also used environment variables, and setting the configuration values in the job agent, etc. It...

It's often the config files that I need modified during my deployment process. I have to pass off the deployment to an administrator that then has to change configuration...

An interesting solution, but I think you have a major replication task ahead of you. How much latency will be accceptable between the two servers? Is your database...

I recently had to do the same thing. I found a freeware command line utility called replace.exe that I was able to use to modify connection string information through...

1) Export the package to a file

2) Open the file with BIDS

3) Change the connection string

4) Import the package back onto the server

You cannot change the connection string in the...

Perhaps you used some characters that were filtered out in your post, but your connection string does not include a database name or a server name.

Also, is it possible that...

I do the same thing with xSQL Object - compare the database to an empty one to generate an entire DB script.

What are you doing that requires high-performance database object...

I don't think you have any control over it.

No problem.

Look up SELECT in Books Online and read the entire boring section. It's pretty useful.

Spend some time learning about doing SET-Based operations. Read some of Jeff Moden's...

Either your question is vague, or you have missed the obvious:

SELECT MyField FROM MyTable WHERE MyField LIKE 'ABC%'

Your syntax is wrong, the CTE comes at the beginning of the statement:

[font="Courier New"]use tempdb

go

create table #ids (id int not null )

; with MyCTE as

(select id from sysobjects)

insert into...

If the SQL Server you are using with the SQL Destination local to your workstation? The SQL Destination is a bulk utility that will only work on a local...

Service Packs are cumulative and include any previous hot fixes.

Post the DDL and the execution plans. I think the issue is probably in the function being called and possibly...