As Barry said, you were not clear on what you exactly needed. Since, you mentioned you have the table names, then I guess you need to fetch some kind of...

Well, you don't actually relate tables in SSIS, instead you create multiple data flows that transfer data from source to target tables with proper workflow order.

You will need...

There is an undocumented system procedure that executes any T-SQL query in all databases.

EXECUTE sp_MSforeachdb 'EXECUTE sp_spaceused'

Here is an article and a vb script that scripts the properties of all tasks in a text file. You can easily modify it by doing a search on...

Right click on the white space in the package window, go to Logging. Untick the value of all containers from the containers list.

josephptran2002 (2/22/2009)

---

How are you doing? Sorry to bother you Ramesh, are you ok? Did I make you mad about the way I ask you questions which relate to SQL? Because...

I guess, he probably meant to add a column to the table that will store the physical path of the image file.

Are you sure that the file "C:\Users\babygirl\accessdb\Ayawaso_East.mdb" can be accessed via windows file system?

Try creating & accessing the linked server using an windows system administrator's account.

So, what you really need to do is filter offices according to the parameter.

WITH AllDDS AS

(SELECT DDS, DEClearedDate AS ClearedDate, DECleared AS Cleared

FROM ...

And what do you want to show in the report when ALL is selected?

I don't think so this can be done within T-SQL using standard methods (exclusing OLE automation). What I can think of, you to do is to build an application...

Which login are you using to execute the...

Chris Morris (2/19/2009)

---

Looks like Ramesh has this sussed, but what do you get for this, as a matter of interest (I don't have 2k5 to play with right now)...

DECLARE @MyEnormousBelly...

Have you tried my previous suggestions? What script are you executing? I see a variable declaration error.

josephptran2002 (2/19/2009)

---

If I pick the office BO only, then it displays the report for BO Office ( that's right and I wish it to be like that). But if I...