Correct syntax for dtsrun

Somehow I'm not getting dtsrun to work.

The server is local

The name of the package is ImportHosttrncs. It is saved under Local Packages.

There is no password.

Is this syntax correct?

dtsrun /Slocalhost /PImportHosttrncs

I recommend you try the DTS newsgroup microsoft.public.sqlserver.dts

-Jamie

copying table in a database

Hi good day to everybody,

Can we copy a table from a database and saved it into a diskette? Because i did not find or maybe i miss or doesn't know how to do it from EXPORT/IMPORT tools. The computer to where I attach the table is not connected on d'same network, and if I backup & then reinstall the whole database into that PC, all records in their will be overwritten by the new one which is not I wanted to be.Hi,

did you try to use dts? or copy you database to a webserver? or just copy your db to xml or a acces db ?

this could be intresting to you:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21261328.html|||Thank you for the link, But i did not find the simpliest way to transfer a table from a database into a diskette and put it into another database in another computer not connected on the same network where i will take a table.

|||Hi,
IMO, there is no other simple way to copy a table. The last post was quite right. You'll have to convert it to a different format so that your destination computer could open it. A good format is access database (*.mdb) if your destination computer has access installed.

SQLServer stores its table,database,triggers,etc... information in a (*.mdf, *ldf) files usually found in C:\Program Files\Microsoft SQL Server\MSSQL\Data. But you can't copy it directly. You must stop the server first...

Contrast to that, if you want to copy the entire database, you could use the bacjup database and just restore it to the destination computer...
cheers,
Paul June A. Domag|||Thank you very much & have a nice day...|||

Paul Domag wrote:

You'll have to convert it to a different format so that your destination computer could open it. A good format is access database (*.mdb) if your destination computer has access installed.

and then how can I import the MDB table into the destination SQL server?|||Hi,
To import data from Access to SQL. You could use DTS (Data Transfer Service? not sure on the acronym). Its a wizard that migrates data from other sources to SQLServer...

cheers,
Paul June A. Domag

Copying "My Reports" between users.

Is there a way to copy a report saved in a users "My Reports" folder to a different users folder? If so what permissions and roles do I need to be in?Using the default settings no user has enough permissions to do this. You would need each user to give you permission or you need to go in as an admin (local RS box admin) and modify the security permissions to give yourself permission.

Copy/move data from TableA in DB1 to TableB in DB2 within the same SQL Server

Hallo,
I thouhgt it would be easily done, but no. I have a copy of data i saved in
another DB while laying out the original Database i want to use in producto
n Envi. The Prodution DB is finally ready and i want to move the 3 columns
of data in the first Databs
e into a table in the new database. I have tried "select into", "copy" with
out success.
The old DBTable has 3 Columns of hundreds of rows that i must move to 3 simi
lar columns in a table (15 columns) in the new database. The old table does
not have an ID, but the new table does.
Can someone help. I want to show this to my boss tomorrow.
Thanks.How would you relate the rows in the two tables to each other?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Omooba" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D46104-7C63-4907-AB44-F8EC6FF860A4@.microsoft.com...
> Hallo,
> I thouhgt it would be easily done, but no. I have a copy of data i saved
in another DB while laying out the original Database i want to use in
producton Envi. The Prodution DB is finally ready and i want to move the 3
columns of data in the first Databse into a table in the new database. I
have tried "select into", "copy" without success.
> The old DBTable has 3 Columns of hundreds of rows that i must move to 3
similar columns in a table (15 columns) in the new database. The old table
does not have an ID, but the new table does.
> Can someone help. I want to show this to my boss tomorrow.
> Thanks.