error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

I tried to create a package from a C# program, and I copied this from SQL server online book:

using Microsoft.Sqlserver.Dts.Runtime;

But I got compilation error:
The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'(are you missing an asssembly reference?)
What am I missing?

Thanks a lot

Have you, in fact, set a reference to Microsoft.SqlServer.ManagedDTS ? This is the assembly that contains the Dts.Runtime namespace.

-Doug
|||How do I set a reference to ManagedDTS? by writting:
using Microsoft.SqlServer.ManagedDTS
?

In this case ManagedDTS can not be found by compiler

Thanks for the hint
|||Please consult the Books Online for support. For example, the following article mentions what DLLs need to be registered:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/e44bcc70-32d3-43e8-a84b-29aef819d5d3.htm
regards,
ash|||found the solution: from visual studio, click Project->Add reference, then browse the assembly ManagedDTS.dll at directory c:\program files\microsoft sql server\90\SDK\Assemblies, this willl add ManagedDTS.dll to the project and solve the problem.

Thanks everyone!|||

Hello,

if you get this problem on your server. build your site in release mode and then you have this dll in your bin\release folder.

Either find this DLL and upload that in your server bin directory manually

error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

I tried to create a package from a C# program, and I copied this from SQL server online book:

using Microsoft.Sqlserver.Dts.Runtime;

But I got compilation error:
The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'(are you missing an asssembly reference?)
What am I missing?

Thanks a lotHave you, in fact, set a reference to Microsoft.SqlServer.ManagedDTS ? This is the assembly that contains the Dts.Runtime namespace.

-Doug|||How do I set a reference to ManagedDTS? by writting:
using Microsoft.SqlServer.ManagedDTS
?

In this case ManagedDTS can not be found by compiler

Thanks for the hint|||Please consult the Books Online for support. For example, the following article mentions what DLLs need to be registered:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/e44bcc70-32d3-43e8-a84b-29aef819d5d3.htm
regards,
ash|||found the solution: from visual studio, click Project->Add reference, then browse the assembly ManagedDTS.dll at directory c:\program files\microsoft sql server\90\SDK\Assemblies, this willl add ManagedDTS.dll to the project and solve the problem.

Thanks everyone!|||

Hello,

if you get this problem on your server. build your site in release mode and then you have this dll in your bin\release folder.

Either find this DLL and upload that in your server bin directory manually

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig