I am running the following script to get the indexes that have fragmentation over 30%. The result set is returning some indexes that I don't see in Object exlorer for...

At the present the fill factor on all indexes are 0

After thinking on it I'm beginning to think that if I have Hallengren's index maintenance procedure running in a job then I can probably leave the Fill Factor at...

Yes,it is Enterprise edition and plan on running somethink like the following:

ALTER INDEX PK_QNXTClaimSubmitKeys ON dbo.QNXTClaimSubmitKeys REBUILD WITH (FILLFACTOR = 80)

The db will be online but during a time of...

Try looking here

http://www.sqlskills.com/blogs/kimberly/use-this-new-sql-server-2012-rewrite-for-sp_helpindex/

Yep, that was it. Bit of a brain cramp for a little while

was a permissions issue, thanks

I am able to run it locally on my laptop but not when I deploy to server. Server login doesn't have access?

I can connect and execute the oledbsrc tsql query. Is it possible the datatypes aren't the same?

Apparently there was a setting that when I used varchar it would be returned in Chinese. When I queries the same table in SSMS, I saw it in English. Oh...

A little more info:

I've noticed that when I change the datatype of the [Configured Value] column to nvarchar I have no issue but when I change it to varchar I...

Actually I just noticed I would need to provide fuzzy lookup as well

Additional info. Its a pkg developed in VS 2008 and Im connecting to a SQL 2012 datasource

Oops, that did the trick. Also updated the code to concat the error as such

Dts.Variables["CareAlertLoadError"].Value = String.Concat(Dts.Variables["CareAlertLoadError"].Value, Dts.Variables["ErrorDescription"].Value);

Thanks Alvin

/*

Microsoft SQL Server Integration Services Script Task

Write scripts using Microsoft Visual C# 2008.

The ScriptMain is the entry point class of the...