I've been programming since 1968. Programmed in most of the popular languages of the day.

About 12 years ago three of wrote an app in VB3. It's been upgraded to VB4...

Try this:

Dim i As Integer

Dim oNames As SQLDMO.NameList

Dim oSQLApp As SQLDMO.Application

Set oSQLApp = New SQLDMO.Application

Set oNames = oSQLApp.ListAvailableSQLServers()

For i = 1 To oNames.Count

      ' do something with  oNames.Item(i)

Next i

Try these.

CREATE  FUNCTION dbo.fn_PadLeft  (@String varchar(8000), @padchar char(1),@maxLen tinyint)

/*--=========================================================================

  Procedure ........... dbo.fn_PadLeft

  File Name ........... dbo.fn_PadLeft.SQL

  Author .............. Robert Nabolotnyj

  Date Written ........ 03 Aug 1999

  Purpose ............. Left pads...

"With our move out to a ranch style, multi-acre property..."

Have you considered a pony? Far more enviroment friendly.

I find no examples of how to use DTS programmatically in VB ....

Using the DTS Wizard, when you get to the Save, schedule and replicate package dialog, in the lower...