One way would be to do the regular expression stuff in a Script Task (or Script Component - depending on how you do it). That will give you access to...

It all gets a little confusing when talking about "Null". I mean VB.NET has Nothing, C# has null and there is also NULL in the database.

When trying to distinguish between...

I believe Nullable Types are available from .NET 2.0 onwards. So you can have a Nullable DateTime type like this:

Dim myDate as DateTime?

The "?" at the end makes it a...

I assume it was either because:

1. Applcation should have been spelt Application :p

or (likely answer)

2. You did not have a reference to the required assemblies and/or did not import the...

A package cannot really "return" a datareader. As has been suggested, perhaps you can try storing the results in a variable and access it that way after the package has...

I don't quite understand what you're trying to do. If you want to execute a query and get the datareader back in the web service, why do you need an...

From my research so far (I'm very new to SSRS) I don't think this is possible using the Report Manager.

If you want to execute the entire SSIS package on a different server, then just use the sql server agent which supports this I believe. If you only want to...

Thanks for all the info. Gives me some things to look at. Cheers

Ok cool. Changing the datasource in the rdl is an option.

I was thinking of creating the reports with dynamic datasources (ie. the report would have the server and database as...

Not sure what you mean by "Null". Where is the value coming from? From a database call? If so, you may need to compare against DBNull.Value.

You don't necessarily need to use the winzip command line tool or anything else like that. If you do it in a script task, you can reference a library that...

Try this:

If Dts.Variables("JobSiteCode") Is Nothing Then

Dts.Variables("sJobSiteCode").Value = ""

Else

Dts.Variables("sJobSiteCode").Value = Dts.Variables("JobSiteCode")

End If

You can also use the following:

If IsNothing(Dts.Variables("JobSiteCode")) Then

...

Just note that there is no point in catching exceptions and then throwing them again without doing anything else.

When you say "compare files", do you mean compare them by file name or by content?