No. And there's a reason right there 🙂 Logging is taken care of for you if you...

No. You'll have to find other ways of scheduling tasks in Express Edition.

Are you using the project deployment model?

If so, you could try looking on the All Executions report. The run-time values of all params would be logged there.

SQL!$@w$0ME (2/29/2016)

---

One additional thing: if you are using SSISDB environments to control package params and connections, you will need to tell the package which environment to use. 

Thanks.

Should I set connection...

SQL Server Agent ......

Lowell (2/29/2016)

---

for a lot of my trigger or procedure based audits, i don't limit myself; i just log everything, since you never know what might be relevant later.

I add columns...

That's the better solution anyway.

Did you get this working? My next suggestion would be to attempt to capture the exact command line which is being sent by the...

Sorry if this is an obvious question, but has the SQL instance been set to mixed mode authentication?

scotdg (2/26/2016)

---

I have a job that I want to run that passes a variable to an ssis package. The variable is a filename but the filename changes daily. I have...

Not at all.

TheSQLGuru (2/24/2016)

---

1) Please provide create table statements, sample data via INSERT statements and expected output cases to back up what you are asking. I can't make heads or tails of...

If you post the actual execution plans for the queries you detailed, it will be helpful to others.

SSIS is not going to perform raw data processing work any faster than the SQL Server database engine. In fact, it will usually be slower.

Therefore trying to move everything into...

Jeff Moden (2/24/2016)

---

I definitely wouldn't use XML for anything even close to this. Also, computers don't "easily" read XML. There are programs that make it easy for Developers...