> When running a DTS package, I often get the following error:
> OLEDBProperty '....' already exists in the collection.
>
> The name of the property is allways different, like 'Data Source Name1',
> 'User ID', etc.
>
>
>
> Thanks for any advice.
>
>

"Jose Inacio Menezes" <producao@textilcaesdepedra.pt> wrote in message
news:egno8vhLEHA.3216@tk2msftngp13.phx.gbl...
> Forcing the principal tasks to execute on the main thread, seams to
correct
> the problem.
>
> Thanks to Darren Green.
> He gave me the idea from his reply to a post below :
> 'DTS Error
> EXCPETION_ACCESS_VIOLATION'
>
>
>
> "Jose Inacio Menezes" <producao@textilcaesdepedra.pt> escreveu na mensagem
> news:eeyscqfLEHA.1644@TK2MSFTNGP09.phx.gbl...
> > When running a DTS package, I often get the following error:
> > OLEDBProperty '....' already exists in the collection.
> >
> > The name of the property is allways different, like 'Data Source Name1',
> > 'User ID', etc.
> >
> >
> >
> > Thanks for any advice.
> >
> >
>
>

> Not sure what provider you are using, but setting main thread on is a
valid
> solution if the provider is non-thread safe which can be the case, and
> certainly looks like it here.
>
> Cheeers
>
>
> --
> Darren Green
> http://www.sqldts.com
>
> "Jose Inacio Menezes" <producao@textilcaesdepedra.pt> wrote in message
> news:egno8vhLEHA.3216@tk2msftngp13.phx.gbl...
> > Forcing the principal tasks to execute on the main thread, seams to
> correct
> > the problem.
> >
> > Thanks to Darren Green.
> > He gave me the idea from his reply to a post below :
> > 'DTS Error
> > EXCPETION_ACCESS_VIOLATION'
> >
> >
> >
> > "Jose Inacio Menezes" <producao@textilcaesdepedra.pt> escreveu na
mensagem
> > news:eeyscqfLEHA.1644@TK2MSFTNGP09.phx.gbl...
> > > When running a DTS package, I often get the following error:
> > > OLEDBProperty '....' already exists in the collection.
> > >
> > > The name of the property is allways different, like 'Data Source
Name1',
> > > 'User ID', etc.
> > >
> > >
> > >
> > > Thanks for any advice.
> > >
> > >
> >
> >
>
>