I can think of 2 ways:

1) using the import / export wizard

2) create a linked server and use those in your stored procedures

1) if you want to import only...

I do not know if you have a native ole db provider for Teradata. For e.g., in the case of Oracle there's an Oracle provided OLE DB provider which is...

open command prompt and try

c:/> osql/?

if you have sql client components this would show the help, if not "not a recongnized command" etc

thats right! sounds more like a procedure problem. try with recompile, just to be sure that a wrong (not optimal) plan is not being stored for subsequent executions

is the new server running sql 2005 express edition, because the express editions come with remote connections shut off, by default. you can change it though by using the surface...

I think you can only control it by designing the report differently. may be I am wrong, but during export is definitely not when you can do something about it.

Yes, by using the rs command line utility.

you need to write a script file that would serve as the input file to the rs command.

besides you need to mention the server...

Could you pls show me how you are building the expression for connection string... based on ReportParameters / some variables??

perhaps i'm ignorant, but i could not see any other way than to use a preset...

you can use declare it as a global paramter and pass the filename as a parameter to the DTS while calling dtsrun (commandline).

so, you can write a simple wrapper program...