September 10, 2002 at 1:48 pm
I keep getting the error, "invalid pointer" when my dts runs. My datatransformation task is merely an exec sp_*********. My source and destination link up fine. In fact, when I execute the sp from query analyzer and opt to output to a file, that even works. It is only when I try to run this from a DTS that I get an error. I wrote this on a development machine and it worked great, even inside the dts. Is there some sql setting that could cause this because the code and dts are identical from development to production.
September 10, 2002 at 2:18 pm
I would recommend looking at user permissions that DTS is running under on your production environment versus those of your development environment. Also, are both instances of SQL Server the same? ie service pack versions, etc?
hth,
Michael
Michael Weiss
Michael Weiss
September 10, 2002 at 2:40 pm
I've double checked the permissions and also verified that both are running sql 2k enterprise sp 2.
September 10, 2002 at 2:54 pm
It's crazy. I check the output file and it is a 0 kb size but has a new time stamp everytime I run my dts. At first I thought my problem was because I was specifying the file path with unc, but I switched it and it didn't make a difference. This is quite frustrating.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply