Re: Running Package From EM and Scheduler Problem
- From: jasinski.janusz@xxxxxxxxx (spadak)
- Date: 30 Jun 2005 23:23:55 -0700
No it is not a network share, just a local drive.
Regards,
Spadak
"=?Utf-8?B?UmF2aQ==?=" <ravishankart@xxxxxxxxxxx> wrote in message news:<8970A681-04A8-4D1D-A707-2F99A568761F@xxxxxxxxxxxxx>...
> Are you writing to network share folder?
>
> --
> Thanks
> Ravi
>
>
> "spadak" wrote:
>
> > Hi,
> > I created dts package that basicaly copy data from query to text file
> > and in next step removes this data from DB. Kind of backup to file
> > dts.
> >
> > To make each backup file unique I used Dynamic Property Task with sql
> > query that returns name of file based on date.
> >
> > Everything runs fine from designer, after each execute new file is
> > created as planned.
> > But when I try to run this from EM using execute on package or to
> > schedule it to job, everytime only one file is created and it's
> > overitten each time.
> > If there is no file in destination folder new is created but after
> > this only this one is used over and over.
> > Looks like Dynamic Property Task in not executed or result of
> > execution are chached.
> > I tried same thing with Acitve X script - result is same.
> >
> > Please help :)
> > Kind regards,
> > Spadak
> >
.
- Follow-Ups:
- Prev by Date: RE: Exporting data to Excel from a DTS
- Next by Date: Re: SSIS - How to use the old DTSStepScriptResult_DontExecuteTask?
- Previous by thread: RE: Exporting data to Excel from a DTS
- Next by thread: Re: Running Package From EM and Scheduler Problem
- Index(es):
Relevant Pages
|
