Table changes not showing up in the DTS transformation task

#1

I have a DTS package that performs data transformation from a flat file to a
database table. I've added two columns to the table but, the two table do
not show up when I look at the transformation tasks in mu DTS package.

Shouldn't the new columns show in the transformation step automatically?

What should be done to refresh the task with the new table changes?

Thanks

#2

I solve my own problem I was point to the wrong server.

thanks

"Larry Bird" wrote:

Quote:

I have a DTS package that performs data transformation from a flat file to a
database table. I've added two columns to the table but, the two table do
not show up when I look at the transformation tasks in mu DTS package.

Shouldn't the new columns show in the transformation step automatically?

What should be done to refresh the task with the new table changes?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table changes not showing up in the DTS transformation task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Table changes not showing up in the DTS transformation task - 12-22-2005 , 11:02 AM

RE: Table changes not showing up in the DTS transformation task - 12-22-2005 , 11:45 AM