In the choose datasource dialog, clear the Use Query Wizard checkbox. After you choose your datasource you will go directly to MSQuery. Click the SQL button and enter your sproc...

In the pivot table, you can create a grouped store field and only include the stores you want in a particular group. If you make the grouped field a page...

In the source dialog of the import wizard, it will allow you to type the IP address of the server.

Hi,

The wizard should prompt you for the source and destination database connection properties. If you can successfully connect to your local server, the source, that should be saved with the package.

It looks like SQL Server 2005 comes with the development environment, it's called business intelligence development studio.

I guess I'd join with a subquery like

SELECT DISTNCT vendor_name FROM VENDORS

Or create a similar view in the DB and join with that

Hi,

Don't feel bad, I hate dealing with security and am probably one of the least qualified people to answer this. But I know that you have to create a login,...

Hi,

I've had this problem with the jet driver when creating linked servers to excel files. It would only work when the file was on a local drive. Since you connecting...

When you schedule the job it runs under SQL Server Agent's security context. Check the account it runs under and make sure it has permission to access the network drive.

Try attaching the mdf to another instance of SQL Server. I've had this happen where the original instance expects the ldf file but a new instance will create a new...

You don't have to assign the values programmatically. In the table designer, add a column with data type int then you can set the identity property to yes. By default...

I've done this before with a correlated subquery.

Assuming you have an identity column named ID and columns FirstName, LastName,Zip for which each combination should be unique. You could run:

DELETE FROM...