To create a package that imports data
Need Screen shots in word for this query....these are the steps to complete
Â
Answer to Question 1
To create a package that imports data from the fi le you exported in Chapter 20 and into a new table (using the Import/Export Wizard), follow
these steps:
1. Working in an SSIS project in SSDT, fi nd a node in the Solution Explorer called SSIS Packages.
2. Right-click this, and choose the SSIS Import and Export Wizard.
3. Click through the introduction screen and fi ll in a data source as shown in Figure A-3.
4. For your destination, choose AdventureWorks, as shown in Figure A-4. Figure A-5 shows your source and destination selections.
5. Finish the wizard, and you’ll be left with a package that looks like Figure A-6.
Answer to Question 2
To deploy the package you created in question 1 and run it from the management studio, follow these steps:
1. Right-click the project and choose Deploy to launch the deployment wizard, and proceed to the Select Source screen shown in Figure A-7.
2. Set your destination path to /SSISDB/Chapter 20/Chapter20Project, as you see in Figure A-8. Figure A-9 shows the review screen at the end of the wizard.
3. Click Deploy to fi nish.
4. Having deployed your package, launch it from the Object Explorer in SSMS, as shown in Figure A-10.
Answers
Status NEW
Posted 08 May 2017 09:05 AM
My Price 8.00
-----------
Attachments
file 1494235298-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am
-----------
Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------.
-----------
Th-----------ank----------- yo-----------u
-----------
Not Rated(0)