I have added C:\Program Files\Winzip to the path on my pc. I remoted to the server and added the path to the server that SQL Server 2005 is running on....

David.Poole (2/17/2006)

---

Firstly add the path of the WZZIP.EXE files to the PATH environment variable. Having done so restart MSSQLSERVER and SQLSERVERAGENT. You should now be able to call...

SQL Server 2005 Standard edition

Microsoft SQL Server Management Studio9.00.1399.00

Microsoft Analysis Services Client Tools2005.090.1399.00

Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

Microsoft MSXML2.6 3.0 4.0 5.0 6.0

Microsoft Internet Explorer6.0.2900.5512

Microsoft .NET Framework2.0.50727.1433

Operating System5.1.2600

Microsoft Visual...

Phil

Now you have hit the nail on the head. This is all new to me. As you can see I am a newbie

Mark

Phil

I thank you again. This brings me back to my main question.

I have a Vb.net windows service project. I can run it from VS2005. However I...

Phil

I have had Appdev SQl Server Integration Service, I also have read from cover to cover Wrox Professional SQL Server 2005 Integration Service. What I need is experience....

Thanks Phil for all the help. Most Of my issues might be to lack on knowledge. This is the code I use in Vb.net I use the connect...

Phil

I tried to use the script task for this process. I had problems connecting to the database. for the table read.

There are never more then 20 - 30...

Hi There,

I used 'Execute Process Task ' in SSIS to call a VB Script that I had written.I also have used Execute Process task to call a third party vendor...

This code works great. But there are a few adjustments I need. But I cannot figure out how to do that.

🙂

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

...