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#)?
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?
thx
md
*** Sent via Developersdex http://www.codecomments.com ***
> 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