Sunday, March 11, 2012

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.
> >.
> >

No comments:

Post a Comment