Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Deploying ssis package


Deploying ssis package

Author
Message
shrsan
shrsan
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 117
Hi All,
Am trying to deploy a package. which is created in VS2010 into sql server 2012. but am getting below error while execution of the job.



Date
Log Job History (Abdc)

Step ID 1
Server Job Name ABCD
Step Name ABCD
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: XYZ. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: Error: Code: 0xC00291CB Source: Send Mail Task Send Mail Task Description: Either the file "C:\Users\***\Desktop\&&&\ynmd.txt" does not exist or you do not have permissions to access the file. End Error Error: Code: 0xC0024107 Source: Send Mail Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: Finished: Elapsed: 0.375 seconds. The package execution failed. The step failed.


when i execute it without sql job it executes but it is not working in sql job?

Thanks in Advance.
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8237 Visits: 14368
Looks like a validation error. Is it safe to assume that any paths to the attachment file are determined dynamically at runtime? Many times the problem with deploying to a server is that paths are different from the machine where the Packagewas developed.

Try setting the DelayValidation property on your file connection manager to true and redeploying the package before trying again. If that does not correct the issue you may also try setting the property to true on the Send Mail Task as well.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
lshanahan
lshanahan
SSC Veteran
SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)

Group: General Forum Members
Points: 274 Visits: 436
In addition to opc.three's comments, you probably also need to configure a SQL Server proxy to run your SSIS package using a job. That proxy account will also need permissions to whatever files/folders your package will access.

Also the path to the problem file indicates it is sitting in some User's Desktop - a pretty unlikely location for external files on a production system. I would suggest also looking at implementing package configurations.

____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
shrsan
shrsan
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 117
I will Try on That!!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search