Amudhan Kuppan

Amudhan Kuppan

  • NA
  • 378
  • 29.5k

SSIS(SQL Server Integration Services)

Mar 15 2018 4:23 AM
hi
anyone please help me
Requirement.
i have update data in database from another datbase so prepare dynamic script where database name fetch from variable and build a query using SSIS Package
this is my requirement
do not use SP for this u use only just simple SQL Query
for eg:
UPDATE t1
SET t1.[Name] = t2.[Name]
FROM [dbo].[Namelist] t1
INNER JOIN [IT TEST1].[dbo].[addresslist] t2 ON t1.[id] = t2.[id]
this is my update query
how to put this query in execute SQL task component
and one more thing you will create variables for dbname,tablename,SQL Query
i do not change query every time i want just change database name and table name
thats all anyone please help me

Answers (10)