ImportSqlServer Object

SQL Server import.

 

Properties

 

Application Application

Returns application. Read only.  

 

ConverterItemSet Columns

Returns set of import columns. Read only.  

 

ComponentSet ComponentSet

Returns set of components created by the import. Read only.  

 

String ConnectionString

Sets or returns connection string. Read/write.  

 

ConvertPolicy ConvertPolicy

Sets or returns table import policy. Read/write.  

 

String DefaultExtension

Returns default file extension. Read only.  

 

String Filter

Returns filter string. Read only.  

 

String Name

Returns file format name. Read only.  

 

Any Parent

Returns parent object. Read only.  

 

ConverterPropertySet PropertySet

Returns set of import properties. Read only.  

 

Methods

 

String BuildConnectionString(String server, String login, String password, String database)

Composes a connection string for SQL Server client. All arguments except server are optional.

 

Boolean CanImport(ComponentType type)

Returns True if importer can read components of given type and False otherwise.  

 

Import(String table, ConvertPrompt prompt)

Imports table from the data source specified by the connection string.

 

Obtained From

 

Application (NewImport("SQL Server"))

 

See Also

 

Scripting Reference