LOOKUP component does not have AlwaysUseDefaultCodePage property

Is there any reason for this?
It doesn't make sense to me. After all, we're hitting OLE DB sources with it - if the OLE DB Source component has this property, why not LOOKUP component?

-JamieHi Jamie,

The problem here is that this particular property was added very late to the OLEDB source, furthermore, the lookup component handles its sql statement quite differently from the oledb source so it wasn't trivial to add it (not that it was trivial for the oledb source either its just that the oledb source was written in a way that was considerably more straightforward to add it than for the lookup).

HTH,
Matt|||OK Matt, thanks.

I've raised something via the product feedback centre about this for the future.

-Jamie

Looking to copy from hosted server to sqlserver express

We have a small sqlserver express database that is hosted. It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?
Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?

Looking to copy from hosted server to sqlserver express

We have a small sqlserver express database that is hosted. It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?

Looking to copy from hosted server to sqlserver express

We have a small sqlserver express database that is hosted. It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?