Hi
I have created a package and added it into SSMS Integration Services under Stored Packages and also MSDB. if I execute the package from SSIS or within the Integration services in SSMS then it runs ok.
If I add it to a job so I can schedule in SSMS Database Engine (all on the same server) I am getting errors and it cannot run. I have tried all sorts in the job to get it working but no luck. The current message is as below. Any ideas what could be wrong. I have googled a lot of the text below but cannot find a solution. Help please.
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
04/27/2016 11:48:26,Paragon,Error,0,ITS3270,Paragon,(Job outcome),,The job failed. The Job was invoked by User IT_SERVICES\PresC. The last step to run was step 1 (paragon export).,00:00:02,0,0,,,,0
04/27/2016 11:48:26,Paragon,Error,1,ITS3270,Paragon,paragon export,,Executed as user: IT_SERVICES\SQLServer. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:48:26 Error: 2016-04-27 11:48:28.53 Code: 0xC020200E Source: Data Flow Task Flat File Destination [73] Description: Cannot open the datafile "D:\Paragon import files\Testing\Todaysfile.csv". End Error Error: 2016-04-27 11:48:28.53 Code: 0xC004701A Source: Data Flow Task SSIS.Pipeline Description: component "Flat File Destination" (73) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:48:26 Finished: 11:48:28 Elapsed: 1.625 seconds. The package execution failed. The step failed.,00:00:02,0,0,,,,0
I have created a package and added it into SSMS Integration Services under Stored Packages and also MSDB. if I execute the package from SSIS or within the Integration services in SSMS then it runs ok.
If I add it to a job so I can schedule in SSMS Database Engine (all on the same server) I am getting errors and it cannot run. I have tried all sorts in the job to get it working but no luck. The current message is as below. Any ideas what could be wrong. I have googled a lot of the text below but cannot find a solution. Help please.
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
04/27/2016 11:48:26,Paragon,Error,0,ITS3270,Paragon,(Job outcome),,The job failed. The Job was invoked by User IT_SERVICES\PresC. The last step to run was step 1 (paragon export).,00:00:02,0,0,,,,0
04/27/2016 11:48:26,Paragon,Error,1,ITS3270,Paragon,paragon export,,Executed as user: IT_SERVICES\SQLServer. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:48:26 Error: 2016-04-27 11:48:28.53 Code: 0xC020200E Source: Data Flow Task Flat File Destination [73] Description: Cannot open the datafile "D:\Paragon import files\Testing\Todaysfile.csv". End Error Error: 2016-04-27 11:48:28.53 Code: 0xC004701A Source: Data Flow Task SSIS.Pipeline Description: component "Flat File Destination" (73) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:48:26 Finished: 11:48:28 Elapsed: 1.625 seconds. The package execution failed. The step failed.,00:00:02,0,0,,,,0