In your table structure for Line you gave in your original post you specified LineID,PointA,PointB.

I don't see any RampID or PreRampID.

Please read the first link in my signature on how...

Check the execution log of Reporting Services.

It will detail how many seconds it did over retrieving the data and how many time it took to render the report itself.

What are the relationships by the way?

Which columns are related to each other?

Ask them about SSIS 🙂

I'd suggest you read up on how to join tables. You are referencing tables in your correlated subqueries who are aliased in another correlated subquery. This is not possible.

Example: in...

Your question isn't entirely clear, but I guess you can create a foreign key relationship.

I'm not a DBA, so I can't really answer on the accidental part.

However, the amount of knowledge on this site is indeed amazing, but don't let that scare you.

Don't forget...

Easiest question ever. It doesn't even matter which feature is being asked.

Enterprise has every feature, and developer & evaluation have the same features as Enterprise.

Ergo, no thinking needed, just select...

Spoon, this rings a bell. Is there some open-source variant called Kettle?

I remember using that in college (quite some time ago :-))

Sure? It might also show all the records loaded into the first buffer...

mario17 (10/22/2013)

I have some custom mapping to apply which has ~500 cases, does it worth to code it with CASE or probably I can do something more nicer, like use...

And why is that, if I may ask?

“all ETL tools should be tuned out of the box”

Right. I'm pretty sure a lot of SSIS packages out there use all of the default settings, but still get reasonable...

I thought you said redirecting error rows didn't work?

Try this:

"C:\\Folder1\\Folder2\\" + @[User::Site] + ".MDB"

I assume @[User::Site] is a string variable?