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: Wednesday, July 9, 2014 5:24 AM
Points: 94, Visits: 439
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: Today @ 12:41 AM
Points: 13,537, Visits: 10,405
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: Wednesday, July 9, 2014 5:24 AM
Points: 94, Visits: 439
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: Today @ 12:41 AM
Points: 13,537, Visits: 10,405
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