Perfect! Thanks Anthony.

Thanks Grant,

Appreciate your time.

Peter

Thanks again,

I've seen this product before and it looks like it's a good fit for the job but I have no budget.

Is there a free included product that can be...

Thanks Grant,

This is more about ensuring that ALL records have reached the SQL Server destination DB.

What can you suggest for this purpose?

Is there a SQL Server Compare type tool I...

Thanks Jeffrey,

That's it! I knew there was a logical explanation, so I'll leave the headings off for this process. Thanks again.

Thanks Phil, I appreciate your advice but this data is to be loaded into an CRM system that will only accept dates in this format.

I've since thought that I could...

Thanks frederico_fons,

I get what your saying as I've noticed that any transform I've been doing changes the data type to String. So I thought the best idea was to use...

Thanks frederico_fons,

Ok, I could create a Table that converts the Date (My date fields are in Data Type Date) to the 'YYYYMMDD' format

Can you help me change the Format without...

Thanks Phil,

Much appreciated.

Thanks PB_BI,

I thought it was something like that, I'll look at the link.

Cheers Peter

Thanks Steve, I went to that link & eventually got to the link below which has exactly what I wanted. Cheers Peter

--https://stackoverflow.com/questions/15757263/find-a-string-by-searching-all-tables-in-sql-server-management-studio-2008

DECLARE
@search_string  VARCHAR(100),
@table_name   ...

Thanks Jeff,

I'll have a read & give it a try.

Thanks again

Thanks Jeff,

I'm happy to learn, I'll have a read.

Thanks again.

Thanks but I've found the answer I was after.

This post shows a similar issue & the solution.

Search under Reza Rad  & Script-Component-as-Source.

I have adapted it to suit my project.

The script...

Hi Moderator,

Why are you removing my posts when they illustrate a solution that may be useful to others??