You have got a lot of problems here chief.  I'm guessing you've copied some VBA code but that wont work the same.

• The call to Workbooks.OpenText should not be in...

The subscription configuration, including email addresses, are encoded as XML so your ampersand will be encoded to

&

You can see this in the ReportServer.dbo.Subscriptions table ExtensionSettings column.  I...

The function you've provided doesn't do what you've described tbh. If you want to do as described I'd suggest using the ImportExcel module as it has all this functionality built...

Me three.  Having a revision history is pointless if you don’t have the history of previous versions to diff against.  All you know is something changed and you can’t reliably...

Analysis Services returns it's values as text even if it's a number. You usually wont notice as it gets implicitly converted during most operations - however not in a...

Sure. So if you can do what I said above (apologies if the edit was after you started your post) then you would call the function in your stored...

For multi-valued parameters SSRS will pass a comma-delimited string to a stored procedure.

Could you elaborate a bit, are you trying to split the parameter in the stored procedure by a...

--DROP TABLE #tblStructure;

--DROP TABLE #tblItems;

CREATE TABLE #tblStructure (

VCode INT, [Name] VARCHAR(255)

)

CREATE TABLE #tblItems (

VCode INT, [Name] VARCHAR(255), StuctureVCode INT

)

INSERT INTO #tblStructure

( VCode,...

MMartin1 (9/29/2016)

---

In the SSIS expression builder , enter:

(DT_DATE)((DT_WSTR, 4) year(getdate())+"-"+ REPLICATE( "0", 2-LEN((DT_WSTR, 2)(month(getdate())+1) )) + (DT_WSTR, 2)( month(getdate())+1) +"-01")

EDIT : This will give you the...

Size and position cannot be set by expressions or custom code and even so you'd have to have chosen portrait or landscape at design time so the report will still...

The expression can be used as a Variable's expression, however Ken's solution kind of makes it a moot point now. 🙂

The code I posted is a SSIS expression so it can be used in the derived column transform.

Hi Kazmerelda,

The approach I usually take for things like this is to adjust the dates rather then try to parse strings.

DATEADD("MONTH",DATEDIFF("MONTH",(DT_DATE)"1900-01-01",GETDATE()) + 1,(DT_DATE)"1900-01-01")

We get the number of months between the...

Probably the easiest way to do what you are trying is to just pass the string to a derived column transform and try to cast it e.g. (DT_DATE)PolicyStartDate. If...

Slightly puzzled here - you are using date functions on PolicyStartDate in your expression. Are you importing the column as a DT_DATE already?

Also are you planning on writing...