I am working with SQL 2008. I have two databases on the same server
I am pretty new to SSIS packages and I'm trying to do the following:
Extract data from a table on database "prod", massage the data, and the insert it into a table in database "dev"
I don't know which type of task or data flow option to choose to do the massaging of the data. The source data has columns like "First_Name" and "Last_Name", by the target table just has a "Display_Name" column so I want to concatenate the two and then insert it if that makes sense.
Also I am using OLE DB Source and OLE DB Destination.. its the tasks in the middle that are giving me problems.
Any help appreciated