Error Regarding file import through import wizard

Hi all,

when trying to ímport files to our database server from a client, I keep getting an error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)

... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.

I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.

best regards

Musa Rusid

I have encountered the same error trying to import flat files created from Excel sheets. What is the solution? Thanks.

Error Regarding file import through import wizard

Hi all,

when trying to ímport files to our database server from a client, I keep getting an error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)

... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.

I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.

best regards

Musa Rusid

I have encountered the same error trying to import flat files created from Excel sheets. What is the solution? Thanks.

Error on updating/adding record

I upsized (using Upsize Wizard) ACCESS back end to MSSQL 2000. Front end is still ACCESS. I'm getting error when trying to add or updated a record entry from front end.
The error message reads: 'Error # 3027 was generated by DAO.Recordset Cannot update. Database or object is read only.'

Thanks for any help.you should be using ADO not DAO

Error on Creating publication

Hi all, when I create publication with New Publication Wizard. I get the following errors. Did someone meet this before? Can you help me? Thanks!

===================================

SQL Server could not create publication 'JK'. (New Publication Wizard)

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)
at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)
at Microsoft.SqlServer.Replication.ReplicationObject.CommonCreate()
at Microsoft.SqlServer.Replication.Publication.Create()
at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.CreatePublicationThreadMethod()

===================================

Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.
Changed database context to 'Test'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3933&LinkId=20476

Server Name: nxstudio-david\sql2k5_dc
Error Number: 3933
Severity: 16
State: 1
Procedure: sp_addmergepublication
Line Number: 1034

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Try setting remote proc trans to 0. i.e.

exec sp_configure 'remote proc trans', 0

go

However you may have custom apps that depend on this being enabled, if so, be careful when flipping this switch.

|||

Greg, Thanks!

I try to follow your instruction, but I get the following message.

"Configuration option 'remote proc trans' changed from 0 to 0. Run the RECONFIGURE statement to install."

It seems the original value is 0 too.

Error on creating cube file from Excel 2003, AS 2005

Hi,

I tried to create a cube file in Excel 2003. Data source is SSAS 2005.

On the last step of wizard I get the following error:
Microsoft OLE DB Provider for Analysis Services 2005:
Query (3,2) Parser: The syntax for 'DIMENSION' is incorrect.

Seems like a bug. Is there any fix?
Tried to search google, found nothing...

SQL Server 2005 Developer SP2
Excell 2003 SP2

Thx for any tip...

certainly sounds like a bug. Can you provide a repro' that the product team can look at?

thanks,

Bala.

Error on creating cube file from Excel 2003, AS 2005

Hi,

I tried to create a cube file in Excel 2003. Data source is SSAS 2005.

On the last step of wizard I get the following error:
Microsoft OLE DB Provider for Analysis Services 2005:
Query (3,2) Parser: The syntax for 'DIMENSION' is incorrect.

Seems like a bug. Is there any fix?
Tried to search google, found nothing...

SQL Server 2005 Developer SP2
Excell 2003 SP2

Thx for any tip...

certainly sounds like a bug. Can you provide a repro' that the product team can look at?

thanks,

Bala.

Error on Configure Web Synchronization Wizard

Got the following error on the last part of the wizard, after setting all the requirements:

Setting the snapshot share permissions (Error)

Messages

The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)

Any tips thanks

Did you run Web Synchronization Wization upon Windows XP?

Thanks.

|||No, the machine where the publisher is located is running on Windows Server 2003... Thanks for the reply|||

Are you trying to add a domain account or a mahcine account?

Is the machine in a domain or in a workgroup?

|||

Mahesh Dudgikar - MSFT wrote:

Are you trying to add a domain account or a mahcine account?

Is the machine in a domain or in a workgroup?

Thanks for the reply.

The machine publishing the articles is just part of a workgroup.

Error messages upsizing from MSAccess database to SQLServer

I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:

Connection failed:

SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQLServer Error: 17

[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.

Does anyone know how I should proceed? Any help would be appreciated.

Thanks

Which version of SQL Server are you using?

Does the following help

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||I am using SQL Server 2005 Express|||Did you try the steps in the link I provided?|||

I did all the steps and I got the following error message:

ODBC - call failed.

I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.

Do you have any recommendations.

Thanks

Mark

|||

http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=49

HTH

Error messages upsizing from MSAccess database to SQLServer

I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:

Connection failed:

SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQLServer Error: 17

[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.

Does anyone know how I should proceed? Any help would be appreciated.

Thanks

Which version of SQL Server are you using?

Does the following help

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||I am using SQL Server 2005 Express|||Did you try the steps in the link I provided?|||

I did all the steps and I got the following error message:

ODBC - call failed.

I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.

Do you have any recommendations.

Thanks

Mark

|||

http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=49

HTH

Error message using "Copy Database Wizard"

Any advice from the crowd? Every time I try to run "Copy Database
Wizard" I get an error message saying I must be a member of the
sysadmin group and have permission to copy files over the network. I'm
a local admin on both boxes and a member of the sysadmin group on both
SQL servers and an admin on the network. What am I missing here?

Thanks,

Ralph Noble
ralph_noble@.hotmail.comIs the target server running under a domain account? Check out:

http://support.microsoft.com/defaul...463&Product=sql

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Ralph Noble" <ralph_noble@.hotmail.com> wrote in message
news:ed6de1e7.0411110741.15429731@.posting.google.c om...
> Any advice from the crowd? Every time I try to run "Copy Database
> Wizard" I get an error message saying I must be a member of the
> sysadmin group and have permission to copy files over the network. I'm
> a local admin on both boxes and a member of the sysadmin group on both
> SQL servers and an admin on the network. What am I missing here?
> Thanks,
> Ralph Noble
> ralph_noble@.hotmail.com

error message

I finally installed MSDE and have the icon in my tray at the bottom of the screen.
When I try to connect to a database using the wizard in the web matrix program I get this message:
Unable to connect
SQL Server does not exist of access denied
Connection Open (Connect ())
What might be wrong??
Thanks for your help I'll get it soon (I hope)
Del Dobbswell, are you specifying the correct instance name? username? password?|||see this

http://support.microsoft.com/?kbid=328306