It looks like the Saifa Date was updated/changed so yes it will be included into the next week. So make sure when using date fields and a driver for when...

I did notice that you have a field of the Telephone as varchar(20) and your lookup @PhoneNo is varchar(50). I would recommend that you have the same type and size so...

You just put the declares in the @qry

set @qry = 'Declare @value4 int, @database_name varchar(100) SELECT @value4= COUNT(*) FROM '+@database_name+'..test_table'

The parser will be able to sort it out.

-CodeMan

Yes, I do this on SQL server 2014 with a linked server and a SSIS package and it works very well. Just install the MySQL ODBC driver for SQL...