The article http://msdn.microsoft.com/en-us/library/aa337083.aspx?PHPSESSID=7c61ntavm1dmu84rl10kephll5 explains how a user can excute an SSIS package interactively (not by scheduled Agent job)

I will give you an outline of how to achieve this

DECLARE @InsertedRecords INT

CREATE TABLE #GetFileList

(

SrNo Int IDENTITY (1,1),

FileListOutPut Varchar(1000)

)

INSERT INTO #GetFileList (FileListOutPut)

EXEC master.dbo.xp_cmdshell 'DIR \\ \*.bak /OD /-C /B'

-- /OD...

I believe it will make a difference. Let me explain.

Apart from the page split, which would happen irrespective of the number of records in a table, what you need to...

Please can you try out the following:

RUN AT THE COMMAND PROMPT ON SERVER: REGSVR32.EXE dts.dll

You can fing the dll file at the location :\Program Files\Microsoft SQL Server\90\DTS\binn

It is possible to change the location of the resource database using the command ALTER DATABASE MODIFY FILE. After executing this command, you need to shutdown the SQL...

SQL Mail - Requires MAPI client like outlook installed on the sql box.

Database Mail - Does not require MAPI client like outlook installed on the sql box.

On SQL 2005, you...