Perhaps if you read the first article linked in my signature and posted according to those suggestions you might get better, more complete answers.

In SQL Server, by default, a trigger...

The SQL Server Agent is NOT included with SQL Server Express Edition. You would need to use SQLCMD and the Windows Scheduler.

Duplicate post. Please post answers here.

Do you have any explicit page breaks set in the report?

What are the margins for the report (found in report properties)?

What kind of transformations are you making to the data?

If you are not doing some major transformations than I would recommend that you just use T-SQL to move...

Oh...

Ditto. I also just registered to take 70-432 TS: Microsoft SQL Server 2008, Implementation and...

Looking at your report you need to place the textboxes in a list or use a table to display multiple rows. Without a list or table you only get...

Glad I could help. The key in SSIS Expressions is to remember that everything has to be typed correctly including NULL.

Here is the way I query the default trace:

SELECT

TE.[name],

I.*

FROM

sys.traces T CROSS Apply

sys.fn_trace_gettable(CASE WHEN...

I have dealt with a similar situation and here is the SSIS Expression that I use in a Derived Column transform:

DateCol == (DT_DATE)"12/30/1899" ? NULL(DT_DATE) : DateCol

If I understand your request correctly you can query the Default Trace (if you haven't disabled it) for the Audit Schema Object GDR Event to find when a user or...

Can you post the connection string you are using and the code that tries to connect?

To the best of my knowledge, you can only have one data source for a table.

Why can't you bring all the data in one dataset?

Mapped drives are not available to the SQL Server Services because the mapping does not take place until a user logs into Windows. Thus any job needing access to...