Same thing with me. Because I have sysadmin privileges I never had to worry about configuring access permissions to SSIS. The issue is allowing someone else to have that access...

Thank you.

The question still remains though as to whether SSIS can be accessed through SQL auth.

The auth. mode is greyed out on my conn dialog to SSIS.

I ran the following and got what I wanted (I think, need to look more closely):

Thanks!

Not clear how this works. For me, SSIS is installed on the default instance (no instance name), whereas the database engine is installed on a named instance. Could it be...

In our code base we do that...

Jeff Moden (3/19/2008)

---

Heh... I'd have never known... 😉 I only use temp tables (unless it's a UDF where I can't) and haven't run into a Recompile problem yet because...

What about using SQL 2000 tools to do the same thing? What system tables should I use?

It only shows up as Windows Auth. ONLY, greyed out as well, for me.

I wonder if this has to do with how SSIS was installed to begin with. I forget...

Perfect, thank you, this is...

I should mention, while we are on the subject, "INSERT EXEC" does work with table variables in SQL 2005!

This is something I only realized recently.

TheSQLGuru (3/19/2008)

---

If you have small datasets AND any joins you do to the table variable do not result in large numbers of joined rows, then you are perfectly OK. ...

Further to Matt's point above (see http://msdn2.microsoft.com/en-us/library/ms190384.aspx):

The following stored procedure will need to be created by the table owner and the user will need to be assigned EXECUTE permissions on...

OK, I hear poor old table variables sobbing in a corner somewhere, so I have to step in here... :w00t:

Table variables do cause less overhead in terms of locking, logging...

Mark Kenyon (3/19/2008)

---

There is a way to do it in SSRS:

1. On the layout tab, click the properties icon

2. choose report from the drop down list

3. expand the section interactive...

Todd,

Thanks so much for clarifying and for the valuable input!

There are other rendering-type capabilities in VS Report Designer, such as repeating header/footer, page breaks etc. I thought being able to...