Recent content by paulkeys

Hi, How about this... create table #temp(Name varchar(50)) insert #temp(Name) values ('Smith,Jane Ron'),('Dow,John L'),('Ali Welsh,Mary Jane') select Name, SUBSTRING(Reverse(Name),charindex(' ',REVERSE(Name),1)-1,1) from #temp drop table #temp

Sorry - missed a comma; = Switch( Fields!Disposition.value="Repaired","Completed", Fields!Disposition.value="NotRepaired","Not Completed", Fields!Disposition.value="MoveToNextLine","Not Completed", True,"UNKNOWN") )

You could trick the switch function - something like = Switch( Fields!Disposition.value="Repaired","Completed", Fields!Disposition.value="NotRepaired","Not Completed", Fields!Disposition.value="MoveToNextLine","Not Completed" True,"UNKNOWN") )

You should just be able to wrap this in a sum function - have you tried this approach?

Couple of ways i can think of... Switch expression in cell =switch( sum(Fields!whatever.value)=0," ", sum(Fields!whatever.value)=60,"24/36" ..... ) or write a custom function in the report based on vb Select Case, and then call the function from the cell, passing in the sum() value - may be...

Hi, No, running them from the file system is fine. Are you trying to run them from within the solution folder, or are you deploying the packages to a 'deployed' area? The package protection level is set within BIDS - can be thinks like 'Don't save sensitive', 'encrypt sensitive with user key'...

A few questions... Where are you running the package from - File System, SQL? What is the package protection level for the package you're trying to run. What version of SQL Server are you using (2005/2008) and is it 32-bit or 64-bit. What are the data sources being used in the package (are...

These look pretty good. If you dig around a little on the website you can also view training videos from previous months. http://www.sqlservercentral.com/articles/webinar/71273/

I'd probably approach this using a script task - iterate through the subdirectories of a particular root folder (which could be stored as a variable), and then use something like System.IO.File.Copy to copy the file from its original location to each of the relevant subdirectories.

how about select * from table where sdate <= getdate()

Assuming your doing this via textbox 'Go to report' action you can set the report to 'go to' via an expression. To carry on your example, the expression would look something like; iif(Fields!Type.Value="Widget","widget report",iif(Fields!Type.Value="Product2","Product 2 Report",""),"") If you...

Not sure if i'm missing something here but would the ISDATE() function not achieve what you need.... SELECT * FROM Modules WHERE ItemID = 123 AND ISDATE(SubItemContent)=1

As MDXer says - DT_WSTR is the Unicode datatype in SSIS. The function you posted contains lots of (DT_WSTR,2), which is the type cast to convert data to Unicode string, length 2

You can set default parameters within the report that will be used each time the report is previewed for development purposes, then remove before deployment

My book of choice was the wrox press one