DTS Problem

Hi,
Can any one tell me how can i use and from where i can study about
execute sql task in dts.
I have a problem that i have serverA and a OLAP Server same as my
server A.
I had scheduled a job to transfer data on nighlty basis.Some time my
team memeber(Programmer) adds a field in a table on server A . When my
job executes on olap server it gives error and fails.
The error occurs because of column not found in Table of OLAP Server.
To remove the error i have to manually increase the field in that
table.
Later on i use drop table and select * into table name from
database.username.tablename
But i think this is not a best way to do.
Can any one suggest me what should i do in this case.
from
killerHi
There is good documentation on DTS in Books online, which should be in your
SQL Server programs group on the start menu. You may want to check you have
the latest version or download it from
http://www.microsoft.com/sql/techin...2000/books.mspx
There is also a very good site at www.sqldts.com which has many examples and
articles.
It is not a good idea to use SELECT * in production code as you it can break
(as yours does) if some changes the columns.
John
"doller" wrote:

> Hi,
> Can any one tell me how can i use and from where i can study about
> execute sql task in dts.
> I have a problem that i have serverA and a OLAP Server same as my
> server A.
> I had scheduled a job to transfer data on nighlty basis.Some time my
> team memeber(Programmer) adds a field in a table on server A . When my
> job executes on olap server it gives error and fails.
> The error occurs because of column not found in Table of OLAP Server.
> To remove the error i have to manually increase the field in that
> table.
> Later on i use drop table and select * into table name from
> database.username.tablename
> But i think this is not a best way to do.
> Can any one suggest me what should i do in this case.
> from
> killer
>|||So, What should be done so that i can come to know that i have to
increase the field or how can i automaticaly schedule it.
from
killer
John Bell wrote:[vbcol=seagreen]
> Hi
> There is good documentation on DTS in Books online, which should be in you
r
> SQL Server programs group on the start menu. You may want to check you hav
e
> the latest version or download it from
> http://www.microsoft.com/sql/techin...2000/books.mspx
> There is also a very good site at www.sqldts.com which has many examples a
nd
> articles.
> It is not a good idea to use SELECT * in production code as you it can bre
ak
> (as yours does) if some changes the columns.
> John
> "doller" wrote:
>|||Hi
This is a code management issue. Making the columns will mean it won't
break, but if you are adding the extra column you should know from the chang
e
analysis that you are going to need to change the job to populate the table,
adding the extra column when it was not needed would not help performance.
John
"doller" wrote:

> So, What should be done so that i can come to know that i have to
> increase the field or how can i automaticaly schedule it.
> from
> killer
>
> John Bell wrote:
>