This is essentially the syntax you will need to use

=IIF(Fields!Column.Value = "Check", "Red", "No Color")

What about IIS7 are you trying to configure? Is it the application connection string that you are having difficulties with?

The data in the file, is it delimited or is it just paragraphs of information?

is it mandatory to use tsql, or can PoSH or SSIS be used instead? Both of those tools are better for this type of task than tsql.

Nice question.

Try changing the sql agent service account using configuration manager. Even just reset it back to the same service account currently in place.

Does this package perform any tasks on the filesystem (read files, check file existence, delete files, etc)?

Michael Valentine Jones (3/12/2013)

---

If the client can't accept paying for the hours you work, then it's time to move on.

Just turn in your timesheet with the actual hours you work,...

ratheesh4sql (3/12/2013)

---

Hi..Thanks for your link..

But unfortunately my issue is not solved changing the Outputlog and user rights.

When i am trying to change the service user itself i am getting an...

Is the package stored in msdb or filesystem?

Oh, and it would be a good idea to start a new thread for this. This was an old thread and appears...

sqlfriends (3/12/2013)

---

But I don't think...

It appears to mean, grant permissions on the temp directory to the...

SQL Guy 1 (3/12/2013)

---

Steve-3_5_7_9 (3/12/2013)

---

Being that you are not a salaried employee, you cannot be expected to work for free. This is the sort of thing that should...

Yup

I had to think on this a bit. I think the idea has some merit. Storing database "maintenance" details and schedules within the database would be useful. ...