http://www.microsoft.com/sql/downloads/trial-software.mspx#EIB

or is the package build with a different version of sql server bi studio?

I would check the tables involved for inserts if there is a column not large enough to hold the default value you set in create table statement

use the merge join from the toolbox to put the 2 sources together

it does most likely reset because the output of the task that flows into this is different data type

not sure if that is what you mean but if you right click on your database server there is a report "serverdashboard" where you can see your configuration difference from...

its an advanced option named 'SMO and DMO XPs' try

sp_configure 'show advanced options', 1; reconfigure; sp_configure 'SMO and DMO XPs', 1; reconfigure;

the agent is not part of express editions

it does not have to be the complete table scripts if you can provide the query, execution plan and any possible indexe on the tables you are accessing with the...

query, table structure, execution plan a little more info would help

yes it comes with the standard check your setup again it should be with the client tools

The difference is that a clustered index sorts the data of the table physical so it's more efficient on columns that are searched alot or you try to get ranges...

It can... it's up to your setup and what you are trying to accomplish with it. There is a whitepaper that might give you some more insight about it

you could try to create a new user and add him to the local administrators group, log in as the user and try to uninstall again

looks like they are right and not the root of the problem. When you uninstall and get the error doesn't it give you a link to an error log or...