Spam.

Integrated services as in SSIS.

I could create a bat file to run dtexec /f C:\SSIS\RefreshXact\RefreshXact.dtsx.

Does sound like a viable option?

I meant Service Pack and Integrated Services.

Thank you.

.

Jeff Moden (4/22/2016)

---

Welsh Corgi (4/22/2016)

---

Lowell (4/22/2016)

---

check to see how long your history retention is; it could easily have been written, but aged out by the time you look at it.

if...

I executed that package interactively and it barfed at a Enable Trigger Task.

I fixed the issue, then re-deployed and the job is running and is on the last load which...

Yes sir...

ok.

Lowell (4/22/2016)

---

check to see how long your history retention is; it could easily have been written, but aged out by the time you look at it.

if it is still a...

Brandie Tarvin (4/22/2016)

---

The most common cause of a TRUNCATE TABLE failure is the login running the code doesn't have db_owner on the database or ALTER permissions on the database. ISTR...

The problem is that the Job that executes a package fails with nothing in the Job...

Thanks it worked.

Does this look right?

ALTER TABLE tblCall

ADD CONSTRAINT DF_ReinspectTag

DEFAULT (rand()) FOR ReinspectTag

The issue has been resolved.

I found the package in msdb.

I performed a remote session to the Server using the following command:

DTUTIL /FILE Foreign_Key_ConstraintsDrop.dtsx /COPY SQL;Foreign_Key_ConstraintsDrop

It returns a response that Foreign_Key_ConstraintsDrop already exists. Do you want to overwrite it.

I create...