Question: In the Topic Materials, you learned about creating a basic package by using the SQL Server Integrated Services (SSIS) Designer in Business Intelligence Development Studio.
In the Topic Materials, you learned about creating a basic package by using the SQL Server Integrated Services (SSIS) Designer in Business Intelligence Development Studio. Using these resources, discuss how a database administrator can extract data from a database and convert date\time fields out of the data into a different format (DT_DBTIMESTAMP2 to DT_DBDATE).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
