Hey

I think we used named pipes when defining the connection.

Thank you for all your help!

The error message is:

Microsoft OLE DB Provider for SQL Server error '80004005'

[dbnetlib] [connectionopen Connect()).] sql server does not exist or access denied

Thank you!

I found out the error. When I use the like in the where clause the query runs much faster.

Thanks!

Thank you for your reply. I have checked the books on line. It mention that few connections that I should not be deleting them. Particulaly cmd such as:

AWAITING COMMAND

CHECKPOINT...

THANKS STEVE THE CLIENT IS TRYING NOW. HOPE IT WORKS!

hI Steve,

I am not an expert with window NT adminstration. Can you guide me on how I should go about doing the integrated security?

SELECT t2.wildcard

FROM Table_a t1 CROSS JOIN

...

Thank you Steve!

thankyou so much for all your help! my working environment is sql server 7.0!

Thank you so very much. It works but if the sp is encrypted then the script doesn't created. Am I right on this?

Hi All,

This is the package that I oppend in Visual Basic 6.0.

Option Explicit

Public goPackageOld As New DTS.Package

Public goPackage As DTS.Package2

Private Sub Main()

Set...

HI,

When I tried creating a package with sql server the error I'm getting is something like this:

[microsoft][odbc sql server driver][sql server] line2: incorrect syntax near '-'

Now I don't understand this...

Hi All,

I cannot seem to use the DTS Package to export procedures from the source database to the target database. Can someone tell me why I cannot import procedures?

Thank you!

...

IT SEEMS TO WORK. THANK YOU ALL!

HI All,

The steps I took to save the dts pacakage to visual basic is:

-right click on dts package

-(location) Visual Basic File

-(file name)my_pkg.vbp

Now I don't understand the part where I have...