When I attempt to change the Service Account and select replace the existing encyption key but it does not apply..

You should not get an error but you should include an exception Handler to Include WHEN NO DATA FOUND, perform an action.

Take you select statement and look at what is...

Massan (3/25/2013)

---

do you have any server Database mail does work properly? if you do you may try and compare the configurations differences and if you could not find anything, you...

For Remote Server whether it be Oracle AS400 DB2 or whatever the Linked Server can be terribly slow.

Depending upon the amount of data you are pulling it may be faster...

I had 64 bit set to true on many occassions and it still ran in debug but failed when running as a job.

I just ran a package with 64 bit...

It's the Database!!! (3/20/2013)

---

It's the Database!!! (3/20/2013)

---

lazy writer (3/20/2013)

---

Hi,

I had some weird issues while running SSIS package as agent job. I can run SSIS package manually but failing to run...

Looking at your error message more closely it could be related to the DSN.

Consider where it is a 32 bit DSN or a 64 bit DSN.

http://sql-ution.com/32-bit-odbc-connections-with-64-bit-ssis

Right Click on the Project and Select Properties,

On the left click the debugging tab.

Make sure that Run64bitRuntime is set to false.

At the following URL:

http://serverfault.com/questions/291469/sql-server-wont-start-due-to-luns-being-unavailable

I found this:

Are you using the Microsoft iSCSI software initiator? Are the defined iSCSI drives dynamic?

There is a known issue where the software iSCSI initiator doesn't start...

kevaburg (3/17/2013)

---

If that was the case he wouldn't be able to take the database offline in the first place. He was quite clear that he could see the database...

SQLRNNR (3/14/2013)

---

SQLRNNR (3/13/2013)

---

Welsh Corgi (3/13/2013)

---

Seemita Das (3/13/2013)

---

Did you check the 'protection level' on the package? I had faced a similar error earlier and it was resolved after I changed the...

Yes you can accomplish it through SSMS. I prefer to do this in T-SQL.

To do this in SSMS.

Create a User and add them to the public role. (for minimum permissions)

If...

Sorry but that issue in the article that you provided is totally unrelated to the issue that I'm having.

Thanks.

Jeffrey Williams 3188 (3/13/2013)

---

When you installed SQL Server 2008 - did you install with the default Service SID?

If so, then your domain account running SQL Server agent does not have...

Seemita Das (3/13/2013)

---

Did you check the 'protection level' on the package? I had faced a similar error earlier and it was resolved after I changed the protection level from 'EncryptAllWithPassword'...