Job failed due to Warning in Source select statement

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Job failed due to Warning in Source select...

Job failed due to Warning in Source select statement

Rate Topic

Display Mode

Topic Options

Author

Message

ravoof99

Posted Monday, July 12, 2010 11:53 PM

Forum 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

gayathridevi.msit

Posted Tuesday, July 13, 2010 12:04 AM

SSC 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 Smile

Post #951164

Koen Verbeeck

Posted Tuesday, July 13, 2010 5:08 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 9,367, Visits: 6,463

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

Raunak Jhawar

Posted Tuesday, July 13, 2010 5:25 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

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 »

Permissions