Thank Aaron for the Tip. Dynamic SQL is a pain anyway but in some situation you are forced to use it.

Thank you Jeff. Your code worked well.

I was hoping to code it in Dynamic Query and loop through the table, still bother me it did not work 🙁

Make Sense Jeff.

Now I have to go and play with SSDT..Thanks Phil for the info.

Thank you Mark.

My 2 last quick questions:

1-if I build a SQL process and I needed a user to run the code (process) on demand not Thru a SQL job. Is...

It seems we do not have any standard to follow (not even MVC). Do you know of any resource/link to best practice to follow with regards to naming convention.?

Sounds good. Thanks for sharing.

Thanks

Thank you and Yes I did posted something 6 years ago as I was assigned to take over a project but was later dropped.

Make Sense.

Do you know how much is the license for Redgate?

I am more into having 3 different databases, I think it is a lot cleaner and easier to organize and maintain. I have 300+ table in one DB right now.

So if I elect to create 3 different databases. The first DB which is holding source data, should I create different schemas inside this database referencing the different data sources?

Anyone?..Any thoughts?

Thanks

1)Yes. Column names are always same regardless from table name.

2) The #tmp table is created basically from from tbl_src :

Select * into #tmp from tbl_src

3) data operation is applied...

Nice Thoughts newbie, I got the logging part but wasn't sure if I stay away from SSIS how I would automate this process.? Right now it is just a plain...

What I am getting for all the opinion is I need to break these 4K Line code to a smaller Chunks either multiple SP or multiple SSIS.

Will it be easy...