It's a bit hard to provide a solution when you haven't provided any details about your environment, table and query design

You could also try using a UDL file and select the OLE/DB driver for SQL instead of the ODBC driver.

Dug these up from the MS support site.

http://support.microsoft.com/?scid=kb;en-us;138541&spid=2852&sid=332

http://support.microsoft.com/?scid=kb;en-us;827422&spid=2852&sid=332

Sorry, got side tracked and forgot this.

Can you connect if you use the IP address of the server?

Peter Edmunds, actually the sp_ prefix does not necessarily indicate a System Procedure. It just so happens that MS used that prefix...

The big problem you are going to run into by executing the DTS packages from the web page is that they will actually execute on the webserver itself. Also, you'll...

Even if transformations are not required use the DTS BULK INSERT task, it's faster than BCP. For even better performance use the T-SQL BULK INSERT command in a stored procedure.

We...

How about this?

http://www.odetocode.com/Articles/215.aspx

Use a Dynamic Properties task.

Personally, I'd just set the properties of the connection to point to the appropriate server and database. Then you don't need to fiddle with dynamic SQL.

If you have to go...

Ok, so far we know,

a) you have a stored procedure that takes some parameters and inserts the data into a table

b) DTS is somehow involved as you're asking about "parametrised...

Are you trying to connect with an ODBC DSN, or using a connection string? What settings/string are you using?

I have a niggling thought that the problem could be related to...

From the error it seems your trying to connect to the SQL Server using TCP.

On the server you're trying to connect to, run the Server Network Utility and make sure...

Look up "Triggers" in your local copy of Books Online, or you can also view the information here,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_1tup.asp

In SQL 2000 these "Events" would be triggers.