There's many ways to do this but without seeing your actual setup, it's hard to say what's best.

Sounds like using SSIS is a good idea. If the 2 servers...

You should be able to get all you need from these views:

INFORMATION_SCHEMA.TABLES

INFORMATION_SCHEMA.COLUMNS

sys.schemas

sys.tables

sys.columns

There may be other system tables or views that could be helpful. You just need to take the time...

Why do you want to do this? All the information in the script is already available in system tables and views.

I'm assuming that meant that table A is the table referred to right after FROM.

Example:

SELECT .......

FROM TableA

... JOIN TableB ON ...

... JOIN TableC ON ...

etc.

Before we get started, maybe you can tell us a bit about how much experience you have with SSIS.

Full outer joins? :w00t:

If I understand correctly what you're doing, you could have a table which acts as a log of what has been done or what needs to be done. Each...

I wonder...

SSNinja (7/31/2013)

---

What ever happened to civility? Is everyone born with equal knowledge and experience? No, it is gained day by day. We should be more courteous toward someone...

If you're getting more rows than you should after adding a join, it's probably because you should be joining to that table using more than just 1 join condition. ...

Revenant (7/31/2013)

---

Steve Jones - SSC Editor (7/31/2013)

---

. . .

So I get this is probably in jest and partially true, but it's insulting. It's not selling out any more than Android...

Phil Parkin (7/30/2013)

---

Please note that Script Tasks and Script Components are different things. Using the terms interchangeably will confuse people who know the difference.

Script Tasks are used in the Control...

You could also delete the files from withing the script component.

bitbucket-25253 (7/30/2013)

---

I would suggest purchasing the DEVELOPER EDITION, whose use does not run out with time. Cost is around $50 US dollars. It will allow you to save...

Check what data types are used both for and input, output, and in betweeen.