Use the Data Provider for Siebel with SSIS
You can use the .NET Framework Data Provider for Siebel eBusiness Applications (Data Provider for Siebel) along with SQL Server Integration Services (SSIS) to import data from a Siebel system into SQL Server database tables, flat files, or other compatible destination types. Specifically, you can create an SSIS package that can be executed to import this data.
To import data into the SQL Server database, use the SQL Server Import and Export Wizard, and provide a SELECT query to specify the data to be imported. The query must confirm to the semantics supported by the Data Provider for Siebel. For more information about the grammar for a SELECT query for the Data Provider for Siebel, see Syntax for a SELECT Statement in Siebel.
Note
The Data Provider for Siebel does not support using an EXEC statement with SSIS.
You can start the SQL Server Import and Export wizard either from the SQL Server Management Studio or from an Integration Service project in Visual Studio. This section provides instructions on running the wizard from both the SQL Server Management Studio and Visual Studio interfaces.
In This Section
See Also
Use the .NET Framework Data Provider for Siebel eBusiness Applications