BIDS
Step 1:
Step 2:Double-click on the Data Flow Task to navigate onto Data Flow pane
The package is saved as dtsx file.
How to save a copy of dtsx file to MSDB database?
- Close the project
- Open it again
- In the solution explorer, double-click the project,
You can save the package to SQL Server.==
How does the Lookup transformation work?
