I'm sorry but "a Script Task with whatever C# code" is not really helping...

I would be surprised if nobody else would want to automate the SSRS feature to upload additional...

Not as a SSRS datasource, just store physical files (.csv's or .xlsx's) on the SSRS Report Server in addition to the .rdl reports. When I manually upload a file to...

Baskar B.V (7/27/2010)

---

if you have the flexibility of editing the ssis package if you need to restart the process.. then you can manually get the max value of the recordset...

Full...

No...

When I'm using this query

SELECT *

FROM [SERVER_B].database.dbo.table

EXCEPT

SELECT *

FROM database.dbo.table

to select the right data, I'm getting "Xml data type is not supported in distributed queries". I know there is a...

Baskar B.V (7/26/2010)

---

Is it also possible/necessary to adjust the max size of the transaction log? If yes, where can i do that?

And will this dataflow task be able to resume...

Baskar B.V (7/23/2010)

---

Questions:

- Is there a way to 'repair' the imported db? Since the data seems physically there on the hdd, and the row importing process went till 100%

- Is...

Although another location, F:\Tmp, seems to be working fine without the annoying error 😀

So thanks for the advice BlueTiger!!

I've now changed it to C:\Temp in the Environment Variables, restarted SQL Server, but getting the same kind of error with now C:\Temp in the msg....

GilaMonster (7/23/2010)

---

It's not...

The problem with this query is that when a record matches an OUTER case condition it passes to the inner case. So for the above every record where DATEADD...

To make life a bit easier I made a workaround using two columns:

First column is telling whether or not it's a A)3months/year upgrade or just the b) basic one,

second column...

Chris Morris-439714 (7/15/2010)

---

,CASE

WHEN DATEADD (year, 1, MAX(dd.ActualDate)) >= GETDATE() AND fo.Product IN (62,64) THEN 'Upgrade_Year'

WHEN DATEADD (month, 3, MAX(dd.ActualDate)) >= GETDATE() AND fo.Product IN (61,63) THEN 'Upgrade_3Months'

ELSE...

Thanks, and sorry for the late reply.

This query however is also not giving the desired results....

Now I'm getting either 'Upgrade_3Months', 'Upgrade_Year'...