SQL DTS Designer Components Not Visible
Aug 20, 2007Hi,
I installed SQL 2005 Enterprise Edition and SQL DTS Designer Components. However I cannot find the icon of the SQL Designer Components.
Thanks.
Lian.
ADVERTISEMENT
Relationships Not Visible In The Query Designer
Jan 26, 2008Hello
I have created some tables and relationships between them by using MS SQL Server Management Studio Express.
The relationships are between a field named OId, which is not a part of the primary key but it is typed as an unique key. And a field named ParentTableOId.
When I open the two tables that have this relationship in the "Design Query in Editor" is not the relationship there.
Anybody who knows why?
Best Regards
/Erik
Relationships Not Visible In The Query Designer
Jan 26, 2008Hello
I have created some tables and relationships between them by using MS SQL Server Management Studio Express.
The relationships are between a field named OId, which is not a part of the primary key but it is typed as an unique key. And a field named ParentTableOId.
When I open the two tables that have this relationship in the "Design Query in Editor" is not the relationship there.
Anybody who knows why?
Best Regards
/Erik
Select All Option Visible In Designer But Gone On Report Manager
Mar 19, 2007Hello,
I have several reports that use parameters that I have defined as multi-value. When I am designing the reports I see the "(Select All)" option listed first in each parm control that has the multi-value property set true. However, when the same reports are deployed to our server and viewed through Report Manager, the "(Select All)" option is missing. I need the "(Select All)" to be present.
I've seen some discussion of a service pack. Could this be the problem? What do we need to do to get our "(Select All)" back?
Thanks,
BCB
Organize DFT Components In Designer
Jul 4, 2007Hello,
I have DFTs with around 50 components and future ETLs will have 100+ components in DFTs.
I was wondering that is there anyway to group components like we have #region in C#.
Thanks,
Kapil
DTS 2000 Designer Components
Mar 24, 2006After installing the DTS 2000 designer components from the feature packI get the following error message when trying to open a package:
----------
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
---------
The thing is that I have installed them!! so what's going on here, is there a registry key I need to remove or something?, I've uninstalled and re-installed them, rebooted the server numerous times but still no joy, SQL Server just tells me that they're not installed, as you can imagine this is a real pain as I cannot do anything with my legacy packages on the 2005 server.
I cannot just migrate the packages from my 2000 server as they are in daily use on a production server. Is there an option to migrate/copy packages but leave the source packages untouched?
Help!
SQL Server 2000 DTS Designer Components
Dec 5, 2006I kept getting DTS packages edit message before upgrading my DB from Upgrade advisor, even though I don't have any DTS package. Would someone help on how to Retain or restore the DTS Designer by obtaining and installing the special Web download of SQL Server 2000 DTS Designer Components?
View 1 Replies View RelatedMicrosoft SQL Server 2005 DTS Designer Components
Oct 30, 2006Hi,
I learned this from one of SSIS book-Migrating from Data Transformation Services to Integration Services in SQL.
For the design time components, Microsoft has created a special distribution called the Microsoft SQL Server 2005 DTS Designer Components. The Designer Components distribution replaces the components that get uninstalled when you upgrade your last instance of SQL Server 2000. If you want to upgrade all your SQL Server 2000 instances, this is the best and only option for recovering the DTS designer.
Is anybody heard of this 2005 DTS Designer component?
Where to download? How it works? Any experience to will be appreciated.
Thanks,
Charley
Errors After Installing Server 2000 DTS Designer Components
Jan 30, 2007Hello,
After Having installed the SQL Server 2000 DTS Designer Components necessary
to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager:
"The procedure entry point
?ProcessExecute@@YAXPAUHWND_@@PBG1@Z could not be located in teh dynamic link library SEMSFC.dll."
Is there a way to fix so that I can open Enterprise manager?
Thanks!
Dangerous MSI Microsoft SQL Server 2000 DTS Designer Components
Nov 17, 2006Microsoft SQL Server 2000 DTS Designer Components has cause a total destruction of my Enterprise Manager.
In my workstation I've got Sql Server 2000 client and Sql Server 2005 client. Everything goes fine up to here.
But when I've installed that MSI I have not been able to open my Enterprise Manager.
From MMC appears: Error initializing component CLSID: {xxx.xxx}
My goal was be able to open 2000 stuff from Sql Management Studio. By the moment, I'm forget of that.
Does anyone have ever faced this issue?
QA is working.
Thanks in advance for any suggestion
How Can I Use Microsoft SQL Server 2000 DTS Designer Components On X64 Machine?
Feb 27, 2006Is there a X64 version of Microsoft SQL Server 2000 DTS Designer Components from Feature pack for SQL Server 2005?
I have installed an X86 version on the AMD64 machine. But when I open a sql 2000 dts package, there is always a warning window.
The Message is as follows:
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.LegacyActionBase.CreateLegacyDesigner()
at Microsoft.SqlServer.Dts.ObjectExplorerUI.OpenLegacyPackageAction.Act(INodeInformation nodeInfo)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type)
There are two same assemblys called 'Microsoft.SqlServer.DtsObjectExplorerUI' in the GAC, and one is GAC cache type, the other is zap cache type.
Developing Custom Components By Extending The SSIS Stock Data Flow Components
Sep 7, 2006Everything I've read says that custom data flow components are built by inheriting from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class.
But the stock components such as the Derived Column data flow transformation must each be implemented by their own class. So how do I base my custom components on those classes? The documentation for the PipelineComponent class doesn't list any such subclasses.
Using Composition To Create New Specialised Components From Multiple Sub-components?
Jun 30, 2006Hi,
In another thread Jamie Thomson very informatively said "The components in SSIS
are deliberately atomic (i.e. they do something very specific) so that
its easy to put them together to build something greater than the sum
of the parts". Which does make a lot of sense. However, I've been finding that I end up having to create exactly the same "pattern" of combined transform components again and again in order to solve the same problem but in different dataflows (or even within the same dataflow). Cut-and-paste-tastic! In order to obtain real re-use, it seems to me like SSIS is crying out for an easy way to create new components by using composition - i.e. the ability to take commonly-used combinations of existing components and create new "super" components (without having to write Custom Transform Components in C#/VB.Net and handle everything in code).
Does anyone know if this sort of functionality is likely to make it into SSIS in the forseeable future?
Regards,
Lawrie
SQL Executive NOT Visible...
Mar 23, 1999Hi,
When I register an SQL Server from elsewhere on the network, some of them are not displaying SQL Executive in the Enterprise manager.
Why is this?
Data Not Visible???
Jan 27, 2004I recently imported some Access tables into SQL Server. I can go into enterprise manager and return all rows and the data is there.
I build an ASP page to edit the data. After the connection the data for the record is displayed in a form. For some reason some fields are not coming through?
Is this a problem when converting to SQL Server. It just doesn't make sense that the table in Enterprise manager says the field is populated but when I do a pull via ASP the data doesn't come through.
Does anyone know anything about this?
Any help or pointing in the right direction would be greatly appreciated.
Thanks,
JW
SUM Only Visible Rows
Oct 1, 2007I am using an expression to hide values in a row based on a date field ( if date is bewtween this date and that date show value, otherwise hide it). My problem is now I need to sum all the values, even though some are not visible the sum is still adding them. Is there an expression to check for only "visible" rows??
View 6 Replies View RelatedKeep The First 2 Columns Visible
Jan 16, 2008I got a Report with a lot of columns and if the user scrolls, I would like to keep the first 2 columns visible. Excel offers a function like this is there something like this in Reporting?
Triggers Not Visible
Jun 18, 2007i created two new instances of SQL Server and created 2 triggers on each of these instances.
I go to object explorer under the triggers plus sign and there's no triggers there. But these instances recognize that the triggers are there because when i try to recreate them, i get a trigger already exist error message.
Is there a problem with my instances or is there something i need to change or configure?
I will really appreciate any help on this
SQL Server Not Visible
Feb 15, 2007I can't seem to make the SQL Server visible to anything other then SQL Server Tools. (management Studio, etc.)
Neither Visual Studio 2005, or Administrative Tools/Data Sources can view or connect with my SQL Server.
I need help, Thank you.
Drive Not Visible For Backups
Feb 21, 2008Hi all,
I have a 1 TB network drive on a Windows 2005 sql server that is visible at the OS level.I am trying to use this for my SQL backups but this drive is not visible from SQL server. All the other drives appear fine except this drive. The OS team already checked everything and as its visible at the OS level they point to SQL server as the one having problems.
Any suggestion would help..
-Thanks all.
System Tables Are Not Visible At All, Why?
Jun 16, 2006Dear all,
When you go to Sql Management Studio->Object Explorer and select Tables and then System you don€™t see any at all.
Why are not visible system tables for each user database as previously did Sql Server 2000 ? They are hidden or there is other stuff?
Any thought or view would be very appreciated.
Check If An Object Is Visible
May 1, 2008
Is there anyway to check if a textbox (or detail row, etc) is visible? I'm envisioning something like an 'isVisible' function. I'm trying to set a filter in the detail section based on a toggled visibility.
Thanks.
Brad
CLR Stored Procedure Not Visible
Dec 20, 2005I am trying to do some time series analysis on data that I have. I've read that the best way to do this is to use CLR to write the manipulation code in .Net and then load the assembly into SQL rather than extracting the data, manipulating it and putting it back again.
I'm using crystal reports with visual studio 2003 to do my reporting. The problem I am facing is that the CLR stored procedures I create using SQLExpress are not visible from my SQL explorer built into Visual Studio 2003. I can create stored procedures using standard transact sql and these are visible, but the CLR stored procedures are not.
I've noticed when I browse the stored procedures in my SQL Management Studio that the image of the stored procedure has a padlock shown in the icon, as if they are locked?
Do I have to explicitly enable a security attribute on CLR stored procedures to make them visible?
Any help would be greatly appreciated.
Home Properties Tab NOT Visible
Apr 1, 2008
When I type my 'http://ServerName/rmMyManager/Pages/Folder.aspx' I can see only Home and NOT Properties. I can see all the folders below that I have .
Just two days back I have changed permission to allow only me for deploying and have all those settings. Please guide me accordingly.
Dts Object Not Visible In My DataFlow ScriptComponent
Jan 30, 2007I am trying to set the TaskResult in my DataFlow ScriptComponent, but the Dts object is not visible.
Dts.TaskResult = Dts.Results.Failure
The above line works fine in my EventHandler script, but the Dts object seems to be out of scope when I try to use it from my Dataflow.
One thing I have noticed is that my DataFlow ScriptComponent inherits from 'UserComponent'
I have tried adding Microsoft.SqlServer.ScriptTask reference, but can not see it in the reference list - Strange?
Any help appreciated.
Regards,
Paul.
Stored Procedure Not Visible In SQL Express
Apr 7, 2006I have SQL express installed in my server and I created a stored procedure using SQL server management studio express, but when I refresh my stored procedures the one I created does not show. Please help.
Your valuable feedback is greatly appriciated.
+/- For Toggling Visible And Invisible Groupings
Mar 17, 2007When defaulted to Visible or Invisible, +/- displays correctly. But when using the Expression, + is always showing as the default even when a group is expanded. Is this expected? TIA.
Why Is A User Variable Not Visible In Expressions?
Oct 26, 2007I have defined a variable varFileName and when I go to the Expression Builder in my Connection Manager Properties I can't see it and even when I type the name it says the variable is not existent or in a different scope. I have set the scope to be the very same package, that's for sure. Can anybody please tell me, as I can't solve this mistery, why the Builder does not see the var???
Darek
ReportItems Only Visible On Print/export
Jan 14, 2008
Is there a way to make some elements on a report appear only when printed/exported ?
I recall this is possible in MS Access forms/reports, but am unable to find it in RS.
I'm thinking of Disclaimers, Company Logo etc...
Visible Parameters That User Cannot Change
Mar 17, 2008I have a report that I want users to navigate to and I want them to see the parameters of the report, but I don't want them to be able to change them. Is this possible?
View 3 Replies View RelatedData Processing Extension Not Visible
May 3, 2007hello,
I have written a Custom Data Processing Extension for SSRS 2005.
The Report Server is in SharePoint integrated mode, this works perfect except for the extension.
When I want to set a DataSource in SharePoint (WSS 3.0), the extension is not in the ComboBox.
This works well on another server with the same extension.
The DLL file of that extension is copied in the reportserver bin folder.
I have added the references in the rsreportserver.config and rssrvpolicy.config (see below).
Code Snippetrsreportserver.config
<Data>
<Extension Name="SPSLISTS" Type="ICom.ReportingServices.SharepointListsExtension.Connection,
ICom.ReportingServices.SharepointListsExtension" />
<Data>
Code Snippet
rssrvpolicy.config
This code is located inside the CodeGroup with Name="SharePoint_Server_Strong_Name".
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="SPSLISTS_CodeGroup"
Description="Code group for my SPS LISTS data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinICom.ReportingServices.SharepointListsExtension.dll"
/>
</CodeGroup>
I already tried re-installing Reporting Services and the add-in for SharePoint but the problem remains.
Does anyone has an idea of what's wrong here?
Thanks in advance,
Tom
Making Groups Visible Using Parameters
Apr 25, 2007Hi everyone,
I am new to reporting services and really need some help..
Im trying to simply my requirement using this scenario: Lets say
I want to display Sales for the current year (i.e from the start of the year january to the month we are currently at). The next requirement is to group these sales, by Area , Region , Zone...
Top leve l = Zone , then Region then Area.
I need the user to be able to control this using a parameter (i.e User can select "View Area Level" or "View Region Level" or "View Zone level")
How can this best be achieved ?
My idea was using row groupings and controling visibility using the parameter.. The problem is.. If i want to view ONLY the area level and not see anything above, can I turn visibility off of the Zone and Region and still see the inner group (area)
Area Level (default view)
Jan Feb
Area 1 100 100
Area 2 200 200
Region Level Selected
Reagion 1
Area 1 100 100
Region 2
Area 2 200 200
Zone Level Select
Zone 1
Region 1
Area 1 100 100
Region 2
Area 2 200 200
Any help would REALLY be appreciated ..
Kind Regards,
Neil
Import Data Option Not Visible
Aug 22, 2007Hello All,
I have created a database on my local machine using SQL Server Express 2005. I am trying to export data from an excel file into a table in this database but when i see tasks available for the database there is no option of import data like I assume there should.
Only the following options are visible.
Detach
Shrink
Back Up
Restore
Generate Scripts
Any solutions on how I can get my excel file into the table.
Kiran