Tuesday, April 15, 2014

I got this error in a VB Script Component task in an SSIS package: microsoft.sqlserver.dts.pipeline.cannotcreateusercomponentexception

I created the task as a copy of another task, which is working OK.

I was able to resolve the issue by deleting everything from the new task and copying everything from the existing task, into the new task.

Monday, April 7, 2014

SQL Server View does not return a newly added column

I added a column to a table in a SQL Server DB. A View which does 'Select *' from the table, did NOT return the new column.

Before the change, the definition of the table was -

Column_A Column_B Column_C

I added a new column so the table now has 4 columns -

Column_A Column_B Column_C Column_D

The definition of the view is:
Select * From Table

To get the view to return the new column (Column_D), I had to drop and re-create the view.