This isn't exactly a better way to handle the problem you encountered, but may be a better way to manage security so it is less of an issue. Use...

Sure you can execute multiple statements in an Execute SQL Task. I usually put a GO between them, but you don't have to. The only issue is that...

I don't think you can successfully use a dataset field in the header or footer of a report. I think you can only use globals there.

I'd use a table...

You are not getting a conversion error saying it can't convert the non-unicode string to a unicode string?

I'd stick a data conversion transform in between and convert it...

Are your processes the only ones that touch the spreadsheet?

It sounds like one of the processes is not releasing the file. I think if you use the Import\Export Wizard...

All right, I was not sure what you wanted the first time, try this:

[font="Courier New"]DECLARE @TableA TABLE(id_user INT IDENTITY(1,1) PRIMARY KEY, Name VARCHAR(10))

DECLARE @TableB TABLE(id_user INT, id_menu INT)

INSERT INTO @TableA

  ...

Here are 2 options where option 2 is probably the better option:

[font="Courier New"]SELECT

   TableA.id_menu

FROM

   TableA INNER JOIN

   TableB ON

       TableA.id_Menu = TableB.id_Menu

WHERE

   TableA.id_User = 1

UNION ALL

SELECT...

My thoughts exactly.

I'm not sure of all this, but I think lock pages in memory is an Enterprise edition option and not available in Standard. You definitely want to use AWE...

Check the query plans and if they are the same it really doesn't matter. I prefer the second because I find it easier to read.

Can you zip the rdl and attach it to the thread?

In SQL Server the best way to handle security is through roles. You create a role and Grant appropriate permissions. Then you add users to that role.

In your...

As the link I posted said. Make sure you are running the 64-bit DTSEXEC.

I don't do nearly enough. I love basketball and was playing 2 nights a week until I went traveling for a month in June and I haven't played since....

antonio.collins (8/8/2008)

---

depends on how many reports he has to do and when they have to be done. since the sql is coming from existing code, making 'improvements' may open...