vensali

<div>
<div class="content wysiwyg-content">
I have SSIS package created which transfers data from local mysql server to azure database. &nbsp;the package runs fine inside visual studio and data gets transferred. &nbsp;i created the sql job in local sql 2012 server by importing this package . &nbsp;when i run the job &nbsp;it throws the below error and job fails<br />
<br />
sqlsvrjob_medicsteam_azure<wbr /> Connection manager &quot;khsql.database.windows.ne<wbr />t.Kh-Websi<wbr />te.khsql&quot; &nbsp; &nbsp; Description: SSIS Error Code DTS_E_OLEDBERROR. &nbsp;An OLE DB error has occurred. Error code: 0x80040E4D. &nbsp;An OLE DB record is available. &nbsp;Source: &quot;Microsoft SQL Server Native Client 11.0&quot; &nbsp;Hresult: 0x80040E4D &nbsp;Description: &quot;Login failed for user 'khsql'.&quot;.
</div>
</div>


I have SSIS package created which transfers data from local mysql server to azure database.  the package runs fine inside visual studio and data gets transferred.  i created the sql job in local sql 2012 server by importing this package .  when i run the job  it throws the below error and job fails

sqlsvrjob_medicsteam_azure Connection manager "khsql.database.windows.net.Kh-Website.khsql"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80040E4D  Description: "Login failed for user 'khsql'.".

running ssis package job from local sql2012 server against azure sql database

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

SSIS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.