Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to call Stored Proc from DTS COM

Status
Not open for further replies.
jmatte

jmatte

Programmer
Joined
Jan 31, 2001
Messages
6
Location
US
Any suggestions are appreciated.

I need to create a DTS task in VB6 to call a stored procedure in SQL Server 2000. I am using VB6 and the DTS COM interface. I've only found code samples using the ExecuteSQLTask.SQLStatement but I don't want to use any SQL in my VB component. I would rather keep all the data routines on SQL Server.

Thank you in advance!

Jen
 
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question Question
Pick up value from combobox
Replies
0
Views
796
bharons
bharons
Cpreston
  • Locked
  • Question Question
Seconds to minutes
Replies
5
Views
2K
Chris Miller
Chris Miller
dgillz
  • Locked
  • Question Question
How to convert varchar to time?
Replies
1
Views
1K
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question Question
need to udate table entry with number containing a *
Replies
11
Views
861
Chris Miller
Chris Miller
JustATheory
  • Locked
  • Question Question
Need to removed
Replies
3
Views
438
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top