Create New Table

JDionne · Post by **JDionne** » Fri Oct 17, 2003 2:19 pm

I have a flat file that I want to import into a SQL server. I have defined the flat file threw manager. How do I get it to make the table automatacly?
Jim

chulett · Post by **chulett** » Fri Oct 17, 2003 2:47 pm

The target table on the SQL Server side? That would typically be as simple as checking off the "Create Table" in the stage you use to write to the target.

For SQL Server - assuming you are using ODBC - the "General" tab of the "Input" section has a check box labelled "Create table in target database". Select it and a new tab called "Edit DDL" will show up. This is where the "create table" DDL gets built and run by the job.

JDionne · Post by **JDionne** » Mon Oct 20, 2003 3:23 pm

Yup u are right i found it. Thanx
Jim

chulett wrote:The target table on the SQL Server side? That would typically be as simple as checking off the "Create Table" in the stage you use to write to the target.

For SQL Server - assuming you are using ODBC - the "General" tab of the "Input" section has a check box labelled "Create table in target database". Select it and a new tab called "Edit DDL" will show up. This is where the "create table" DDL gets built and run by the job.