overwhelming

The next thing I would do is to look through the Reporting Services trace logs on the server to look for a specific error.

\\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles

room

Do you have "Delay Validation" set to True for that connection?

Simon

I think your best choice is probably a script task. This link might help.

http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.html

Can you give a few examples of the folder names being generated? Also double check your file name expressions, maybe you have a missing \ or something. Is...

The error in the 32 bit mode is similar to a problem I have seen in the past where there is another task in your package that touches the file...

You might want to take a look at Andy Leonard's blog on creating frameworks for SSIS.

http://sqlbits.com/Sessions/Event9/Designing_an_SSIS_Framework

You could also take a look at this book. Chapter 2 has a very...

Try a .csv file instead.

uncertainty

How about

1.2 - FLOOR(1.2)

Floor returns the largest integer that is less than or equal to the numeric expression

wired

I ran into this problem, or at least a problem with the same symptom. The solution was to go back to the connection editor. On the All tab...

In your query

SELECT A, B, C, D, E,F From source table

WHERE Dfes_Number = @DFES_Number

change the @DFES_Number to a question mark

SELECT A, B, C, D, E,F From source table

WHERE Dfes_Number =...