Prev: Was subscription initialized???
Next: Replication Documentation
From: Chan Bing on 12 May 2010 16:03
I have a DTS task that worked fine and I'm trying to convert to SSIS. If
I run it manually its fine but within an SSIS package it fails on this
part:


SELECT tsh.medrec, tsh.dob, tsh.fname, tsh.lname, trk.trkdate, drs.init,
drs.first, drs.last, drs.ward

FROM trk
JOIN tsh on tsh.ibex = trk.ibet
JOIN drs on drs.num = trk.usr

WHERE convert(char(8), trk.trkdate, 112) = convert(char(8), GetDate(),
112)

The error says there is "one or more data source columns with the name
ward". How do I compensate for that in the query now?

Thanks,
CB

*** Sent via Developersdex http://www.developersdex.com ***
 | 
Pages: 1
Prev: Was subscription initialized???
Next: Replication Documentation