Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Sat, 6 Sep 2008 06:43:49 -0700 (PDT),    group: microsoft.public.sqlserver.dts        back       


Alternative (or solution) to DTS Parameter ?   
Morning All,

I've got a DTS package that takes data from a Pervasive Database into
a SQL Database.

In the query I am using a WHERE clause that instead of your normal
"column name between variable x and variable y" I am doing a "variable
x between column name a and column name b"

When I subsitute the variable x with the parameter ?, I am getting an
error "Incompatible types in expression".

The parameter is set as a string...is there are different way to
"wrap" the ? so that Pervasive sees it as a string?

Thanks,

Steve
date: Sat, 6 Sep 2008 06:43:49 -0700 (PDT)   author:   unknown

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us