sql agent job - 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)

sql agent job

Author

Topic

vasu4us
Posting Yak Master

102 Posts

Posted - 2007-07-13 : 16:23:39

Hi, I am new to SSIS. I createdtwo packages which are almost identical, only difference is the table name in the query to extract data just a test package.the package is created under my windows account, with the default protection level. I have scheduled them using SQL server agent. one runs succesfully and the other fails with error

Message
Executed as user: NA\dbasvc-alticor. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:28:25 AM Error: 2007-07-10 11:28:26.21 Code: 0xC020838F Source: Staging LKPDataReader Source [1] Description: An error occurred executing the provided SQL command. End Error Error: 2007-07-10 11:28:26.21 Code: 0xC004706B Source: Staging DTS.Pipeline Description: "component "LKPDataReader Source" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2007-07-10 11:28:26.21 Code: 0xC004700C Source: Staging DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-07-10 11:28:26.21 Code: 0xC0024107 Source: Staging Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:28:25 AM Finished: 11:28:26 AM Elapsed: 0.906 seconds. The package execution fai... The step failed.

I understand that it is something to do with
1.protection level
2.the user account under which the package is running
3.the SQL agent account used to run job

can someone be a detailed in explaining how to get this running and one big ? is why one package fails while the other with exactly same settings is running perfectly.

Please help i bid a lot of google on this but still confusing

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2007-07-13 : 16:27:20

Vasu,
Can you tell what's the SSIS package doing?

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-13 : 17:27:44

Since you get error in datareader source, I think your connection for the second package is failing.
Check out the connection string. If you are using config file, mostly password might be missing in the config file.

Thanks
Karunakaran

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-13 : 18:04:38

Who is job owner? Any remote data source involved? Does sql agent service account have permission on remote data source?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources