DTS Programming Help

Hello,
I need to export all objects from a database to another database by programing in VC, but MSDN's example is in VB.
It is possible to use "TransferObjectsTask Object" in VC.But I don't know program step. Can you help me? thanks.Originally posted by n_fsk
Hello,
I need to export all objects from a database to another database by programing in VC, but MSDN's example is in VB.
It is possible to use "TransferObjectsTask Object" in VC.But I don't know program step. Can you help me? thanks.

you can make the DTS pacakge that does what u want (using Transfer Database task, etc.) and then save the DTS package as a VB file. You can then look at the code in VB for the DTS packages

DTS package

I am tring to back up my remote site's data to my computer here at home.

I use DTS wizard from EM and copy objects and data (is this correct?)

Then I choose to save the package as SQL package, give it a name and times to run etc.

However I can't find where it has saved if indeed it has.
I've looked under SQL server agent jobs and management local packages but it's not there.

I'm sure I'm doing it all wrong!

Thanks for any advice.

JBDid you create the package on Your computers Sql Server or on the Remote Server? I am sure that is the problem. Check both locations.|||Thanks Wes,

But.. how on earth do I create this on the remote Database?

JB

DTS in ASP NET

How can execute a DTS from asp net. I'm using com reference Microsoft DSTPackage Objects and the LoadFromSQLServer method but nothing happend, no error, no message, nothing.
Someone know how can i execute a DTS from asp net?

THANKKSSS!!!Try this url it is run by a SQL Server MVP. Hope this helps.

http://www.sqldts.com

Kind regards,
Gift Peddie|||THANKSSS!!!! IT'S HELP ME!!!!!

DTS Import Wizard fails

I am trying to copy updated tables from a DB on a remote SQL server to
my pc using import wizard. I choose "copy objects and data between SQL
Server databases". On the screen "Select objects to copy", all of the
options are unchecked/blank including the script location. Clicking
"select objects" causes the wizard (and enterprise manager) to crash.
An error message refers to mmc.exe. Any ideas?Hi

This sounds like an error with EM itself, is this a one off or re-creatable?
You may want to check that the client tools are up-to-date. To avoid network
problems, it may be easier to restore a backup to a copy database and then
do the updates.

John

"SkyBlue" <aajjww@.postmaster.co.uk> wrote in message
news:60c756c.0407300546.664df6ba@.posting.google.co m...
> I am trying to copy updated tables from a DB on a remote SQL server to
> my pc using import wizard. I choose "copy objects and data between SQL
> Server databases". On the screen "Select objects to copy", all of the
> options are unchecked/blank including the script location. Clicking
> "select objects" causes the wizard (and enterprise manager) to crash.
> An error message refers to mmc.exe. Any ideas?