The only way I know other than OR'ing is a different select for each column like:

Select A from table where A is null

Select b from table where B is null

...

I...

I'm not sure what you are trying to do.

If the transformation or source has and error and you have configured the error output to redirect row the row SHOULD be...

It really sounds like a permissions error to me. Can the users who cannot run the report run the query directly using SSMS or Access?

What column has the 2 "squares"? Odds are they are carriage return & line feed. You could use Replace to remove them.

Again, if you provided a sample file...

Would this work?

[font="Courier New"]CREATE FUNCTION spf_IdHierarchy(@Id INT)

RETURNS XML

AS

BEGIN

   DECLARE @ret XML;

   WITH IdHierarchy (Id, IdLevel)

   AS

   (

   SELECT @Id Id, 1 IdLevel

   UNION ALL

   SELECT tob.ParentId, IdLevel+1

   FROM dbo.TreeObjects tob...

Could you attach a single file to the thread to work with?

It should be fairly straightforward with a flat file source with "##" as the column delimiter and the XML...

Is there a value for the maximum file size?

Could you or someone translate the error message to English?

I think it says that the execution of the dataset failed because it couldn't connect and that by default SQL Server...

SQL Server Agent jobs are protected by SQL Server security. From BOL:

Members of the SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole fixed database roles in msdb, and members of the sysadmin fixed...

Are you talking SQL Server 2005 or 2008? I don't think that 2.0 is required for 2008, but it is for 2005.

You can't use Set @var = column without a table reference. You want something like this:

[font="Courier New"]SELECT TOP 1        

   @shiftout = ISNULL(S.shift, 0),

   @operator_num = ISNULL(S.operator, ''),

   @pack_num =...

If you need to be able to recover to a point in time your database(s) should use the Full recovery model and you should be doing regular log backups, obviously...

If you cannot get a log backup from the current log then as far as I know you cannot get the data from 12:30 to 1:00. It will need...

Outlook has to be installed using the SQL Server service account and have a profile for that account. So you need a domain account for SQL Server to send...

Ahhh. I have done similar using a script component. It seems to work fairly well. It is a bit of a performance bottleneck because it has to...