Showing posts with label means. Show all posts
Showing posts with label means. Show all posts

Tuesday, March 27, 2012

error: CoCreate of DSO for BULKIMPORTSTREAM

Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:

> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>

error: CoCreate of DSO for BULKIMPORTSTREAM

Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:

> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There reall
y
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when usin
g
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but n
ow
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>

error: CoCreate of DSO for BULKIMPORTSTREAM

Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:

> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There reall
y
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when usin
g
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but n
ow
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>sql

error: CoCreate of DSO for BULKIMPORTSTREAM

Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:

> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>

error: CoCreate of DSO for BULKIMPORTSTREAM

Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:

> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>

error: CoCreate of DSO for BULKIMPORTSTREAM

Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>

Sunday, March 11, 2012

Error: 0xC001000E - connection not found

Hello,

Does anyone know what this error means and how to resolve it? I get this error when I attempt to run a Data Flow Task. The Data Flow Task has one subcomponent, a Flat File Source. I have set up the connection manager to access the flat file, which is on a local directory. I have tried everything to fix this. What could possibly be the problem?

Thanks

Error: 0xC001000E at : The connection "{B9E11DD7-21A1-4FD7-986F-6BDC5B81F51D}" is not found. This error is thrown by Connections collection when the specific connection element is not found.

K108 wrote:

Hello,

Does anyone know what this error means and how to resolve it? I get this error when I attempt to run a Data Flow Task. The Data Flow Task has one subcomponent, a Flat File Source. I have set up the connection manager to access the flat file, which is on a local directory. I have tried everything to fix this. What could possibly be the problem?

Thanks

Error: 0xC001000E at : The connection "{B9E11DD7-21A1-4FD7-986F-6BDC5B81F51D}" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Go in and edit the flat file source - make sure it is pointing at the correct connection manager.

Out of interest, what is the point of a data-flow with only one component in it?

-Jamie

|||

I am just trying to test for now, that is why there is only one component. Why add more components when I can't even get the one to work correctly.

Anyways I resolved the problem... this error was occuring on a DTS migrated pkg. Apparently there are some ghost connections that are persisting, so by starting the pkg from scratch the problem has disappeared. This is my theory anyways.

|||

K108 wrote:

I am just trying to test for now, that is why there is only one component. Why add more components when I can't even get the one to work correctly.

Ah gotcha. That makes sense.

K108 wrote:

Anyways I resolved the problem... this error was occuring on a DTS migrated pkg. Apparently there are some ghost connections that are persisting, so by starting the pkg from scratch the problem has disappeared. This is my theory anyways.

This error most commonly occurs when you copy tasks/components from one package to another. I know that's not exactly what you've done but its not a huge jump from it. I guess that must be something to do with it.

Glad its fixed anyway.

-Jamie

|||

Yes, the problem (after much testing on my part) ALWAYS crops up when I am trying to run components from a migrated DTS package.

In this case, I have an EXECUTE SQL task, for which I've defined a NEW connection and deleted the old connection completely, and it still throws this error about the connection not existing, even though the sql runs correctly in the database.

I have found that the only solution to this problem is to start the package from scratch, and use the EXECUTE DTS 2000 PACKAGE object instead, instead of trying to run it from the migrated package itself.