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

Job failed due to Warning in Source select statement Expand / Collapse
Author
Message
Posted Monday, July 12, 2010 11:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 18, 2010 5:50 AM
Points: 3, Visits: 30
Hi,
I have SSIS job fetching datda from SQL source.I am getting some warning message when running the query.and job is failing in prod.But the job is successfulin acceptance with the same source(even though warning is coming).Please help
Post #951161
Posted Tuesday, July 13, 2010 12:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 16, 2010 2:00 AM
Points: 44, Visits: 65
Hi,

Provide the warning message.. so that ll try to help u


Regards,
Gayathri
Post #951164
Posted Tuesday, July 13, 2010 5:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
Are you sure it is not a permission issue?
Also, in production. is there only a warning or also an error? How does it fail?




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 #951312
Posted Tuesday, July 13, 2010 5:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
if the package is passing QA and failing in Production it has to be an issue with permission

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #951317
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse