I do not know what I did but it is working now. 😎

That could be the issue.

Thanks.

I did not change the package to run in 32 bit mode.

I have ran SSIS Packages in 64 bit on older OS's and it was not an issue however when...

I already have two packages that load this Excel File and I have had no issues.

I'm wondering if the package is corrupt?

I seem to recall having to create a variable.

Then in the EXEC SQL Task write to result set and do something with the parameter mapping.

There I created a Script task...

I remember now that I created a script task to check the output variable and succeed or fail the package.

I believe?

Tac11 (11/18/2016)

---

if you do RDP to the server and right click on SSMS logo it gives your an option as 'run as different user" but it doesn't work on...

I did but I do not have the data types right.

Thanks.

Good thing that I do not need this anymore.

Thank you to everyone that was helpful.

Mike Scalise (9/29/2016)

---

Grant Fritchey (9/29/2016)

---

I'd just do them one after another.

I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do...

Thanks for the link Phil.

It got me part was but no cigar.

I just want to grant the User permissions to create, alter and drop rights in their...

I think you meant Fixed Database Roles? I am...

Eric M Russell (9/29/2016)

---

Welsh Corgi (9/29/2016)

---

Eric M Russell (9/29/2016)

---

GilaMonster (9/29/2016)

---

And, after you're read that, tell me whether 'CREATE PROCEDURE', 'ALTER PROCEDURE', 'DROP TABLE', etc are valid permissions...

Thanks.

How about the following?

GRANT ALTER, DELETE, EXECUTE, INSERT, REFERENCES,...

GilaMonster (9/29/2016)

---

You grant ALTER on the schema, then the required CREATE permissions at the DB level, make sure the user has NO permissions to the dbo schema, doesn't have DB_Owner,...