Add a Mysql as a Linked Server

The other day I got a request to migrate some data from Mssql to Mysql.  I am like ok fine, I will just use SSIS and it will take me a second.

This second led to more than four hours of frustrations.  Why?  Apparently Microsoft decided not to put any ODBC destination connectors on

the SQL Server Intelligence Studio (SSIS – 2005 version).

Note that my evironment consists of  the sql server 2005, bids (2005) .

FYI: It seems that on the 2008 version, Microsoft gives us the ODBC provider back.

If you are still running the 2005 version here are the solutions:

Setup SQL Server Linked Server to MySQL
http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Adding Mysql as a linked server
http://www.infi.nl/blog/view/id/4/How_To_MySQL_as_a_linked_server_in_MS_SQL_Server

Insert into a MYSQL linked Server
http://www.youdidwhatwithtsql.com/insert-data-mysql-tsql/4

Format date and time MS DOS

This is a quick MSDOS Batch script to help me out when I have to move a file and rename it in the process based on the current date.

cls
FOR /f "tokens=1-4 delims=/-. " %%G IN ('date /t') DO (call :Fix_Date %%G %%H %%I %%J)
goto :print_date

:Fix_Date
if "%1:~0,1%" GTR "9" shift
FOR /f "skip=1 tokens=2-4 delims=(-)" %%G IN ('echo.^|date') DO (
set %%G=%1&set %%H=%2&set %%I=%3)
goto :eof

:print_date
copy c:\Users\ycsoftware\ycsoftware.txt c:\ycsoftware.%mm%.%dd%.%yy%.txt

Set up a VPN using Microsoft Windows

1.First Look at this video to set up the server

2. Then this one to set up the client

Note that these are not ycsoftware.net videos, they have been selected from youtube because they summarize really what i wanted to write about, which is: How to set up vpn on windows.

If you prefer to read, check this site out:
http://www.aeonity.com/frost/howto-windows-xp-vpn-server-setup

FYI: The Default VPN Port on Windows is 1723

Issues
Loosing internet connectivity when vpn is on
http://footheory.com/blogs/shane/archive/2007/08/14/vpn-connection-disconnects-your-internet-session.aspx