problem with SSIS package

Hi there,

I have a weird problem with SSIS package. Package is deployed and save on SQLServer2k5. It runs no problem if I start from Integration services. It fails every time when it is scheduled as a job.

The error message is: The package execution failed.The step failed.

I will appreciate any advice.

Thanks a lot.

When it's run from a job it executes under the account sql agent is running as. Are you using a data source that is sql authentication? If so you need to set the protection level when you deploy the package to something other than encrypt with user key or else it probably won't work when run as a job. There's a couple of options but if you just want it to work set it to rely on server.|||

Thank you Brent,

Unfortunately I use only Windows security. But I will try to set protection any way.

Cheers.

Michael

|||Make sure the account sql agent is running under has access to the db's you're trying to connect to. If that's a security concern, you can add a proxy account to execute the job under.|||

how can i check if this sql agent is running?

ihave this error when running my package after deploying it

Error: 0xC0202009 at Package, Connection manager "Presup Dev sql_prov": An OLE DB error has occurred. Error code: 0x80040E4D.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: Se ha forzado la interrupción de una conexión existente por el host remoto.

|||

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=237837&SiteID=1

|||

ruk_walled wrote:

how can i check if this sql agent is running?

ihave this error when running my package after deploying it

Error: 0xC0202009 at Package, Connection manager "Presup Dev sql_prov": An OLE DB error has occurred. Error code: 0x80040E4D.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: Se ha forzado la interrupción de una conexión existente por el host remoto.

this might help: http://support.microsoft.com/kb/918760/en-us|||

Brent,

I am having the same problem. I have thirteen SSIS packages and each one connects to an Oracle Database that uses SQL Authentication. Could you elaborate on the options you mentioned? And how would I set it to rely on the server, server Storage? (if so, doesn't work for me)

Thanks.

|||

Binh Cao wrote:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=237837&SiteID=1

Not sure if that was for me Binh, but that also did not work. My problem persists.

|||

What is the exact error you are receiving? It only happens when using SQL Agent?

Rafael

|||

I am receiving an 'AcquireConnection Error' that it cannot connect to the Oracle db. And yes, it only occurs when I try to schedule a job using SQL Agent, it runs in BIDS just fine.

Exact Error:

OnError,EESDCSDS522, [domain]\[login],Data Flow Task 1,{DF1DCB8E-74E7-4C5D-A639-7BAED849AAD7},{72E82E9B-7620-424E-A4E3-70E601497B54},8/10/2006 10:31:08 AM,8/10/2006 10:31:08 AM,-1071611876,0x,The AcquireConnection method call to the connection manager "[Remote Oracle Database]" failed with error code 0xC0202009.

EESDCSDS522 is the local db

I have taken out my domain\login and the name of the Remote Oracle DB for security reasons.

|||

_Phil_,

Is the box where you are running the package a 64-bit machine? SQL Agent will run the 64-bit version of DTSexec and all your 32-bit drivers won't be available for the package. The Work around is to schedule as command line that will call the 32-bit version of dtsexec.

Other thing to check is the credentials of the account used to run the SQL agent service; make sure it has the required permissions.

I hope this helps.

|||

Dear Rafael Salas,

This is the message we are getting when checking the job run history.

Message
The job failed. The Job was invoked by Schedule 4 (Package packageName). The last step to run was step 1 (Package packageName).

and on expanding it shows:

Executed as user: Servername\SYSTEM. The package execution failed. The step failed.

|||

Still facing the same problem.

The system account as well as the account specified to run the agen also fails.

thanks,

|||Try running DTEXEC from the command line under the account that you are attempting to use. That should give you a better error message.

Problem with reportfooter and header

Dear sir,

i am developing reports in sql server businessintelligence development studio...i deployed the reports in reportserver and i was able to see it..but my requirement is all my reports should have the same header and footer as of all other pages must uses custom footers and headers....hw to use thatcustom footer and header in my reports

Regards,

Pradeep

Hi,

do you want to create custom report headers or use the same for all reports ? This is not quite clear.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

dear ,

other than reports pages i have some other pages in that footer and headers(company logo and the project name like that)...i want o use the same thing in my reports

|||Hi,

I always do that by building a report template for portraint as well as for landscape and build my reports on top of that. Once the report design is signed off by anyone who is responsible you can be sure (or a bit more sure) that anything will change afterwards.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

problem with panda antivirus and olap cubes

I have the next problem:
i have MS sql server 2005 installed in a server.
We have some olap cubes in the server deployed with analysis services 2005.
When we try to connect to the analysis server from a client pc using pivot tables we obtain this error:
"Errors in network layers. Error code=0XC10D0009, External code=0x00000000"
The client pc has panda antivirus (corporate) with true prevent
When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server.
Anybody had a similar problem?
Anybody knows a solution for it?
Thanks
Jose
coormx@.yahoo.com.mx

Jose,

In this situaion, the fast way is to contact the antivirus vendor to solve the issue.

However, if you can post your *connection string* and *exact error message*, somebody in this forum might help you to pinpoint your issue.

|||

Moving to the SQL Server Analysis Services Forum.

|||panda has fixed the problem. Tank you panda

problem with panda antivirus and olap cubes

I have the next problem:
i have MS sql server 2005 installed in a server.
We have some olap cubes in the server deployed with analysis services 2005.
When we try to connect to the analysis server from a client pc using pivot tables we obtain this error:
"Errors in network layers. Error code=0XC10D0009, External code=0x00000000"
The client pc has panda antivirus (corporate) with true prevent
When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server.
Anybody had a similar problem?
Anybody knows a solution for it?
Thanks
Jose
coormx@.yahoo.com.mx

Jose,

In this situaion, the fast way is to contact the antivirus vendor to solve the issue.

However, if you can post your *connection string* and *exact error message*, somebody in this forum might help you to pinpoint your issue.

|||

Moving to the SQL Server Analysis Services Forum.

|||panda has fixed the problem. Tank you panda