Re: (Fwd) DBI Performance for SQL Server

[email protected] (John R Pierce) Thu, 26 Aug 2010 23:40:02 -0700

Newsgroups	perl.dbi.users
Message-ID	<[email protected]>

  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.