May 20, 2002 at 8:47 am
I am executing a simple DTS package, (simple query), and getting an "invalid pointer" err message. (Although the query has been successfully done!!!)
Does anyone know why? and what is this pointer?
I didn’t put any "use" lines.
May 20, 2002 at 9:54 am
Rebuild the pacakge. I suspect something is corrupt. If you still get this, try it on another client station.
Steve Jones
May 20, 2002 at 9:57 am
i did...doesnt help.
🙁
But thank you.
May 20, 2002 at 11:01 am
Do you have any package variables defined, or what does the package do specifically?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 20, 2002 at 11:35 am
Emailed to me.
No I do not have package var'
The package uses a simple query that takes data from 2 tables on 1 DB and put it in a table on a different DB.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 20, 2002 at 11:40 am
What version of SQL and what Service Pack are you running. If 7 SP1 or earlier then try a more current SP. Also issue can be related to the install of DTS components themselves which SP install may fix. Not much on this issue.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 21, 2002 at 3:16 pm
Problem has been solved.
Shouldn’t have used "insert into” in the Transform Data Object, and also give a specific name to each column.
(Solved by my CTO)
thanks.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply