If you're looking at implementing index maintenance have a look at this set of scripts:

Ola Hallengren > SQL Server Index and Statistics Maintenance

It is done in T-SQL so you can...

Evil Kraig F (1/3/2013)

---

opc.three (1/3/2013)

---

Be careful implementing code like this. You are not checking for exclusive access to the file before allowing the SSIS package to proceed in processing it....

I am curious about the width of the tables (which you sort of answered), the fill factor of the clustered indexes, the other indexes (definitions and fill factors and such)...

Bhuvnesh (1/4/2013)

---

opc, can you...

msandbergen (1/4/2013)

---

Very helpfull article, I've used it to build an ETL import for multiple files, and I've encountered a strange behavior.

I've set up an excel template (.xltx) in the "Drop"...

Sorry if I am missing it, but are you running this SELECT against a SQL Server OLE DB connection or trying to run it against an Excel OLE DB connection?

The only way to format an Excel Workbook programmatically using SSIS is to leverage the Excel Object Model from a Script Task.

One technique I have used in the past however...

JKSQL (1/3/2013)

---

opc. - So there is no way to really understand why it is reorganizing my tables from the original. Is it a black box? The join with...

I am assuming you are talking about using the Query Designer in SSMS to develop a View which accessed by right-clicking the Views node under a particular database and choosing...

Can you please post a sample line of data that DTS outputs as you like, and a sample of what SSIS outputs?

The article focuses on SSIS 2012 and walks you through the entire process of creating the package step-by-step so it...

Evil Kraig F (1/2/2013)

---

that's... wow. Intricate and overkill.

In VB:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

Public Sub Main()

...

sys.dm_exec_sessions is a DMV (Dynamic Management View) so the results will change from one selection to the next based on what sessions are active within the server when you run...

The PowerShell step type runs commands in a mini-shell called sqlps.exe which is not the same as what you get when you open a PowerShell prompt using powershell.exe so results...

james marriot (1/2/2013)

---

Do i need to explicitly say SET TRANSACTION ISOLATION LEVEL SNAPSHOT; in each batch that i want to operate under Snapshot isolation?

I altered database

Set Allow_Snapshot_Isolation ON, but even...