Could not load file or assembly SQLXMLBULKLOADLib

Greetings,

I'm in the process of migrating several SQL Server 2000 DTS packages to Integration Services packages. One of the old 2000 DTS packages used the SQLXML Bulk Loader component. In order to use the new SQLXML 4 COM object in my Script Task (to initiate the Bulk Loader using .NET code) I've used the tlbimp.exe tool to create a .NET wrapper DLL. I've placed the DLL in the appropriate directory (C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies), successfully added it to my project (with Intellisense working), but when I run the package it fails with the following error:

Could not load file or assembly 'SQLXMLBULKLOADLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

Note: I also tried placing the DLL in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 with no prevail.

I've confirm the file exists (and any dependencies) in their appropriate locations. Has anyone else run into this? Any help is much appreciated.

Thanks, Shaun

i'm not sure if this resolves your issue, but have you considered using the ole db destination component to bulk load the data?|||Reason I leaned toward the SQLXML Bulk Loader class is because i have a ton of XML I'm downloading and want to leverage the performance of the XML bulk loader. I'm not aware of how the OLE DB Destination object can help me with this.|||

I've resolved this issue by using... well... what I'm supposed to use. I created a Data Flow task and implemented an XML Source (applying an XSD transformation), Data Conversion (to convert from Unicode) and Ole Db Destination. This successfully loads the data into the database from XML.

|||shaun,

i'm glad that you found a solution to your problem. as you probably already know, the ole db destination is designed to bulk load data.|||

Did you add it to the GAC? You need to add it to the framework folder for design-time only (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727) but at runtime it uses the GAC.

I think the better solution is to re-write to use the XML Source as this is very powerful and handles hierarchical data, but obviously this may not be ideal if you have a lot of packages and XMl formats.

Could not find server '<server ip address here>' in sysservers.

Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000 on a WIN 2003 box. Both are different domains. I have set up several databases to test and most work fine except for some .NET applications where I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master db > sysserver table the server name is VIVID01 and there is no mention of IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.
Can you show us which exact statement is failing? Are you trying to use the
4-part naming convention to connect from one server to another. In that
case, you will have to configure that other server as a linked server.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:5B8A7E57-322A-4674-A95B-1DDC9281DD6A@.microsoft.com...
Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000
on a WIN 2003 box. Both are different domains. I have set up several
databases to test and most work fine except for some .NET applications where
I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master
db > sysserver table the server name is VIVID01 and there is no mention of
IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.

Could not find server '<server ip address here>' in sysservers.

Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000 on a WIN 2003 box. Both are different domains. I have set up several databases to test and most work fine except for some .NET applications where I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master db > sysserver table the server name is VIVID01 and there is no mention of IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.Can you show us which exact statement is failing? Are you trying to use the
4-part naming convention to connect from one server to another. In that
case, you will have to configure that other server as a linked server.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:5B8A7E57-322A-4674-A95B-1DDC9281DD6A@.microsoft.com...
Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000
on a WIN 2003 box. Both are different domains. I have set up several
databases to test and most work fine except for some .NET applications where
I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master
db > sysserver table the server name is VIVID01 and there is no mention of
IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.|||The statement is:
SELECT * FROM OPENQUERY([<ipaddresshere>],'CCI.dbo.p_GetCMSGroupsByContentID "6918"') WHERE ID = 6
We have used the IP address instead of the server name.
This only fails when using the OPENQUERY statement. If I add a server using sp_addlinkedserver with the IP address specified it works.
"Narayana Vyas Kondreddi" wrote:
> Can you show us which exact statement is failing? Are you trying to use the
> 4-part naming convention to connect from one server to another. In that
> case, you will have to configure that other server as a linked server.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Matt" <Matt@.discussions.microsoft.com> wrote in message
> news:5B8A7E57-322A-4674-A95B-1DDC9281DD6A@.microsoft.com...
> Hi There,
> I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000
> on a WIN 2003 box. Both are different domains. I have set up several
> databases to test and most work fine except for some .NET applications where
> I get this error spasmodically:
> Could not find server '<server ip address here>' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> Im using the IP address of the server in the db connection string. In Master
> db > sysserver table the server name is VIVID01 and there is no mention of
> IP address.
> Is there a reason why this error occurs only for some of the databases?
> thanks - matt.
>
>

Could not find server '<server ip address here>' in sysservers.

Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000 o
n a WIN 2003 box. Both are different domains. I have set up several database
s to test and most work fine except for some .NET applications where I get t
his error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute sp_a
ddlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master
db > sysserver table the server name is VIVID01 and there is no mention of
IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.Can you show us which exact statement is failing? Are you trying to use the
4-part naming convention to connect from one server to another. In that
case, you will have to configure that other server as a linked server.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:5B8A7E57-322A-4674-A95B-1DDC9281DD6A@.microsoft.com...
Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000
on a WIN 2003 box. Both are different domains. I have set up several
databases to test and most work fine except for some .NET applications where
I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master
db > sysserver table the server name is VIVID01 and there is no mention of
IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.