Thanks. I would post the DDL but the DB is of a confidential nature so all that I can do is make something up.

Yes it is truncating. I changed the Data Type to the VARCHAR(8000) and it still truncated.

Thanks for the CSV solution but what is up with the leading commas and trailing comma?

Why is each column prefixed with an @?

Thanks foe the sugesstions.

When I execute the dynamic sql I get the following error:

(169 row(s) affected)

Msg 1038, Level 15, State 4, Line 1

An object or column name is missing or...

After moving the Task for the On Error Event to the Package Level it failed to execute.

If you select a task and then select the Event Handler Tab you click...

Thanks, I have the Error handling at the Task Level within the Container.

That enables me to capture the task that fails as the source name.

I added a task at the...

Thanks.

My question is how do you perform an uninstall to just remove BIDS?

What are the steps?

Jared,

Sorry I fogot to mention tjhat I already tried a repair and it did not resolve the issue.

Thanks.

I did not find sys.syscomments until today.

Why is sys.sql_modules the preferred table?

That's funny that you mention NOLOCK's. I had someone tell me that the WITH (NOLOCK) was their company...

I was wondering if you informed the client how much it was going to cost them to upgrade to the Enterprise Edition.

I just got approval to upgrade to Enterprise for...

So when I uninstall do I select SQL Server 2008 R2 64 bit and do I get the option of which component to uninstall or does it remove every component?

In addition to the problem that I stated I frequently I'm getting package that become corrupt.

I would like to start clean with a remove and install.

I could do it from...

@bill 😎

Excellent, thank you! 🙂

I tried BOL but I must not have entered the right search criteria.

Then I goggled it and got a article that provided the example that I listed in my original...