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

Newbie Question: Data Type Error for Output

Status
Not open for further replies.
jmeckley

jmeckley

Programmer
Jul 15, 2002
5,269
US
I am working on my 1st DTS. Very simple example from DevGuru. I have a global variable with a data type of variant (<other>). When I try to save my package I get the error message. Data Type Mismatch.

When I take the variable out it saves fine so I know this is where the error is.

I have the output parameter set to Rowset and the global vairable selected.

I am using Sql Server 2000 w/ Management Console 2 v5.1 SP 1.

Thank you for your help


Jason Meckley
Database Analyst
WITF
 
Status
Not open for further replies.

Similar threads

botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
154
botatun
botatun
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
291
markjoseph1232
markjoseph1232
Webkins
  • Locked
  • Question
SQL Server 2000 data redundancy question
Replies
1
Views
59
mrdenny
mrdenny
gquint
  • Locked
  • Question
DTS Error Handling with Muliphase Data Pump
Replies
0
Views
55
gquint
gquint
rss0213
  • Locked
  • Question
data transformation of BIN data?
Replies
0
Views
53
rss0213
rss0213

Part and Inventory Search

Sponsor

Back
Top