Re: DTS to .net

> You know how the DTS wizard will allow one to save as VB...is there some
> sort of upgrade that will generate .net code (heaven forbid, c#)?

AFAIK not. VS.NET uprades VB6 code to VB.NET, but you won't like the code.
You can check this guide how to use DTS in .NET:
http://sqldev.net/dts/DotNETCookBook.htm.

> Second question. Does one generated this code and, assumedly, compiled
> it in order to batch file or otherwise script it and is there a
> performance degradation by going outside the SQL Server engine?
>

DTS uses own objects, the execution is independent of SQL engine, so it
really does not matter where you execute it.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com


.

Relevant Pages

  • RE: Isolating a DTS package
    ... you can create a DTS package status table that gets logged to ... at the beginning and the end of your DTS package execution. ... In SQL Server 2005, we will have a DTS Service that will allow us to monitor ...
    (microsoft.public.sqlserver.dts)
  • Re: bas file does nothing
    ... If a DTS package fails to execute, such as bad file, then this does not ... need to check that the package step execution result or use events to ... >occurs on the SQL Server side and VBA doesn't know about it? ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)
  • c#, DTS and Threads
    ... I imported DTS into .NET like Microsoft ... That worked fine beside that the gui was locked during execution of the DTS ... private delegate void LabelUpdateDelegate(string sString); ...
    (microsoft.public.sqlserver.programming)
Loading