Is it possible to call a Sybase stored procedure from DTS using the
Execute SQL Task. I'll expect to pass input variables from global
variables and receive a result set from the stored procedure. Looks
like this is no problem with SQL Server.

The Sybase connection will be via ODBC.

Thanks in advance.
John

In message <qVqtd.100853$7i4.66204 (AT) bgtnsc05-news (DOT) ops.worldnet.att.net>,
John Doody <perseid (AT) worldnet (DOT) att.net> writes

The Sybase provider does not support (implement) parameter support, so
you need to do it the hard way -

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Is this true for database views also? Thanks.

Darren Green wrote:

In message <ixlud.110821$7i4.110553 (AT) bgtnsc05-news (DOT) ops.worldnet.att.net>,
John Doody <perseid (AT) worldnet (DOT) att.net> writes
This is true for parameters, so regardless of the object you cannot use
parameters through OLE-DB. This is not the same as a stored procedure
parameter, it is only when you use the ? token for an OLE-DB parameter
in the SQL. The view SQL may look like this and would work against SQL
Server -

SELECT Col1, Col2 FROM ViewName WHERE Col3 = ?


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org