One way to do that is create an additional RDL file for the disclaimer and insert that as a subreport after your 1st and 3rd page, using appropriate pagebreaks; might...

Or you could use online converters like these to generate the HTML.

http://www.string-functions.com/htmlencode.aspx

http://www.simple-talk.com/prettifier/default.php

Since xp_cmdshell appears to hang you should be able to see the username in Task Manager under the Process tab; look for cmd.exe or coreftp.exe.

Once you have the username you...

How about changing this line?

Row.outdenoteline. = byteBlob

to

Row.outdenoteline.AddBlobData(byteBlob)

I ran your code against a small table with a few 1MB IMAGE columns and they all made it to the Flat File destination...

How about using an OUTPUT parameter in your stored procedure to return the column count?

For example:

CREATE PROCEDURE usp_myProc (@p1 INT, @p2 INT OUTPUT)

AS

IF @p1 = 1

BEGIN

...

Since perfmon counters tend to give an overall view of the server you might want to look into using SQL Profiler instead to narrow down the search to a specific...

Validating in the client application is one option. For example if this is an ASP.NET application then using the RegularExpressionValidator would allow the input to be checked and provide a...

If the backup database is synchronized using SQL Data Compare then transactions are definitely occurring. That tool generates the DML statements needed to do the synchronization.

From the DBCC...

Marios,

Glad it helped.

myServer is the name of any domain controller for myDomain.com. Ideally you'll want to pick one closest.

Running 'dsquery server' from a command line should get you a...

If the default trace is enabled you should be able to get that information.

For example:

-- Check if default trace is enabled; id=1.

SELECT * FROM sys.traces

-- Change to suspect database so...

With two tables a Data Flow like this should work.

[Table1] --

|--> [Union All] --> [Fuzzy Grouping] --> [Output Table]

[Table2]...

For a onetime cleanup operation the Fuzzy Lookup or Grouping transformations in SSIS would help out; Developer and Enterprise Edition only. The attached screen-shots show how both the Lookup...

As well as the articles on this site take a look at Brian Knight's blog and videos on JumpstartTV.

http://pragmaticworks.com/community/blogs/brianknight/default.aspx

http://www.jumpstarttv.com : Look under Channels/Technology/Database/SQL Server/SQL Server 2005/SQL Server Integration Services.

Those three tasks can be done within a Script Task. Just add that task to the Control Flow canvas and use methods available in the My.Computer.FileSystem namespace. You'll...

The following example tries to answer the following 3 questions.

1) Is the server on the network?

2) Is the connection string in a valid format?

3) Can a connection be made to...