TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
10
)
Can be access temp table from to 2 tables in sql
DB2 to SQL conversion