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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS, Limit on Globalvariables in wizard?

Status
Not open for further replies.
Bazzer

Bazzer

IS-IT--Management
Sep 11, 2000
6
0
0
NL
Hi,

I wanted to create a package with multiple steps which required the same values as arguments to various stored procedures. However, I found that once I tried to use more than three global variables (I wanted to use five), the wizard wouldn't accept query.

e.g. sp_mystoredprocedure ?,?,?,?,?

I solved the problem by creating the package directly in Visual Basic. Is there a bug in the wizard or is it a problem of my installation?
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
156
Andrzejek
Andrzejek
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
103
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
118
SaltyTheFrog
SaltyTheFrog
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
223
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
77
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top