DTS Invalid pointer

This continues from the tread DTS using #temp tables. I have a temp table
that gets populated through a really complex SP (with
selects/update/inserts). When all the processing is completed, the very last
SELECT * from @.table is executed to get the results. I need these results
pumped to an external text file on a nightly basis.
I started with #temp tables and couldn't get the DTS to see the table. So I
converted the table to @.table datatype and now the DTS can see the
definitions.
When I execute the DTS step to pump the data to the text file I get the
error message: 'Invalid Pointer'. The DTS can see all the transforms and
objects in the SP, but I cannot figure this error. For whatever reason, if I
"Preview" the data in the DTS it will say no row set was returned. But
running it in Query Analyzer produces results.
I've been struggling with this for two days. Any further assistance is
appreciated.
--
JP
.NET Software Developertry SET NOCOUNT ON at the start of the procedure.
I'm not sure your situation but sounds what i experience before
Hope that help.
"JP" <JP@.discussions.microsoft.com> wrote in message
news:3D2B9092-7DC8-4FCB-810C-923E4EA7EF09@.microsoft.com...
> This continues from the tread DTS using #temp tables. I have a temp table
> that gets populated through a really complex SP (with
> selects/update/inserts). When all the processing is completed, the very
last
> SELECT * from @.table is executed to get the results. I need these results
> pumped to an external text file on a nightly basis.
> I started with #temp tables and couldn't get the DTS to see the table. So
I
> converted the table to @.table datatype and now the DTS can see the
> definitions.
> When I execute the DTS step to pump the data to the text file I get the
> error message: 'Invalid Pointer'. The DTS can see all the transforms and
> objects in the SP, but I cannot figure this error. For whatever reason, if
I
> "Preview" the data in the DTS it will say no row set was returned. But
> running it in Query Analyzer produces results.
> I've been struggling with this for two days. Any further assistance is
> appreciated.
> --
> JP
> .NET Software Developer|||
"JP" wrote:

> This continues from the tread DTS using #temp tables. I have a temp table
> that gets populated through a really complex SP (with
> selects/update/inserts). When all the processing is completed, the very la
st
> SELECT * from @.table is executed to get the results. I need these results
> pumped to an external text file on a nightly basis.
> I started with #temp tables and couldn't get the DTS to see the table. So
I
> converted the table to @.table datatype and now the DTS can see the
> definitions.
> When I execute the DTS step to pump the data to the text file I get the
> error message: 'Invalid Pointer'. The DTS can see all the transforms and
> objects in the SP, but I cannot figure this error. For whatever reason, if
I
> "Preview" the data in the DTS it will say no row set was returned. But
> running it in Query Analyzer produces results.
> I've been struggling with this for two days. Any further assistance is
> appreciated.
> --
> JP
> .NET Software Developer|||Andy Warren posted this reply which may help.
By: Andy Warren
Email : awarren@.cfl.rr.com
Last Modified: 11/16/2001
The problem is that the query must be a single line of T-SQL code. Most
likely you have a "use " line before the query which will cause this error.
(Back to SQL Server 7.0/2000:DTS FAQs)
"Atenza" wrote:

> try SET NOCOUNT ON at the start of the procedure.
> I'm not sure your situation but sounds what i experience before
> Hope that help.
> "JP" <JP@.discussions.microsoft.com> wrote in message
> news:3D2B9092-7DC8-4FCB-810C-923E4EA7EF09@.microsoft.com...
> last
> I
> I
>
>

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!

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.
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][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
>
>

DTS Import Text File Replacement - too many errors with DTS

I am using the DTS COM object to import a bunch of different text files.
some are 2 or 3 million rows. if there's an invalid row (can't find
row delimiter or column delimiter) sometimes DTS will crash and stop the
import... it even does it if I try to import it from the GUI, and going
into DTS tasks and messing with the errors rows, etc.
So, I am looking for a better way to batch import... can't use bulk
insert because of field qualifiers... any ideas? any 3rd party object i
can use to quickly import a large file?
i using c#, btw.
thanks
EdDid you look at the bcp utility? It ain't pretty, but for brute force,
it is hard to beat.|||Bulk insert and bcp both can use format file (i.e. you can specify your
custom terminator), batch size, and allowable max error. You should check
them out.
-oj
"Ed West" <west@.westville.com> wrote in message
news:OQxMbDxCFHA.3492@.TK2MSFTNGP12.phx.gbl...
>I am using the DTS COM object to import a bunch of different text files.
>some are 2 or 3 million rows. if there's an invalid row (can't find row
>delimiter or column delimiter) sometimes DTS will crash and stop the
>import... it even does it if I try to import it from the GUI, and going
>into DTS tasks and messing with the errors rows, etc.
> So, I am looking for a better way to batch import... can't use bulk insert
> because of field qualifiers... any ideas? any 3rd party object i can use
> to quickly import a large file?
> i using c#, btw.
> thanks
> Ed|||hi - many thanks, bcp/bulk insert is working great... i am creating a
format file dynamically.
thanks again
oj wrote:
> Bulk insert and bcp both can use format file (i.e. you can specify your
> custom terminator), batch size, and allowable max error. You should check
> them out.
>|||Hello - what about a Field Qualifier? how can I specify that? For some
files, the field qualifier is " and that is showing up in the database
field after being imported... thanks
- Ed
oj wrote:
> Bulk insert and bcp both can use format file (i.e. you can specify your
> custom terminator), batch size, and allowable max error. You should check
> them out.
>