There are couple of ways I can think of, for doing data validations.

1) Approach suggested in http://stackoverflow.com/questions/6464601/how-to-validate-a-csv-file-before-importing-into-the-database-using-ssis link (shared by twin.devil).

2) Temp Table and Validation on it

...

Below script will fetch details from all the databases having names with post fix as current 'MM-YY'.

DECLARE @Query NVARCHAR(MAX) = ''

SELECT @Query = 'USE [' + name + ']'...

Thanks James,

I have gone through many blogs for remote connection. The first step is to enable TCP/IP from SQL Server Configuration Manager under Protocols for SQLEXPRESS node.But in my configuration...