Hi Brian,

Thanks for the reply.

Yes, it is consistently the same login and no there isn't anything special about the login - it's not the owner of the app role.

It's...

hI Gianluca,

Many thanks for your response and advice.

Cheers,

Stephen

Hi Phil,

Cheers. I think I'm in business now. Now that I can determine what tables are in the Access database I can direct the flow to process the tables...

Hi Phil,

Regarding the issue I was having with the ADO.NET Schema Rowset enumerator. It was all down to the index used in the variable mapping screen. The default value is...

Hi Phil,

Thanks again for your reply.

Yes, walking home I was thinking that the loop container must be sending more back than just a single table name.

I'll investigate setting...

Hi Phil

thanks for your reply.

Yes, you have the requirement spot on.

The access db can be names differently.

There maybe more than one access db but they will be processed sequentially.

I've...

Hi Phil,

Sorry, I should have been clearer.

When I mean type of table I actually mean the type of data in the table. There will be a number of...

Hi Ron,

Thanks for the reply.

A bit more background to my problem.

I can't use manual conversion wizards because the access database will be placed in a folder on a...

Hi Phil,

Thanks for the reply. I did try ISNULL but it still didn't catch it.

What did work was Col1 == "" ? "0" : Col1.

Strange why the replace didn't...

Hi Roy,

Thanks for the reply.

Yes, it's only a non-clustered index with 2 column composite key.

Cheers,

Stephen

Hi Damon, Lester

Sorry for not replying sooner. I will look into your suggestions.

Thanks,

Stephen

Steve/Sanjay,

Thanks for your replies, I'll take a look.

Has anybody had any experience of changing the -g startup parameter to 384MB on SQL Server 2000? Did it have any detrimental...

PW, thanks for the reply, I'll have a look at the article.

Sergiy, thanks for your reply. You say you have to use UPDATETEXT to update text fields. I was under...

Addict,

Thanks for you response.

Should really have looked in BOL myself, really.

Cheers,

Stephen