Hi,

I am tring to export a table to a text file using dts. I
want to provide a name for the output text file using
input parameter to a function in Active X Script (or) in
some other way. Is it possible? I don't want to use VB
project.

Please help if anyone has any suggestions.
Thank you in advance.

Rajah V.

Check the following for a sample on changing the destination
file:
http://www.sqldts.com/default.aspx?200

-Sue

On Fri, 5 Sep 2003 10:57:06 -0700, "Rajah Venkata Krishnan"
<rajah.venkat (AT) analytics-usa (DOT) com> wrote:

Thanks for your reply Sue.
But, I want to provide name for the output file name
dynamically and the file name can be different everytime.
Can it be done? Any help is very much appreciated.

Rajah V.

Yes...depending on what version of SQL Server and what you
mean by providing the name. If you are going to use DTS
itself interactively then take a look at:
Open File Dialog Custom Task
http://www.sqldts.com/?226
If you are using another application to do this, you could
use the Dynamic Properties task (SQL 2000 only). As an
example, you could do something like have a table that
stores the file name and read from that table. The
application could just update the value in the table prior
to running the package.

-Sue

On Fri, 5 Sep 2003 11:58:57 -0700, "Rajah"
<rajah.venkat (AT) analytics-usa (DOT) com> wrote:

We are using sql 2000.
We are not allowing our users to execute dts packages
directly.
Our idea is to export a table through a dts package to a
text file. DTS package will get initiated through ACCESS
2000 vba module. Everytime the output text file name
changes and we should able to provide a new file name for
output either thru ACCESS 2000 function to DTS Package as
a input parameter or thru stored procedure which will
initiate dts package.
I believe my question is clear now.
Thanks for your current and future help.

Rajah V.

You have a lot of options on how you can do what you want
and of course there are advantages and disadvantages to each
option. But if you want to limit most of this to being
called, controlled from vba in Access, then you may want to
consider just using the DTS Object model to do all of this.
Create a reference to the DTSPackage object library. You can
set the export file name to a variable in your code and
execute the package using LoadPackageFromSQLServer.
You can find pretty good examples on it at the same site I
sent links to you on already. Try this one:
http://www.sqldts.com/default.aspx?208
The other options I kind of suggested and you can find more
twists on these if you look around that sqldts.com site.


-Sue


On Fri, 5 Sep 2003 13:38:52 -0700, "Rajah"
<rajah.venkat (AT) analytics-usa (DOT) com> wrote: