DTS question

I have package that Extracts a zip file. Now the zip file is updated bi-weekly between 9-11am. So the DTS package is schedule to run at 9am. Once the zip is extracted it is renamed (different from original).

But before extraction, i have a few tasks that check whether the zip exists or not.

PROBLEM: If the zip new file exists at 9am, it's all good and the package will be successful. The problem i'm facing is, say the zip file is not available at 9am, I want the package to check if the file exists - every x minutes till 11am.

This polling for the file is creating a alot of problems for me.

Any help/advise would be appreciated.

ThanksHello!

I assume that you have an ActiveXTask as one of the first steps in that DTS Package, that checks the existence of the ZIP-File.

If you make this task loop until it finds the ZIP-File, that would be the first step. In this loop there should be a command that calls a VBScript with something like "WScript.Sleep 600000" (which should stop the script from continuing for 10 minutes!).

Hope that gave you some hints!

Greetings,

Carsten

Originally posted by vmlal
I have package that Extracts a zip file. Now the zip file is updated bi-weekly between 9-11am. So the DTS package is schedule to run at 9am. Once the zip is extracted it is renamed (different from original).

But before extraction, i have a few tasks that check whether the zip exists or not.

PROBLEM: If the zip new file exists at 9am, it's all good and the package will be successful. The problem i'm facing is, say the zip file is not available at 9am, I want the package to check if the file exists - every x minutes till 11am.

This polling for the file is creating a alot of problems for me.

Any help/advise would be appreciated.

Thanks

DTS package Error

I'm almost new to this one:
I run a store procedure that extracts data from one table.
When manually run, the results returned is what is
expected. But when I try to create a dts package to
export the data to a text file, I get this error:
Error Description: Null accessors are not supported by
this provider.
Can someone help me with this? Thanks.
Mary.I fixed my own problem. I just recreated the package from
scratch and it worked. I don't know why I had that error
in the first place - so if anyone knows, please share your
response with me. Thanks.
Mary
>--Original Message--
>I'm almost new to this one:
>I run a store procedure that extracts data from one table.
>When manually run, the results returned is what is
>expected. But when I try to create a dts package to
>export the data to a text file, I get this error:
>Error Description: Null accessors are not supported by
>this provider.
>Can someone help me with this? Thanks.
>Mary.
>.
>|||Its possible that the MDAC version of the EM used was either higher than
what is currently on the server.
--
Olu Adedeji
"Mary Moore" <anonymous@.discussions.microsoft.com> wrote in message
news:6f8a01c40215$fbb3f460$a501280a@.phx.gbl...
> I fixed my own problem. I just recreated the package from
> scratch and it worked. I don't know why I had that error
> in the first place - so if anyone knows, please share your
> response with me. Thanks.
> Mary
> >--Original Message--
> >I'm almost new to this one:
> >
> >I run a store procedure that extracts data from one table.
> >When manually run, the results returned is what is
> >expected. But when I try to create a dts package to
> >export the data to a text file, I get this error:
> >
> >Error Description: Null accessors are not supported by
> >this provider.
> >
> >Can someone help me with this? Thanks.
> >
> >Mary.
> >.
> >