Good Stuff Man!

I wonder if this would work in 2005 w/ the default Surface Area Configuration...

Cheers,

Ben

this link might help...

http://ezinearticles.com/?URL-Parameters-Used-in-Reporting-Services&id=176858

-Ben

Have you tried the globals? In the expession builder you can see what's available...

The problem isn't in the DTS Designer but in the regular query windows in SSMS. So it goes like this...

1.) Open SQL Server Management Studio (SSMS)

2.) Open a query window...

All my warehouses I prefix with 'Warehouse' before the data base name. So for example if my source OLTP database name was 'BenIsAwesome' I would name my warehouse 'WarehouseBenIsAwesome'

Cheers,

Ben

When you deploy a report to the report server visual studio by default creates a folder named 'Data Sources' in the report manager and puts any shared data sources in...

You should be able to use Windows Management Instrumentation to find what servers have it installed and possibly this will give the name of the instance since it would be...

Shawn...

I believe that is incorrect. The join type (inner, left, right) determines from which table all the records being retrieved from not which table is specified first in the condition....

I would say it depends on your situation...mainly on size. Smaller scale stuff w/ less data and traffic require less isolation. From my experience I've always been running SSAS, SSRS,...

Good tips David...I like most started out putting the commas at the end of the column names but then switched to putting them in front for the reason stated by...

I haven't tried this but I would assume you could use the folowing statement...

delete top 2000 from *table

It's been a while since I've worked w/ Oracle but if I recall the statement below will get the schema name along w/ all the other details...hope this helps!

describe *table...

Good find...for others that want to do this could you list steps you took with the file names you modified?

Cheers,

Ben

Does the instance you are trying to add back in contain any reports? If so I believe you are going to need the encryption key. I've not run into this...

Make sure you don't have it open while trying to run the report...