DTS - With Conditions

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
PrabhatHi 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 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 g
et
> 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 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@.discussions.microsoft.com> wrote in message
news:31D82797-6A69-4ECF-AE96-3845AC1FA694@.microsoft.com...
> 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:
>
that
TARGET
from
get
file. My
possible?)|||If the file already exists, u can over write the file
"Prabhat" wrote:

> Hi Chandra,
> Thanks for the hint. But I believe that In the Import / Export we can star
t
> a Wizard if the file does not exist.
> Thanks
> Prabhat
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:31D82797-6A69-4ECF-AE96-3845AC1FA694@.microsoft.com...
> that
> TARGET
> from
> get
> file. My
> possible?)
>
>|||That is not a problem. But how Do I start the wizard if the file does not
exists?
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:B9016AB0-D40E-4EAF-A5A9-66D3326F267A@.microsoft.com...
> If the file already exists, u can over write the file
> "Prabhat" wrote:
>
start
This
the
procedure
folder if
name
will