 | |
DTS Package Failure - Error string: Invalid pointer
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: DTS Package Failure - Error string: Invalid pointer -
04-07-2008
, 12:45 PM
|
Rubens, You can use GOOGLE to search a newsgroup or newsgroups, even though you do not have that data cached locally on your desktop. If you use the advanced search you can also focus your query even more. RLF "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:OMvijfMmIHA.2268 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Okay thank-you. Will try that and see what happens. Unfortunately I delete messages after a few days, so I wasn't able to find anything in this group. Thank-you, Rubens ssslither9 (AT) yahoo (DOT) com> wrote in message news:19efce3d-60d9-48e8-b5da-a1342a0f2c82 (AT) t36g2000prm (DOT) googlegroups.com... Do a search on "invalid pointer" in this group. What you will find is that you most likely are getting informational output from the SQL statement that is the source in your data pump. Try setting "set nocount on" in the SQL statement. cheers s On Apr 4, 12:09 pm, "Rubens" <rubensr... (AT) hotmail (DOT) com> wrote: I have a DTS package failing with the error log listed below. I've never seen this before so I am not sure where to start with this one. Any ideas? Thank-you, Rubens DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467261 (80004003) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. |
#32
| |||
| |||
|
|
Rubens, You can use GOOGLE to search a newsgroup or newsgroups, even though you do not have that data cached locally on your desktop. If you use the advanced search you can also focus your query even more. RLF "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:OMvijfMmIHA.2268 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Okay thank-you. Will try that and see what happens. Unfortunately I delete messages after a few days, so I wasn't able to find anything in this group. Thank-you, Rubens ssslither9 (AT) yahoo (DOT) com> wrote in message news:19efce3d-60d9-48e8-b5da-a1342a0f2c82 (AT) t36g2000prm (DOT) googlegroups.com... Do a search on "invalid pointer" in this group. What you will find is that you most likely are getting informational output from the SQL statement that is the source in your data pump. Try setting "set nocount on" in the SQL statement. cheers s On Apr 4, 12:09 pm, "Rubens" <rubensr... (AT) hotmail (DOT) com> wrote: I have a DTS package failing with the error log listed below. I've never seen this before so I am not sure where to start with this one. Any ideas? Thank-you, Rubens DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467261 (80004003) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. |
#33
| |||
| |||
|
|
Rubens, You can use GOOGLE to search a newsgroup or newsgroups, even though you do not have that data cached locally on your desktop. If you use the advanced search you can also focus your query even more. RLF "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:OMvijfMmIHA.2268 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Okay thank-you. Will try that and see what happens. Unfortunately I delete messages after a few days, so I wasn't able to find anything in this group. Thank-you, Rubens ssslither9 (AT) yahoo (DOT) com> wrote in message news:19efce3d-60d9-48e8-b5da-a1342a0f2c82 (AT) t36g2000prm (DOT) googlegroups.com... Do a search on "invalid pointer" in this group. What you will find is that you most likely are getting informational output from the SQL statement that is the source in your data pump. Try setting "set nocount on" in the SQL statement. cheers s On Apr 4, 12:09 pm, "Rubens" <rubensr... (AT) hotmail (DOT) com> wrote: I have a DTS package failing with the error log listed below. I've never seen this before so I am not sure where to start with this one. Any ideas? Thank-you, Rubens DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467261 (80004003) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147467261 (80004003); Provider Error: 0 (0) Error string: Invalid pointer Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.