Not sure if this is the most efficient method, but the below should work - would help to see the rest of the query as it may be easier to...

Fairly sure you would have to create some vba code in order to achieve this, which would open the required record set and the loop through each record doing as...

Did you try willems comment - the workflow looks as I would expect it to - wanted to ensure the error parts were in the container and not outside...

Are you able to upload a screen shot of the control flow ??

Fairly sure you will be able to adapt the method for importing multiple files shown here

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

provided that the definition of the xml files are the same and that they are...

is the entereddata an actual data time or just a date ??

This could be a reason for the difference but would need to see exactly what was being passed through

Pretty sure that would be a temporary sp - so would be stored in the tempdb...

guessing - but could it be that the app is creating the sp as part...

not trying to be smart - but have you opened and IS project and not a RS one ?? Just a thought as if you were in a RS...

doh !!! brain not woken up properly today...

should be able to use

select host_name()

I'm not sure you can do that - could be wrong and have been before - think I would be looking to get the application name passed into the stored...

join the two table and add to the where calsue to specify where the working day = 'Yes'

something like

select Registration

,count(workingday)

from a

inner join b

on b.date between a.startdate and a.enddate

where b.workingday =...

Have you tried the Reset ToolBox option....

failing that I would uncheck them all - ok it - then choose them all again...

A more complete example.....

declare @Dates table (Dt smalldatetime)

declare @StartDate datetime

declare @Days int

set @StartDate = '20090101'

set @Days = 365

while @Days > 0

begin

set @Days = @Days -1

insert @Dates values (dateadd(dd, @Days, @StartDate))

end

declare...

would be something along the lines of

select a.StartDate, b.EndDate

from TableSource a

inner join DateTable b

on b.Dt between a.StartDate and a.EndDtae

I would use a Executre SQL Task and pass in the parameter name...

I would also probably use just the one container with a failure precedence after the dataflow instead of...