Won't Microsoft OLE DB Provider for ODBC Driver work?

Since DTS can 'see' your ODBC, I'm sure you could create a liked server to it.

I'd stay clear of cursors in...

Create a linked server to the ODBC data source and use the linked server in your stored procedure or use OPENROWSET keyword..  Check OPENQUERY and/or OPENROWSET in BOL.

I would suggest you reinstall the Client Tools and Uilities on that workstation.

I got the same error on one of my servers last week. I've read all the KB articles but decided to watch that server and not apply the hot...

If you want to use the SQL Server Agent to launch scheduled DTS packages, you must install the IBM ODBC driver on the SQL Server system.

You should be able to set up replication from Standard Edition to Enterprise Edition. But the Standard Edition does not allow you to do Log Shipping. However, I've...

I guess this has to do with converting the characters to datetime variable. You may need to do an explicit conversion. If you show your code comeone may...

You may use the Dynamic Properties task for this.

You may need to have SQL Server start under the same domain account as SQLServerAgent. Also create the profile while logged in the SQL Server machine with the starting domain...

From EM, right click on the table, select All Tasks, and select Display Dependencies.

In QA or with T-SQL you may have to look into the sysdepends table (master database) for...

If you are not using the view to select the primary key column, you could remove that from the view definition like so:

<code>

ALTER VIEW dbo.VIEWTesting

WITH VIEW_METADATA

AS

SELECT testdesc

FROM dbo.TBL_Testing

</code>

This will...

Could you post your view creation code??

If you had a CustomerNo as the primary key in your table and accept user input via the CustomerNo, you wouldn't have this problem.

What logic would you use to know...

T-SQL has no concept of global variable in the way you described. So the solution you outlined is the way to go. You may however need some careful planning...

I don't use ColdFusion but if you have VB, add a reference to Microsoft DTSPackage Object Library in a new VB Project. Add a command button to a form and...