Integration Services issues

2 Oct 2007 3:35 PM

WFBJoeB

I am having very strange issues with SQL Server 2005 Integration Services.
Originally I was having trouble due to a SP issue. Product Level
Insufficient. I installed SP1 and then SP2 for SQL2005 and the issues stopped
but have now reappeared BUT intermittently! I can run a simple package and it
will execute fine; execute a SQL query, send it to a flat file. But when I
try to run it again I'll get a Product Level Insufficient for File........
Run it a third time, same thing, run it a fourth and it works! I also see the
same behavior for Merge and Merge Join. I've done a total remove (using
remove software) twice, reinstalled with SP1 and 2 and I still see this weird
behavior. Any ideas?????

Thanks,

Joe B

2 Oct 2007 3:41 PM

Kent Tegels

Hello WFBJoeB,

What happens if you try it on a totally clean (e.g., not a reinstall scenario?)

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

2 Oct 2007 3:53 PM

WFBJoeB

Kent,

I've done a total remove of everything SQL2005 specific, should I remove
anything else?

Thanks,

Joe B

Show quote

"Kent Tegels" wrote:

> Hello WFBJoeB,
>
> What happens if you try it on a totally clean (e.g., not a reinstall scenario?)
>
> Thanks!
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>
>
>

2 Oct 2007 3:59 PM

Kent Tegels

> I've done a total remove of everything SQL2005 specific, should I
> remove anything else?

It's hard to tell you that without knowing that its really going to achieve
anything. It would be good know if works on a clean machine first.

Thanks,
kt