<div>
You might not need to create a linked server...<br />
You can just create an SSIS Package with the connection to your MySQL Database (likely using OLEDB or ODBC Connection), then you can add all the Transformation Tasks and Data Manipulation you wish.<br />
<br />
After you just need to schedule that SSIS to run at specific time through MSSQL Agent.<br />
<br />
Jerry
</div>


You might not need to create a linked server...
You can just create an SSIS Package with the connection to your MySQL Database (likely using OLEDB or ODBC Connection), then you can add all the Transformation Tasks and Data Manipulation you wish.

After you just need to schedule that SSIS to run at specific time through MSSQL Agent.

Jerry

<div>
Thank you for your kind response.<br />
<br />
Is possible to assist me with SSIS Package creation?<br />
<br />
Thanks
</div>


Thank you for your kind response.

Is possible to assist me with SSIS Package creation?

Thanks

<div>
Thank you, i followed the following tutorial and problem solved with your help...<br />
<br />
<a href="http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm" rel="ugc">http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm</a><br />
<br />
Thank you
</div>


Thank you, i followed the following tutorial and problem solved with your help...

http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm [http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm]

Thank you

<div>
Thank you, you saved lot of my time.
</div>


<div>
<div class="content wysiwyg-content">
Dear All,<br />
<br />
I have a production databsae on MySQL and want to send some data everyday to SQL SERVER 2008 R2 as a job. Kindly advice if this is possible to create a link server for MySQL in SQL SERVER 2008 R2.<br />
<br />
Many Thanks,
</div>
</div>


Dear All,

I have a production databsae on MySQL and want to send some data everyday to SQL SERVER 2008 R2 as a job. Kindly advice if this is possible to create a link server for MySQL in SQL SERVER 2008 R2.

Many Thanks,

Data migration from MYSQL to SQL SERVER 2008 R2

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.

Microsoft IIS Web Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications