Below statements are answer for above question.

select...

arrjay (8/6/2015)

---

Hi there - I am trying to dynamically create the connection to a database within an SSIS package.

the requirement is to allow the user to pass through...

Yes. This is package having rights

Thanks 🙂

This is new script Task

Hi,

below link is my suggestion. But here data migration only happened.

http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx"> http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx

But I am also looking for If records are new it should be inserted or...

Hi,

As per Vipin requirement, we need to create 500 packages for 500 tables.

I think this is complicate solution for vipin requirement.

Hi Anshul,

If possible, Please post the solution.

Thanks

Rambabu

Actually this is for data migration from one DB to another DB

Hi Ankit

:-). Carry on man

Rambabu.

Hi Jayanth

you are giving nice solution. thanks for sharing.

Hi

SSIS is maybe the easiest.

Thanks

Rambabu

check your configuration file.

:-):-):-)

Hi All,

Please find the attachment. It may be the solution for above question.

Please tell me if any one having another approach.

Thanks

Rambabu