Re: (Fwd) DBI Performance for SQL Server

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 <[email protected]> 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.
>
>
>