Hopefully the plans have attached successfully this time. Like I said before the use of views is to enable me to quickly prototype the dimensions for a data mart to...

Hi Guys,

I found a work around which seems to trick the query optimizer into working properly by comparing the Age_Band View to other dimensions that don't seem to cause the...

Hi,

I think we need to be more clear of the structure of the data the file and the relationships between the lines to answer this for sure. However it looks...

I guess there are some factors you should take into consideration like the size of your lookup tables and the complexity of your transformations and where your lookup are.

Are your...

Hi,

Using the advanced editor does work but I have quite few packages with this problem.

I'm pretty sure the problem is related to the MSSQLToSSIS10.XML mapping file but nothing I seem...

Hi,

The first place I would start is checking you can connect to and send mail via your SMTP server from wherever you are running the package using telnet. The following...

Hi,

You could write a function using the embedded code option in SSRS. This would enable you to use better string manipulation functions and error handling in VB.

Regards

Daniel

Hi,

The first error is probably related to the package ProtectionLevel property. Check out the following.

http://support.microsoft.com/kb/918760

Regards

Daniel

Hi,

An idea... Can you add a rownumber to the data set being returned by the query? If you could then you could put a filter on the first tablix of...

The SQL works fine. There is only one output from each of the CASE statements which are combined into one result with the bitwise AND (&) operator. The result will...

This should be about right but I can't run it assuming that if ANY of the columns are null the the value of the row is 0.

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

Select

intRequisitionId,

Sum(

Case

When dteFirstApproverDateNotified Is...

Your report is probably wider than your paper size when displayed. Ensure the Body width defined in the design preview + Margins defined in the Report properties is not greater...

If replacing the ???? with 1 doesn't work then I think you need to explain this better. Also do you need the CONVERTs?

Regards

Daniel

After trying just about everything to fix this we finally found what causes the problem and it appears to be Windows 2008 Service pack 1. Re-installing the OS without SP1...

You should be able to do this using an SSIS variable, passing it to the script using the ReadWriteVariables property of the Script task, updating it within the script and...