When you try this, are you connected to the SQL instance via Windows Authentication or SQL Authentication?

Install the 32-bit drivers too, assuming they exist, then SSDT will use those.

When the packages run on the server, they will use the 64-bit versions.

Probably because SSDT is a 32-bit client 🙂

It really seems that the Agent service account does not have the necessary rights.

Are you using a UNC path?

jasona.work (3/23/2016)

---

I'd ask if it made me odd to be enjoying puttering around and tweaking a report in SSRS (with no guarantee that it will even be used) to get...

SQL!$@w$0ME (3/23/2016)

---

I am able to run the package from the server (manually run from SSIS Catalog not through job). But it fails when run from my desktop.

Any thoughts on this.

Many...

db8 (3/23/2016)

---

hi all

i need suggestion on this error

Truncation may occur due to inserting data from data flow column "name"

with a length of 50 to database column "name"...

As far as I know, you can set yourself up with an EC2 instance (Windows Server only) and then install whatever you like.

I was only trying to help.

Perhaps you could use Profiler to find out what the app is doing?

yb751 (3/22/2016)

---

Jacob Wilkins (3/22/2016)

---

Steve Jones - SSC Editor (3/22/2016)

---

Alan.B (3/21/2016)

---

Quick question: I got the standard email saying that someone replied to a comment on one of the forum threads but...

Koen Verbeeck (3/22/2016)

---

Grant Fritchey (3/22/2016)

---

Koen Verbeeck (3/22/2016)

---

Grant Fritchey (3/22/2016)

---

Koen Verbeeck (3/22/2016)

---

In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all of the...

SQL!$@w$0ME (3/21/2016)

---

Is it a good practice to move SSISDB to a data drive. By default this is created on directory where system db location.

Can the SSISDB database files moved to...

Take a quick look here and see whether it may be relevant.

Those cakes sound tempting:-)

What I suspect is that the TRY_PARSE is merely hiding a more fundamental problem. The fact that you were getting errors before means (I think) that the...