created ssis package for exporting records from sql table to excel.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  September 9, 2011 at 4:46 pm

  #1379543

  Maheshsoft1987 (9/9/2011)

  ---

  I have checked it. Its seems like I have read write permission.

  It seems like? That does not sound very convincing.

  You said that the package would be using the Service Account. If that is the case it does not matter what permissions you have; the job (assuming you are running as a job) will fail.

  Why don't you logo to the server using the Service Account and do what I suggested.

  It is a quick simple way to test.

  But you are not very articulate as to exactly what you are doing?

  Are you logging onto the Server?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/