Can I backup database using SQL server 2005 express to CD or DVD

Hi,

I tried to backup a database in MSSQL 2005 using Management studio express edition directly to CD. The CD is formated with Sonic DLA. I'am getting this error message:

TITLE: Microsoft SQL Server Management Studio Express

Backup failed for Server 'adilpc\sqlexpress'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Write on "D:\Test" failed: 87(The parameter is incorrect.) (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

Is it possible to backup directly to a CD or am I missing something? Any help is greatly appreciated.

Tnx

Adil

Hello

It's impossible to backup with SQL DServer 2005 Express directly to CD.

You can backup only to a file on a tape drive or a hard disk ( local or over a network connection ).

Afterwards, you have to copy this file to a CD

Sorry but SQL Server 2005 Express is free

It' possible with the standard,workgroup,Enterprise editions

Have a nice day

Can AS 2005 connect to Teradata directly?

Hi,
We need Analysis Service 2005 connect to Teradata directly, but we cant
find the way. There is no odbc driver selection in AS 2005. How can we do
that?
Thanks
Byron Hu
Contact Teradata. They are releasing an OLEDB Provider for TD and it can be
used by AS2K5.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Byron" <byron_hu@.uuu.com.tw> wrote in message
news:eJi2wlsoFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We need Analysis Service 2005 connect to Teradata directly, but we cant
> find the way. There is no odbc driver selection in AS 2005. How can we do
> that?
> Thanks
> Byron Hu
>
|||Thank you.
We'll try it. We have heard AS 2005 will not support ODBC. Is that true?
Byron
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> glsD:O01DX1soFHA.764@.TK2MSFTNGP14.phx.gb l...
> Contact Teradata. They are releasing an OLEDB Provider for TD and it can
> be used by AS2K5.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Byron" <byron_hu@.uuu.com.tw> wrote in message
> news:eJi2wlsoFHA.1948@.TK2MSFTNGP12.phx.gbl...
>
|||I don't know if I would word it that way.
AS2K5 only supports OLEDB (in fact this is true with *all* versions of AS,
even back to the V7 days). What is new is that SQL2K5 on the relational side
has dropped support for the OLEDB Provider for ODBC. Thus AS has no way of
getting to a general ODBC data source.
If the only way of getting to your data is via ODBC then you will have to
read it from SSIS and then pump it into AS with the AS processing task that
is available to it -- or you could stage it in a data source with an OLEDB
provider being available.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Byron" <byron_hu@.uuu.com.tw> wrote in message
news:Ozj%23FCvoFHA.2472@.TK2MSFTNGP15.phx.gbl...
> Thank you.
> We'll try it. We have heard AS 2005 will not support ODBC. Is that true?
> Byron
> "Dave Wickert [MSFT]" <dwickert@.online.microsoft.com>
> glsD:O01DX1soFHA.764@.TK2MSFTNGP14.phx.gb l...
>

Can AS 2005 connect to Teradata directly?

Hi,
We need Analysis Service 2005 connect to Teradata directly, but we cant
find the way. There is no odbc driver selection in AS 2005. How can we do
that?
Thanks
Byron HuContact Teradata. They are releasing an OLEDB Provider for TD and it can be
used by AS2K5.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Byron" <byron_hu@.uuu.com.tw> wrote in message
news:eJi2wlsoFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We need Analysis Service 2005 connect to Teradata directly, but we cant
> find the way. There is no odbc driver selection in AS 2005. How can we do
> that?
> Thanks
> Byron Hu
>|||Thank you.
We'll try it. We have heard AS 2005 will not support ODBC. Is that true?
Byron
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> glsD:O01DX1soFHA.764@.TK2
MSFTNGP14.phx.gbl...
> Contact Teradata. They are releasing an OLEDB Provider for TD and it can
> be used by AS2K5.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Byron" <byron_hu@.uuu.com.tw> wrote in message
> news:eJi2wlsoFHA.1948@.TK2MSFTNGP12.phx.gbl...
>|||I don't know if I would word it that way.
AS2K5 only supports OLEDB (in fact this is true with *all* versions of AS,
even back to the V7 days). What is new is that SQL2K5 on the relational side
has dropped support for the OLEDB Provider for ODBC. Thus AS has no way of
getting to a general ODBC data source.
If the only way of getting to your data is via ODBC then you will have to
read it from SSIS and then pump it into AS with the AS processing task that
is available to it -- or you could stage it in a data source with an OLEDB
provider being available.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Byron" <byron_hu@.uuu.com.tw> wrote in message
news:Ozj%23FCvoFHA.2472@.TK2MSFTNGP15.phx.gbl...
> Thank you.
> We'll try it. We have heard AS 2005 will not support ODBC. Is that true?
> Byron
> "Dave Wickert [MSFT]" <dwickert@.online.microsoft.com>
> glsD:O01DX1soFHA.764@.TK2MSFTNGP14.phx.gbl...
>

Calling user-defined functions in OLE DB Command transformation

Hi

We have a user-defined function that can be called directly via SQL (in SQL Server Management Studio) without error. We would like to use this function to populate a column, whist data is being processed within Integration Services. Using an OLE DB Command transformation to achieve this would seem the most appropriate.

The following was inserted for the SQLCommand property:

EXEC ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)

However, when the Refresh button is pressed we are presented with the error below:

Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x8004E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x8004E14 Description: "Invalid parameter number".

If we use SET instead of EXEC (e.g. SET ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)) the following error is produced:

Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error".

Any assistance would be greatly appreciated.

Thanks

Neil

You cannot use SET or EXEC with a UDF. You need to use

SELECT @.ReturnVar = [dbo].fnYourFunctionName ( @.InputVar )

Calling user-defined functions in OLE DB Command transformation

Hi

We have a user-defined function that can be called directly via SQL (in SQL Server Management Studio) without error. We would like to use this function to populate a column, whist data is being processed within Integration Services. Using an OLE DB Command transformation to achieve this would seem the most appropriate.

The following was inserted for the SQLCommand property:

EXEC ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)

However, when the Refresh button is pressed we are presented with the error below:

Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x8004E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x8004E14 Description: "Invalid parameter number".

If we use SET instead of EXEC (e.g. SET ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)) the following error is produced:

Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error".

Any assistance would be greatly appreciated.

Thanks

Neil

I apologize if I missed something obvious, but can you tell me where in the product you're using this? Is it in a dgen plan?|||

I beleive this post belongs in the SS Integration Services Forum.

Alle

|||

EXEC ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)

Even though you are in the wrong forum, I think the first parameter in red could be your problem. Check the assignment in the Input / Output properties of the Ole DB Command component. The names of the Inputs and Outputs must be specific "Param_0", "Param_1", etc.. Check SSIS help on the subject.

HTH
Alle

|||

Correct, this is an Integration Services question - I posted to the wrong forum, apologies for that.

The Input and Output Properties tab does not yet display any Inputs or Outputs, as the error prevents the creation of the parameters. As soon as the statement is entered into the SqlCommand box and the Refresh button pressed, the error is produced with no parameters created, hence preventing further progress.

Thanks

Neil

|||Moved to the SQL Server integration services forum :).|||

Did you resolve this? I'm having the same prob. too!

Cheers,

Tamim.

|||

Tamin,

The origianl poster seems to be providing a worng sintax to call the function...

Can you provide the syntax your are using and the error generated?

Calling user-defined functions in OLE DB Command transformation

Hi

We have a user-defined function that can be called directly via SQL (in SQL Server Management Studio) without error. We would like to use this function to populate a column, whist data is being processed within Integration Services. Using an OLE DB Command transformation to achieve this would seem the most appropriate.

The following was inserted for the SQLCommand property:

EXEC ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)

However, when the Refresh button is pressed we are presented with the error below:

Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x8004E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x8004E14 Description: "Invalid parameter number".

If we use SET instead of EXEC (e.g. SET ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)) the following error is produced:

Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error".

Any assistance would be greatly appreciated.

Thanks

Neil

I apologize if I missed something obvious, but can you tell me where in the product you're using this? Is it in a dgen plan?|||

I beleive this post belongs in the SS Integration Services Forum.

Alle

|||

EXEC ? = dbo.GetOrderlineStatus(@.dt_required = ?, @.dt_invoice = ?, @.dt_despatch = ?, @.ch_status = ?, @.si_suffix = ?, @.re_quantity = ?, @.vc_invoice_id = ?, @.vc_order_id = ?)

Even though you are in the wrong forum, I think the first parameter in red could be your problem. Check the assignment in the Input / Output properties of the Ole DB Command component. The names of the Inputs and Outputs must be specific "Param_0", "Param_1", etc.. Check SSIS help on the subject.

HTH
Alle

|||

Correct, this is an Integration Services question - I posted to the wrong forum, apologies for that.

The Input and Output Properties tab does not yet display any Inputs or Outputs, as the error prevents the creation of the parameters. As soon as the statement is entered into the SqlCommand box and the Refresh button pressed, the error is produced with no parameters created, hence preventing further progress.

Thanks

Neil

|||Moved to the SQL Server integration services forum :).|||

Did you resolve this? I'm having the same prob. too!

Cheers,

Tamim.

|||

Tamin,

The origianl poster seems to be providing a worng sintax to call the function...

Can you provide the syntax your are using and the error generated?