title: Excecuting SSIS package deployed in Integration Service Catalog
body: <p>I have edited my entire question, first my question was how to execute the SSIS Package, but now I have got the solution to execute it via SQL Server Agent job but when I am trying to execute the SQL Server Agent job, I am getting error , when I viewed in history then following message is shown </p>
  
  <p>Job failed. Job was evoked by the user. Last step to run was step 1. </p>
  
  <p>please note the table where I am inserting the data into database via SSIS package in SQL Express, is it SQL Express creating problem.</p>
  
  <p>---------<strong>Updated Error Message</strong>-------------</p>
  
  <p>The following error message is seen when I expand log file of SQL Server Agent job,</p>
  
  <p>Executed as user: NT Service\SQLAgent$SQL_Server_Evalu. Microsoft(R) SQL Server Execute Package utility Version 11.0.2100.60 for 64 bit copyright (C) Microsoft Corporation. All right reserved started: 16:11:39 Package Execution on IS Server failed. Execution ID:4, Execution Status:4.</p>
  
  <p>Below is the screen shot how I execute the SQL Server Agent job,
  <img src="https://i.stack.imgur.com/UFygB.png" alt="enter image description here"></p>
  
  <p>------------<strong>Updated error message</strong>------------
  Below is the screen shot of the error message that are given while execution of the deployed package.</p>
  
  <p><img src="https://i.stack.imgur.com/WQiAD.png" alt="enter image description here"></p>
  
  <p>Errors are as follows:</p>
  
  <p>1) Data Flow Task Error: There were errors during task validation.</p>
  
  <p>2) Data Flow Task Error: OLE DB Destination failed validation and return error code 0XC020801C.</p>
  
  <p>3) Data Flow Task Error: One more component failed.</p>
  
  <p>4) Data Flow Task Error: SSIS Error Code
     DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
     The AcquireConnection method call to the connection manager "RESHMAJADHAV\SQLEXPRESS.Adventureworks2012" failed with error code 0XC0202009. </p>
  
  <p>5) Package Error: SSIS Error Code DTS_E_OLEDBERROR. An OLEDB error has occured. Error Code: 0X80004005. An OLE DB record is available. source: "Microsoft SQL Server Native Client 11.0" Hresult: 0X80004005 Description:"Login failed for user 'NTSERVICE\SQLAgGENT$SQL_SERVER_EVALU'.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0X80004005 Description:"Cannot open Database" AdventureWorks2012"
  requested by login. The login failed"</p>
  
  <p>Is it because of the connection string </p>
  
  <p><strong>"Data Source=RESHMAJADHAV\SQLEXPRESS;Initial Catalog=AdventureWorks2012;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;"</strong></p>
  
  <p>That I have defined in environmental variables in Integration Service Catalog I am unable to open the database..?</p>
  
  <p>Any help will be greatly apprecaiated...</p>