Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Sheduled package not working Expand / Collapse
Author
Message
Posted Tuesday, September 10, 2013 5:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:54 AM
Points: 95, Visits: 453
Hi all,

A package has been created and I have scheduled it, when it runs it errors. The description to the error is"Executed as user: GMFS\sql_service_account. The package execution failed. The step failed." which is not very helpful. I can run the dtx package successfully.

The Protection Level is set to ‘EncryptSensitivewithPassword’

I have compared this with other packages that have been scheduled before and i can't see any differences.

Has anybody got any ideas?
Post #1493100
Posted Tuesday, September 10, 2013 5:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
Did you enable logging in the SSIS package? If yes, is there something useful in there?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1493115
Posted Wednesday, September 11, 2013 2:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:54 AM
Points: 95, Visits: 453
Hi,
Yes I did enable logging in the SSIS package, but there anything useful to see.
Post #1493510
Posted Wednesday, September 11, 2013 3:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
clucasi (9/11/2013)
Hi,
Yes I did enable logging in the SSIS package, but there anything useful to see.


Which events did you log?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1493516
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse