Peter

Whenever you get an operating system error like that, go to a command prompt and type (for example) [font="Courier New"]net helpmsg 21[/font]. That will tell you what the message...

You could query the ExecutionLog table in the ReportServer database. Would that work for you?

John

In that case, I think I wouid use a Data Flow to dump that result set into a staging table, and then use a MERGE or UPDATE statement in an...

Let me check that I understand. Your first task contains a query like

SELECT ConcatenatedList

FROM SourceTable

from which the result set is

[font="Courier New"]ConcatenatedList

----------------

1,2,3,4,5,6,7,8[/font]

Your second task then uses that result set thus:

UPDATE...

You're making things too complicated. Your result set contains only one row, so change the result set to No Result Set and use output parameters in the Parameter Mapping...

Koen Verbeeck (3/5/2014)

---

Interesting question, but I do not agree entirely with the answer.

Setting the commit size to a lower value will commit batches before the entire load is done. What...

When you assign a result set to a variable, you're using a special type of variable (I think the type is called Object) that can hold a result set. ...

I'd say do away with the dynamic SQL and use a table valued parameter.

John

Use ROW_NUMBER, and join on a.RowNo = b.RowNo+1. Use COALESCE or ISNULL to deal with the NULL in the final row.

John

Will CURRENT_TIMESTAMP work for you? If not, how do you determine what "Day-1" is?

John

Abhas

You're going to need another job that polls the file folder at regular intervals. You can use xp_fileexist (undocumented, not sure that that's the correct name) or write your...

Vijay

The trouble with the SCD is that it processes one row at a time. If you are bringing in a lot of data, you might consider loading all the...

Why are you using dynamic SQL - why not something like this? I haven't checked the exact syntax, but you get the idea.

UPDATE Parts SET [TimeToTest]=

Convert(varchar, (select test...

I suspect that your error message tells you all you need to know, doesn't it? Just in case it doesn't, what does this return?

SELECT SUM(AMOUNT) FROM XACCD GROUP BY...

Use GROUP BY. If you show us what you've tried so far, we can show you where you're going wrong.

John