Hi All,

I have DTS which uses global variables and dynamic mapping to map to the
variables as per the parameters that i send from the Stored procedure that
used to call / execute the DTS.

My DTS has to export data from a SQL Server (Join Based Query) to a TARGET
..DBF file.

problem 1: How do I create the target .dbf file in the specied folder if
that does not exists? I pass the target folder name and dtf file name from
Stored Procedure and that has to be mapped for the dBase Connection.

problem 2: If the Query (that will get executed before the dbf file will get
create) does not return any rows then I dont want to create the dbf file. My
DTS should stop there by logging some message in log (if this is possible?)

Please suggest.

Thanks
Prabhat

Hi Prabhat,

Please try to use Import-Export whizard tool available in SQL Server. This
is a whizard to program your DTS aswell.

You can then save the steps as a DTS package

hope this gives a hint on how to go about

thanks and regards
Chandra


"Prabhat" wrote:

Hi Chandra,

Thanks for the hint. But I believe that In the Import / Export we can start
a Wizard if the file does not exist.

Thanks
Prabhat

"Chandra" <Chandra (AT) discussions (DOT) microsoft.com> wrote

If the file already exists, u can over write the file

"Prabhat" wrote:

That is not a problem. But how Do I start the wizard if the file does not
exists?


"Chandra" <Chandra (AT) discussions (DOT) microsoft.com> wrote