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

  • 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/

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply