Perhaps the is something wrong with the variable. Under the Dim filePath As String = Dts.Variables.Item("FileName").Value.ToString line add msgbox(filePath). Then run the package and see if the process is moving...

Even though this is SQL 2005 we still like to assist. Try this procedure I wrote using the undocumented sp_MSforeachdb procedure. You'll need the table DatabaseGrowthStats for testing. Here is...

San - I was able to accomplish this task in SSIS. Here are the steps I took:

1.) Add a Foreach Loop container

2.) Set properteries to For Each File Enumerator. Set...

Double check the account used for SQL Agent has rights to execute the procedure. When you run the procedure from SSMS either your AD account or the SQL account is...

Thanks for your input Paul. I'll take your suggestion and do some testing in our DEV environement.

Follow Up: Thanks again everyone who replied. Here are my findings after testing both solutions:

Sol1: Alter the column with an Alter Table statement

Took 13 minutes to alter...

Rggg...typing. Command not comment.

Paul - Yes to your question. The field in question is populated but is a NULLABLE field and it does sit in the middle of the row.

FYI - I ran...

Thank you all for the replies. These is data in the column however some values are NULL.

First - Thank you to all that spent time working on a solution.

Lamprey13's solution is hitting on the correct records. If you look at the tmpOrders data sorted by recordid...

To eliminate dynamic sql you could use an if statement like the following (used a simple date select to get the point across):

DECLARE @nParent NVARCHAR(3)

SET @nParent = 'ALL'

IF ISNUMERIC(@nParent) =...

Being a little OCD with my queries, I prefer upper case keywords. I agree holding the shift key can be a pain and slow things down. There is a great...

Also, if the issue is intermittent you could setup a small table to log any errors. In the catch block set an insert into the logging table for ERROR_NUMBER() and...

I appreciate your feedback. I am putting some documentation together on best practices and hope to get the winning vote from upper management.

Exactly my thoughts. I am trying to fight the battle with SAS70 compliance but can't find much ground to stand on. I am basing my argument primarily on best practices.