OK, Step 1: Save out your package to vb

step 2: backup your original package and put it somewhere safe(just a precaution).

Step 3: Create a new standard Visual Basic project in...

If you change the SQL query part of the DTS package you will find that your transformations have been remapped, not nice!

If you are using SQL 2000 you could take...

We upgraded to 2000 about 6 months ago and still get the same problem. Not refreshing the GUI seems to be a general failing of SQL Server to date, hopefully...

We have encountered the same problem. Hit F5 a couple of times. The packages are still there, it's just the display that doesn't show it. Sometimes they come up with...

Very interesting discussion on backup restore vs detach re-attach.

Is there a technical reason for not using the copy database wizard for the whole thing?

Hi Ploster,

Am I reading your situation right?

You try to backup and restore your working database to another server,...

If you use refresh at RUN TIME it will affect performance because it will cause you to make another round-trip to the database. This is not what I meant. If...

Use the Refresh method of the Command object at DESIGN time, to populate your parameters collection, and save yourself one giant headache.

I think that you were correct with your original assumption. This is something that you can set in TSQL.

If you don't set the value in your stored proc it will...

Why not just use DTS?

You loose the ability to use the DTS designer thats built into SQL Server, but there is no requirement for SQL Server to be either...

OK to sort of answer my own question, I think that my problems in using a 4 part qualified nameing converntion to access the visual foxpro linked server is down...

Found this in BOL

. Use the Microsoft OLE DB Provider for Oracle

This example creates a linked server named LONDON Mktg that uses the Microsoft OLE DB Provider for Oracle and...