Hi,
I'm actually using SQL Server 2008, but I did not see a Business Intelligence section for 2008, only 2005, and I imagine the behavior is mostly the same.
I've been trying to reference an external DLL from my SSIS script. I have finally managed to do that by installing the DLL using gacutil.exe.
Now my problem is that the DLL references an XML file. When I execute the DTSX package, it cannot find the XML file. It is looking in C:\WINDOWS\assembly\GAC_MSIL\..., but that directory does not even exist.
What do I need to do to get it to find my XML file?
Thanks.