Schedule a Packge.dtsx - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Schedule a Packge.dtsx

Author

Topic

lfelicio
Starting Member

4 Posts

Posted - 2008-06-24 : 12:55:11

Hello,
Please, help me.. I'm trying to execute a packge.dtsx that be save in folder. How can i do, to execute it? I create a job, but always give me errors..

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-24 : 12:56:45

Could you show us what you put in the job step and what the error is?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lfelicio
Starting Member

4 Posts

Posted - 2008-06-24 : 13:04:37

Yes..
STEP_NAME :CDRLIVE
TYPE: SQL SERVER INTEGRATION SERVICES PACKAGE
PACKAGE SOURCE : FILE SYSTEM
PACKGE: C:\MIGRACAO\CDR-LIVE\CDR-LIVE\Package2.dtsx

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-24 : 13:06:31

What is the error?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lfelicio
Starting Member

4 Posts

Posted - 2008-06-24 : 13:13:37

Message
The job failed. The Job was invoked by User luiz.marinho. The last step to run was step 1 (agenda_1).

Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. The package execution failed. The step failed.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-24 : 13:16:45

In order to figure out why it is failing, you'll need to log into the database server using the SQL Server service account. Either go to its console, RDP into it, or use some other method that allows you to log into the database server directly. You must do it with the SQL Server service account in order to troubleshoot this. Once you've done this, execute the package manually through the designer (not through the job). Let us know what error it gets there.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lfelicio
Starting Member

4 Posts

Posted - 2008-06-24 : 13:29:40

Thank you for your atention,
When i execute the packge maually in visual stution 2005. It is ok..Execute all.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-24 : 13:36:29

That isn't what I said to do.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-24 : 13:53:57

What protection level did you set while saving package in BIDS? If you don't want password-protected you can choose Rely on server option? Also make sure your Sql agent account has access to folders if there is included in your SSIS package.

ares
Starting Member

6 Posts

Posted - 2008-06-27 : 09:32:08

Hi lfelicio,

Have a look here. It sounds familiar.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105100

Ares

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources