Question: Develop a SSIS package that will import the data in the file attached ( SampleCurrencyData . txt ) to a table in AdventureWorks 2 0
Develop a SSIS package that will import the data in the file attached SampleCurrencyDatatxt to a table in AdventureWorks called 'WeekSSISImport'.
Include the sql file that was used to create the table. Determine the necessary data types for the table.
DO NOTdeclare all field types as varcharlength here
DO NOTalter the data in the file. It needs to be loadedEXACTLY as it is in the file to the table.
Use appropriately named variables where needed connection strings, field names, etc.
Use expressions for those variables.
Create a folder for this Visual Studio project on the desktop of your VM called Week SSIS Import and name the project files appropriately DO NOT accept the default names Visual Studio provides Ensure that all project files are in this folder.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
