SSIS: Package Import/Export Wizard

Executing the Import/Export Wizard within a package.

Following the same steps to create a package in the Table to text file article, I begin with an SSIS Project and a starting package.

Instead of using the default package, I’ll delete it and select to create a new package using the Import/Export Wizard.

1-ie-wizard-within-package

After configuring the data source to the the (local) AW db, for the destination, I’ll choose a flat file and indicate its location.
For the file’s source, I’ll select a view and use “Preview” to review a subset of the expected data.
Next, I rename my newly created package to reflect its purpose. Also, I have a ready-to-use Data Flow Task.

4-ie-wizard-within-package

Now, I’ll execute my package; here’s my new list of Sales people.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s