Hello All,
I'd like to run a sybase sp in a DTS package and insert
the results in a table in SQL Server 7. I was able to
create the connection successfully but do not know how to
accomplish the insert.
Thanks,
-Melounjan

In message <086801c3d3ce$f54f8960$a001280a (AT) phx (DOT) gbl>, Melounjan
<anonymous (AT) discussions (DOT) microsoft.com> writes
Never used Sybase, but assuming you can create an OLE-DB (or ODBC) DTS
connection OK, just add another SQL Server connection, then join the two
with a DataPump task (thick black line).

Enter the execute statement for the stored procedure as your source
query, then select the SQL server destination table, and finally use the
default transforms unless you require some more functionality/

If Sybase as the equivalent of the SET NOCOUNT ON option ensure this is
include at the top of your stored procedure code.


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

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

Darren, when I click on your reply all I see is message
unavailable. Could you post it again?
Thanks.

In message <041301c3d45c$e04824d0$a001280a (AT) phx (DOT) gbl>, Melounjan
<anonymous (AT) discussions (DOT) microsoft.com> writes
Here you go-

Never used Sybase, but assuming you can create an OLE-DB (or ODBC) DTS
connection OK, just add another SQL Server connection, then join the two
with a DataPump task (thick black line).

Enter the execute statement for the stored procedure as your source
query, then select the SQL server destination table, and finally use the
default transforms unless you require some more functionality/

If Sybase as the equivalent of the SET NOCOUNT ON option ensure this is
include at the top of your stored procedure code.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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