June 20, 2005 at 2:52 am
Can i write code in .NET instead of Activex script ????
June 21, 2005 at 2:12 am
Only by writing a separate .NET application/library and executing that using xp_cmdshell, the execute process task or an ActiveX script that uses the windows scripting host objects to execute your program.
All this changes in SQL Server 2005 however where you will be able to write your stored procs etc in the .NET language of your choice.
June 21, 2005 at 7:38 am
Alternatively, you can write a Custom DTS task in any managed code as long as its made available for interop. You can write a completely custom task in managed code and have it leverage the framework and have it available in the SQL server DTS toolbox as a custom task. Here's some links, its not as hard as it may sound.
http://support.microsoft.com/?kbid=326909
http://support.microsoft.com/kb/319985/EN-US/
http://support.microsoft.com/default.aspx?kbid=810581
Paul Krasucki, MCAD
June 23, 2005 at 5:47 am
Very thanks , this articles is great and also xp_cmdshell is great and i wasn't hear about them before .
but i still having aproblem with greating a custom DTS task (i did every thing in the article and when i go to dts services and try to register the custom task .... error .... couldn't find entry point for "dllregisterserver" in the dll)
And I have another question.
What is the best way to use office web component (OWC) with ASP.NET (i really hate to write script and i want to write .NET code in the code behind file)
Again thanks very much
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply