Table not being updated

[SQLHelp05]

Hello All!

I am new to SQL Server 2000 so hopefully someone can help.

We have a package that is run regularly and it is working, I have tested by changing values in my table and when I run the package it updates it in SQL Server. My issue is the following:

I added a new field (date field) to one of the source tables in our application (MAS) and I have entered some values to see if they are updated in SQL Server. But they do not update that field, other data that I change appears in SQL Server but not that field which I just created in our source program.

To make sure I created correctly, I tested it out in Crystal Reports, and when I connect to that table it shows the new field.

Do I need to do something in SQL Server to read that newly created field in the source program table? Please help! Thank you.

 

[SQLDenis]

Is the new field added to the DTS package also??









“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[SQLHelp05]

Well the package is getting the information from the table in SQL. But the problem is that the table in SQL is not including that newly created field, yet when I change a value in the other existant fields it is updated in the SQL table.

The package that updates the table from our application simply

Deletes: delete from [MASImports].[dbo].[IM_91_UDF_IM_Warehouse_Detail]

Where IM_91_UDF_IM_Warehouse_Detail is the application table as well as the name of the table in SQL where it copies the information.

It also has 2 connections.

 

[SQLHelp05]

I tried something on a test database. Do I have to create another DTS package to import the new table since I added a new field. And once I run that package that will import the new table with the new field then I can change the "Execute SQL Task" to do the

delete from [MASImports].[dbo].[IM_91_UDF_IM_Warehouse_Detail]

to simple update the table in SQL?