Cannot perform requested task because full-text manager is not

I am trying to import/transfer data tables from an existing MS SQL
2005 Express Adv install to an MS SQL 2000 Standard install (on
different boxes) but it is not working. It's seems to be failing with
the above mentioned error. Can anyone help with this?
Thanks,
J.Well, do you have full text indexes on Express Adv.? Did you install/enable
full-text on Standard? You are probably trying to move tables with
full-text indexes onto Standard, but it can't set them up because full text
is not there or not enabled...
<Jeffrey.TOL@.gmail.com> wrote in message
news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
> I am trying to import/transfer data tables from an existing MS SQL
> 2005 Express Adv install to an MS SQL 2000 Standard install (on
> different boxes) but it is not working. It's seems to be failing with
> the above mentioned error. Can anyone help with this?
> Thanks,
> J.|||Thanks for your reply. I was leaning towards this but was unsure.
Could you tell me how would I go about checking to see if it is
installed on both servers? Is there an SQL query that I can
perform...?
Cheers,
J.
On May 2, 2:48=A0pm, "Aaron Bertrand [SQL Server]"
<ten...@.dnartreb.noraa> wrote:
> Well, do you have full text indexes on Express Adv.? =A0Did you install/en=able
> full-text on Standard? =A0You are probably trying to move tables with
> full-text indexes onto Standard, but it can't set them up because full tex=t
> is not there or not enabled...
> <Jeffrey...@.gmail.com> wrote in message
> news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
>
> > I am trying to import/transfer data tables from an existing MS SQL
> > 2005 Express Adv install to an MS SQL 2000 Standard install (on
> > different boxes) but it is not working. =A0It's seems to be failing with=
> > the above mentioned error. =A0Can anyone help with this?
> > Thanks,
> > J.- Hide quoted text -
> - Show quoted text -|||> Thanks for your reply. I was leaning towards this but was unsure.
> Could you tell me how would I go about checking to see if it is
> installed on both servers? Is there an SQL query that I can
> perform...?
I would check the services applet in the control panel.|||Yup looked there but it didn't say much, so I tried a reinstall and
the option was there but unselected. Once the install went through,
all was well. I am copying the data now. Thanks!!!
Cheers,
J.
On May 2, 3:10=A0pm, "Aaron Bertrand [SQL Server]"
<ten...@.dnartreb.noraa> wrote:
> > Thanks for your reply. =A0I was leaning towards this but was unsure.
> > Could you tell me how would I go about checking to see if it is
> > installed on both servers? =A0Is there an SQL query that I can
> > perform...?
> I would check the services applet in the control panel.|||Jeffrey,
If you do not need the full text indexes, I suppose that you could go
through your databases (there are only a few, right) and try to drop all
full-text indexes.
Look under:
DatabaseName
Storage
Full Text Catalogs
From the catalogs you can determine which tables have full text indexes. If
you script a drop of the catalog it will script out a drop the indexes then
drop the catalogs. I have not tested this, but it is a free idea. If it
seems suitable, try it out and see if solves your problem.
RLF
<Jeffrey.TOL@.gmail.com> wrote in message
news:a3e0cfaf-2fef-47c9-af25-9a72bf3499d5@.y38g2000hsy.googlegroups.com...
Thanks for your reply. I was leaning towards this but was unsure.
Could you tell me how would I go about checking to see if it is
installed on both servers? Is there an SQL query that I can
perform...?
Cheers,
J.
On May 2, 2:48 pm, "Aaron Bertrand [SQL Server]"
<ten...@.dnartreb.noraa> wrote:
> Well, do you have full text indexes on Express Adv.? Did you
> install/enable
> full-text on Standard? You are probably trying to move tables with
> full-text indexes onto Standard, but it can't set them up because full
> text
> is not there or not enabled...
> <Jeffrey...@.gmail.com> wrote in message
> news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
>
> > I am trying to import/transfer data tables from an existing MS SQL
> > 2005 Express Adv install to an MS SQL 2000 Standard install (on
> > different boxes) but it is not working. It's seems to be failing with
> > the above mentioned error. Can anyone help with this?
> > Thanks,
> > J.- Hide quoted text -
> - Show quoted text -|||Well, the reinstall was a better idea. Congrats. - RLF
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23Ag4UyIrIHA.524@.TK2MSFTNGP05.phx.gbl...
> Jeffrey,
> If you do not need the full text indexes, I suppose that you could go
> through your databases (there are only a few, right) and try to drop all
> full-text indexes.
> Look under:
> DatabaseName
> Storage
> Full Text Catalogs
> From the catalogs you can determine which tables have full text indexes.
> If you script a drop of the catalog it will script out a drop the indexes
> then drop the catalogs. I have not tested this, but it is a free idea. If
> it seems suitable, try it out and see if solves your problem.
> RLF
> <Jeffrey.TOL@.gmail.com> wrote in message
> news:a3e0cfaf-2fef-47c9-af25-9a72bf3499d5@.y38g2000hsy.googlegroups.com...
> Thanks for your reply. I was leaning towards this but was unsure.
> Could you tell me how would I go about checking to see if it is
> installed on both servers? Is there an SQL query that I can
> perform...?
> Cheers,
> J.
>
>
> On May 2, 2:48 pm, "Aaron Bertrand [SQL Server]"
> <ten...@.dnartreb.noraa> wrote:
>> Well, do you have full text indexes on Express Adv.? Did you
>> install/enable
>> full-text on Standard? You are probably trying to move tables with
>> full-text indexes onto Standard, but it can't set them up because full
>> text
>> is not there or not enabled...
>> <Jeffrey...@.gmail.com> wrote in message
>> news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
>>
>> > I am trying to import/transfer data tables from an existing MS SQL
>> > 2005 Express Adv install to an MS SQL 2000 Standard install (on
>> > different boxes) but it is not working. It's seems to be failing with
>> > the above mentioned error. Can anyone help with this?
>> > Thanks,
>> > J.- Hide quoted text -
>> - Show quoted text -
>

cannot import table in management studio wizard. ODBC Error

Im using the Tasks/Import wizard in Management Studio for a 2005 MSSQL to import a table from another database, same MSSQL server

on my machine im having: mssql 2000 (default instance), mssql 2005. 2000 is not running, only 2005.

(by the way: all .net tools like Management Studio, Database explorer in VS 2005 and so on NEVER find the 2005 instance in the combo for available servers ! i always have to enter it manually)

I am always getting:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Error)

Messages

The connection "SourceConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found.
({3A6A6A25-FF8B-4E17-B2A9-C0181A291B5D})

I tried all scenarios:

different databases / tables in same server / different servers, 1 talbe, many....

it always stops there !

What do I have to do ? It is impossible to work like that !

thanks in advance, Michael

Is microsoft going to answer this? I have seen many posts like this but no solution?|||

They finally did after some month! in another thread

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=255347&SiteID=1

see: http://support.microsoft.com/kb/913817

hope this helps, good luck

Michael

cannot import table in management studio wizard. ODBC Error

Im using the Tasks/Import wizard in Management Studio for a 2005 MSSQL to import a table from another database, same MSSQL server

on my machine im having: mssql 2000 (default instance), mssql 2005. 2000 is not running, only 2005.

(by the way: all .net tools like Management Studio, Database explorer in VS 2005 and so on NEVER find the 2005 instance in the combo for available servers ! i always have to enter it manually)

I am always getting:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Error)

Messages

The connection "SourceConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found.
({3A6A6A25-FF8B-4E17-B2A9-C0181A291B5D})

I tried all scenarios:

different databases / tables in same server / different servers, 1 talbe, many....

it always stops there !

What do I have to do ? It is impossible to work like that !

thanks in advance, Michael

Is microsoft going to answer this? I have seen many posts like this but no solution?|||

They finally did after some month! in another thread

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=255347&SiteID=1

see: http://support.microsoft.com/kb/913817

hope this helps, good luck

Michael

Cannot import Oracle data with OLE DB

I have a column in an Oracle source system with data type NUMBER(38,2). The value "-0.01" is causing problems when trying to import into a SSIS data-flow.

The only way I can import this into my data-flow is by using a Datareader connection manager using the ODBC Data Provider. My DSN is using the Oracle ODBC driver.

If I try and use the "Native OLE DB\Microsoft OLE DB Provider for Oracle" I get an error: "The data value cannot be converted for reasons other than sign mismatch or data overflow"

Judging by this post: http://microsoftdw.blogspot.com/2005/11/final-storyhow-to-get-data-out-of.html there aren't really any other combinations to try that will bring my data in as I want it.

I don't want to use ODBC though as:

Its an old technology Its slow I have to deploy an additional DSN.

Can anyone tell me why the other options don't work? Why does Microsoft OLE DB Provider for Oracle have a problem with "-0.01"?

-Jamie

When I tried to reproduce the issue reported by you, I encountered different set of problems. I tried to copy data from a Oracle table with NUMBER(38,2) column to a SQL Server 2005 table with a NUMERIC (38,2) column using OraOLEDB (and later using MSDORA) OLE DB connection manager at the source. I dont get any error messages when I execute the package. However, no data is transferred and I do not see any data when I preview the data at the source. May be I am missing something that you did that produced the error message you got.|||

Well I can't even preview the data so I think my problem is more deep seated. My errors occur in the source adapter and hence I think I have a problem in the middleware.

-Jamie

Cannot Import from Filemaker !

Hi all,
I am trying to import data from Filemaker Pro 5 database into SQL Server
2000 using DTS.
The problem is that big text columns are truncated to 255 chars.
Despite I use ntext or text or nvarchar(4000) in destination table, datas
are systematically truncated.
What hapens ?
Please help !
EricIt sounds rather like this problem but this problem has text files. Can you
workaround in a similar fashion ?
DataPump truncates delimited fields to 255 characters
(http://www.sqldts.com/default.aspx?297)
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Eric" <tritet@.free.fr> wrote in message
news:bo604k$6ks$1@.reader1.imaginet.fr...
> Hi all,
> I am trying to import data from Filemaker Pro 5 database into SQL Server
> 2000 using DTS.
> The problem is that big text columns are truncated to 255 chars.
> Despite I use ntext or text or nvarchar(4000) in destination table, datas
> are systematically truncated.
> What hapens ?
> Please help !
> Eric
>
>|||The problem is still there after installing SP3 for Sql server.
The problem is that I want to import data from Filemaker to sql server.
It is an import action, not export as related in this Bug report :
247527 FIX: DTS May Truncate Characters When You Export a Table Column of
Character Data Type to a Text File
Occurs only with strings that are over 255 in length under certain
conditions.
Corrected in SQL Server 2000 SP2.
"Allan Mitchell" <allan@.no-spam.sqldts.com> a écrit dans le message de
news:u2Dkr$ioDHA.2416@.TK2MSFTNGP10.phx.gbl...
> It sounds rather like this problem but this problem has text files. Can
you
> workaround in a similar fashion ?
> DataPump truncates delimited fields to 255 characters
> (http://www.sqldts.com/default.aspx?297)
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "Eric" <tritet@.free.fr> wrote in message
> news:bo604k$6ks$1@.reader1.imaginet.fr...
> > Hi all,
> >
> > I am trying to import data from Filemaker Pro 5 database into SQL Server
> > 2000 using DTS.
> >
> > The problem is that big text columns are truncated to 255 chars.
> >
> > Despite I use ntext or text or nvarchar(4000) in destination table,
datas
> > are systematically truncated.
> >
> > What hapens ?
> >
> > Please help !
> >
> > Eric
> >
> >
> >
>

Cannot import file from Mainframe

Hello Everybody!
Im trying to migrate my SQL 2000 packages that′s currently working in the company production enviroment to SSIS packages. So, in the 2000 version i got the flat file from Mainframe and i had to do a trick to transform all the columns to match the same size as the example above:

1432 1138734217 1144256628<CRLF>
1432 1138734217<CRLF>
1433 1136657788 1122441177<CRLF>
1433 1125554545 1122441177<CRLF>
1433 1192925544 1122441177<CRLF>

So, when i import the file, first of all i have to transform the Text file to another texfile file fixing the size to 32..... but you can see that in the second row im receiving a CRLF and if i try to import without the trick, the preview of the ragged file show me the columns desorganized...

Someone knows how to import it without transform to another text file with fixed length?
Thanks
Cleber

Hi

Have you already tried with a Flat File Connection Manager using the Ragged Right format and the {CR}{LF} Header Row delimiter ?

I've quickly tried and it seems to be ok.

Cheers,

|||Sorry!

I tried this way but the mainframe did not send a header :(

Thanks for the help!