DTS Package - Append Results to Text File

I have created a DTS package which transfers data from a SQL 2000
server table to a text file. Each time the package is executed the
data in the text file is replace with the new data from the current
execution of the package. Can DTS append new text to a text file and
not replace it each time the package executes. Is there an option or
seeting for this? I havent seen one. Can anyone help me out on this.
Thank you,

Brett"bdwgarth" <bwalke@.lbrspec.com> wrote in message
news:1105716432.160263.235590@.c13g2000cwb.googlegr oups.com...
>I have created a DTS package which transfers data from a SQL 2000
> server table to a text file. Each time the package is executed the
> data in the text file is replace with the new data from the current
> execution of the package. Can DTS append new text to a text file and
> not replace it each time the package executes. Is there an option or
> seeting for this? I havent seen one. Can anyone help me out on this.
> Thank you,
> Brett

http://mssql.meetholland.com/message/162162.aspx

Simon|||I doubt it will let you handle merging file text thru DTS. Anyone
correct me if I am wrong..!

DTS invalid object name error

When I try to import or export between my laptop and our SQL Server 2000
server I get 2 errors stating [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'dbo.vw_LaborTotalsAll'
I looked it up in TechNet and said it had something to do with the order of
dependent objects (e.g. tables) and that it could be resolved with SP3. I
have SP3 on both the laptop and server. The only difference is that the
laptop is the Developers Edition and the Server is Standard Edition.
Any ideas how to resolve/fix this error? Thanks.
David
Assuming vw_LaborTotalsAll is a view. Who's the owner of it on both the
laptop and the server?
"David C" wrote:

> When I try to import or export between my laptop and our SQL Server 2000
> server I get 2 errors stating [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid object name 'dbo.vw_LaborTotalsAll'
> I looked it up in TechNet and said it had something to do with the order of
> dependent objects (e.g. tables) and that it could be resolved with SP3. I
> have SP3 on both the laptop and server. The only difference is that the
> laptop is the Developers Edition and the Server is Standard Edition.
> Any ideas how to resolve/fix this error? Thanks.
> David
>
>
|||All objects have the same owner. Out of 100 views, only 2 are giving
this error.
David
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

DTS invalid object name error

When I try to import or export between my laptop and our SQL Server 2000
server I get 2 errors stating [Microsoft][ODBC SQL Server Driver]
1;SQL
Server]Invalid object name 'dbo.vw_LaborTotalsAll'
I looked it up in technet and said it had something to do with the order of
dependent objects (e.g. tables) and that it could be resolved with SP3. I
have SP3 on both the laptop and server. The only difference is that the
laptop is the Developers Edition and the Server is Standard Edition.
Any ideas how to resolve/fix this error? Thanks.
DavidAssuming vw_LaborTotalsAll is a view. Who's the owner of it on both the
laptop and the server?
"David C" wrote:

> When I try to import or export between my laptop and our SQL Server 2000
> server I get 2 errors stating [Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]Invalid object name 'dbo.vw_LaborTotalsAll'
> I looked it up in technet and said it had something to do with the order o
f
> dependent objects (e.g. tables) and that it could be resolved with SP3. I
> have SP3 on both the laptop and server. The only difference is that the
> laptop is the Developers Edition and the Server is Standard Edition.
> Any ideas how to resolve/fix this error? Thanks.
> David
>
>|||All objects have the same owner. Out of 100 views, only 2 are giving
this error.
David
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!