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.