Create Table SQL Statement (SQL Server Import and Export Wizard)
Use the Create Table SQL Statement dialog box to view the statement that was generated automatically, or to modify it for your purposes. If you modify this statement, you may also have to make associated changes to column mapping, and you will have to maintain the edited SQL statement manually thereafter.
Integration Services generates a default CREATE TABLE statement based on the connected data source. This default CREATE TABLE statement will not include the FILESTREAM attribute even if the source table includes a column with the FILESTREAM attribute declared. To run an Integration Services component with the FILESTREAM attribute, first implement FILESTREAM storage on the destination database. Then, add the FILESTREAM attribute to the CREATE TABLE statement in the Create Table dialog box. For more information, see Designing and Implementing FILESTREAM Storage.
To learn more about this wizard, see Using the SQL Server Import and Export Wizard to Move Data. To learn about the options for starting the wizard, as well as the permissions required to run the wizard successfully, see How to: Run the SQL Server Import and Export Wizard.
The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.