I prefer to keep all non-clustered indexes in their own file group on a separate I/O path (LUN) altogether. By splitting the I/O you should see a measurable increase in...

Can you render the Crystal report in XML? If so you can use the XML as a data source. Regarding the AS/400 connectivity, you can use the Microsoft OLEDB Provider...

Refer to -

http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx

If your using an execute SQL task you would have to enable the database mail XP(s) via the surface area configuration tool.

What type of error are you getting from the...

Use something similar to the expression below to build your derived column -

(DT_STR,2,1252)MONTH(GETDATE()) + "/" + (DT_STR,2,1252)DAY(GETDATE()) + "/" + (DT_STR,4,1252)YEAR(GETDATE())

I believe 14 is what your looking for -

select replace(convert(varchar, getdate(),112),'/','') + replace(convert(varchar, getdate(),14),':','')

14 is what your looking for -

select replace(convert(varchar, getdate(),112),'/','') + replace(convert(varchar, getdate(),14),':','')

I am unaware of any method in T-SQL to retrieve binary data (BLOB). To the best of my knowledge this can only be achieved with ADO, VB.NET, etc.

NP, I've used the transform against other RDBMS (i.e. Sybase, Oracle, etc.).

Check out -

http://www.dbazine.com/sql/sql-articles/charran5

Shouldn't be a problem - yes.

Take a look at Christian's blog on this -

http://sqlblogcasts.com/blogs/christian/archive/2008/01/07/sql-server-memtoleave-vas-and-64-bit.aspx

You could use a script task in an onError event handler. In this example, using string variables representing ErrNumber, ErrSource, and ErrDescription.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

...

Build 09.00.3215 is the most recent cumulative update.

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

Nice script. Added support for schema's in case anyone is interested 😀

DECLARE @TABLE_NAME sysname, @TABLE_SCHEMA sysname

SELECT @TABLE_SCHEMA='UTILITY'

SELECT @TABLE_NAME='SYMMETRICS_JOB_CTRL'

SET NOCOUNT ON

DECLARE @CMD nvarchar(max)

DECLARE @INSCMD nvarchar(max)

DECLARE @INSVAL varchar(max)

DECLARE @FLD varchar(max)

DECLARE @TYPE...