Thank you very much John. I will try the solution and let you all know the feedback.
Regards, Mahesh On Fri, Aug 27, 2010 at 12:10 PM, John R Pierce <pie...@hogranch.com> wrote: > On 08/26/10 10:12 PM, Mahesh y wrote: > >> John, >> >> Appreciate your quick response and Thank you very much. >> >> Pls, let me know the tools I can use instead of Perl. >> >> > Brian suggested SSIS, SQL Server Integration Services, which is in SQL > Server 2005 and 2008 > http://www.microsoft.com/sqlserver/2005/en/us/integration-services.aspx > http://www.microsoft.com/sqlserver/2008/en/us/integration.aspx > > there is perhaps a better overview of it here, > http://en.wikipedia.org/wiki/SQL_Server_Integration_Services > > more technical info starts here > http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx > > in versions of MS SQL Server prior to 2005, this was called DTS, Data > Transformation Services. > > > > frankly, I haven't used it since DTS in SQL Server 2000. It was quite > handy and flexible, but we do all our work in Oracle and PostgreSQL now. > > >
