Let the SSIS package run on Server 2 and connects to Server1 using conenction managers inside SSIS.

Licensing is not a problem, we have corporate version. guideline is to deploy all...

Yes, all that my code do is it splits the data based on keyword. I just gave an idea on to achieve the splitting of data.

I'm using SQL2005, but I...

Here is some sample code that I could think of ... this is just to get you an idea. you need to put this code in WHILE loop inorder to...