I was trying to build a tool to move some data between a TSM Database and a SQL 2005 Database. Mostly so that I can create a few reports to impress people who don’t have any idea what it is that I am reporting on.
There are a number of issues with trying to do this, not the least of which is the fact that I have no idea what I am really doing. The fact that I am working with a mixture of x32 and x64 operating systems and applications isn’t helping. The fact that Microsoft doesn’t really like to work with ODBC drivers and Tivoli doesn’t provide x64 ODBC Drivers makes it more complicated.
I did some searching and I am not the only one who has tried to use ODBC to move data around. There is a nice blog post here:
http://blogs.simplifi.com/brucet/archive/2006/01/27/668.aspx
But when I tried that I kept getting this error:
Package Validation Error
Error at ImportTastk: The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
(Microsoft.DataTransformationServices.VsIntegration)
I did a google on that and came up with a hotfix that is supposed to fix the issue:
I will be applying that and see what I get…