Question about Parameter

Last Post 28 Jun 2002 04:37 AM by amosquera. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
amosquera
New Member
New Member

--
28 Jun 2002 04:37 AM
Hi,

I've a DTS package with

-2 connections to a SQL Server Database using a Microsoft OLE DB Provider for SQL Server

-a transformation task whose source is a query like this:
Select field from table1 where field2 = ?

I've a assigned a gloval variable to the parameter 1 ( the only parameter)

When I run the preview I get the next error:
Source of Error :"Microsoft OLE DB provider por SQL Server"
Description of Error : "values for some of the parameters have not been specified"

I've Sql Server 2000 SP2

I don´t understand why ?
Can anybody help me ?
Thanks
You are not authorized to post a reply.

Acceptable Use Policy