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

SQL Job does not executes SSIS package but Job goes to executing state and don’t stop. Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 4:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 12:02 AM
Points: 37, Visits: 500
Hi,

There is one SSIS package which is executed successfully when run from
Visual Studio. When the package is executed through SQL job using proxy
account the job does not executes the package but Job goes to executing state and don’t stop.


Please help me with some solution.

Thanks and Regards,
Nikhil Desai
Post #1475923
Posted Monday, July 22, 2013 4:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
What do you do inside the package?



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 #1475930
Posted Thursday, July 25, 2013 3:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 12:02 AM
Points: 37, Visits: 500
Hi,

My Package basically imports flat file and process the data :

My Source of Falt file is Microsoft Outlook. I recive mails from some ID's which have flat files as attachment . i use some vb script to export the flat file from the mails and save them on the local folder. then for importing i m using Data flow task and then one SP runs which process my data.

Thanks and Regards,
Nikhil Desai
Post #1477402
Posted Thursday, July 25, 2013 3:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
Might be a permission issue. Which account do you use in the SQL agent job?



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 #1477404
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse