turn on the package logging to have a better picture..

it says conversion error; may be the data for column "folderSchoolDate" have special characters that require unicode settings to be set..

http://www.sqlservercentral.com/Forums/Topic1337063-391-1.aspx

shahsn11 (7/31/2012)

---

Hi,

I might not be able to put my question in proper way so let me put the same question other way around.

-------- //some logic

-------- //some logic

where empid = (select...

can you provide the DDl and more clarify your problem ...

can you provide the DDl and more clarify your problem ...

declare @b-2 int =null

declare @id int=6

declare @i int=0

while (1=1)

begin

select @id= ISnull((select d from #datatable where D=@id),(select b from #test where a=@id ))

select @b-2=d from #datatable...

create table #test (a int,b int)

insert into #test values(1,0),(2,1),(3,1),(4,2),(5,2),(6,2),(7,4)

create table #datatable(

D int, Name varchar(20),somedata varchar(20))

insert into #datatable values

(1 ,'A' ,'xxx'),

(2 ,'B' ,'yyy'),

(5 ,'C' ,'zzz')

declare @b-2 int =null

declare @id...

create a dataset using the above...

Lokesh Vij (7/28/2012)

---

not just the best, also...

demonfox (7/28/2012)

---

Yes agree with...

Yes agree with this...

Lokesh Vij (7/27/2012)

---

First of all, your table ISIR should have enr_id added otherwise it does not make any sense to have two dateadded fields for one stu_id

Here is one more...

try the data viewers to analyse the nature of data , if it's the conversion issue you may have corrupted data.

-- you can put the logging events for the task...

WITH test_credit AS(

SELECT * FROM Enroll WHERE Credits>15)

SELECT * FROM Enroll b

LEFT JOIN

ISIR a ON b.Stu_Id=a.Stu_ID

LEFT JOIN test_credit c

ON c.stu_id=a.Stu_ID

WHERE a.DateAdded is null

OR (b.Credits<40)

AND c.credits is null

This should do...

My mistake ; better not put surprises ...

thanks for correcting ..