Need help with "dtsrun"

[k108]

Hi,

I need to use dtsrun to export data in a table to a text file.

I looked in BOL online, and it shows all the arguments to use with dtsrun, but doesn't explain how to use the arguments (see below)

I am assuming I need to use the import/export package with dtstun in order to make this work.

Any ideas on where to get detailed information about dtsrun?

Thanks

=====================
dtsrun
[/?] |
[
[
/[~]S server_name[\instance_name]
{ {/[~]U user_name [/[~]P password]} | /E }
]
{
{/[~]N package_name }
| {/[~]G package_guid_string}
| {/[~]V package_version_guid_string}
}
[/[~]M package_password]
[/[~]F filename]
[/[~]R repository_database_name]
[/A global_variable_name:typeid=value]
[/L log_file_name]
[/W NT_event_log_completion_status]
[/Z] [/!X] [/!D] [/!Y] [/!C]
]

 

[NoCoolHandle]

Ok... just a guess.You dont have a password on your package..

Assuming you have it saved to the default (MSDB) location

DTSRUN -SServerName -Ppackagename

 

[MDXer]

if the only function of this package is to output data to a text file why not use BCP? Then you don't have to worry about the DTS package.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[k108]

Yeah, I'm beginning to think DTS is overkill what I'm attempting to do, which is quite simple actually. I just want to write a text file!

But for some reason I remember reading NOT to use BCP, that it's not going to be supported in SQL Server 2005.

 

[MDXer]

hmmmmm I haven't head that in 2005 but I will definately look into it.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck