readonly custom property

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - replicating UDT's to subscribers I am not sure if this will solve your problem but you can try re-initializing your subscription before regenerating a new snapshot. -Raymond Tag: readonly custom property
  - 2
    - XQUERY / XPATH versus nodes containing ":"-character Hi, all. I'm having problems using XPATH / XQUERY versus input containing ":" in the node names. Example: Code Snippet <MyData:Output xmlns:MyData=" www.myprovider .com"> <MyData:Provider> <MyData:Property MyData:Name="FirstName">Joe</MyData:Property> </MyData:Provider> </MyData:Output> T-SQL (breaks): Code Snippet SELECT XMLContents.query('/MyData:Output/MyData:Provider') FROM dbo.Some_Table __________________________________________________________ XQuery [dbo.Some_Table.XMLContents.query()]: The name "MyData" does not denote a namespace. However, if I remove all the "MyData:" references from code and data, it works fine. I don't have an option of getting the incoming data changed; is there a way to escape the character to get this code to work Tag: readonly custom property
  - 3
    - SQL Server vs. XML Configurations You aren't by chance defining a SQL Server connection (in the package configuration) for the very connection that you need to get to the package configuration table, are you Tag: readonly custom property
  - 4
    - converting to numeric (6,3) Hey guys, I am trying to achive the following: Truncate the values 1680.390000000000000000 to numeric (6,3) All works ok until i hit a value over 1000, (as above) The code i was using is: cos1 = 1680.390000000000000000000 CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3)) I have tried a few others, but nothing seems to work.. I get the following error. "Arithmatic Overflow" Has anyone got any suggestions Thanks guys, Scotty Tag: readonly custom property
  - 5
    - Datasource Views and Teradata I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views. My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard Thanks. Tag: readonly custom property
  - 6
    - Understanding code created by SSIS import/export Wizard Why can you not change these things in SSIS Designer (i.e. BIDS) -Jamie Tag: readonly custom property
  - 7
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: readonly custom property
  - 8
    - Parameterized Queries Just getting started using SSce and having a few problems What I want to do is something like this... Dim Code As Integer Dim Description As String = txtDescription.Text.Trim Dim conn As SqlCeConnection = ConnectToLocalDatabase() Dim ssql As New System.Text.StringBuilder ssql.AppendLine( "INSERT INTO T_Titles (Description)" ) ssql.AppendLine( "VALUES(@Description)" ) ssql.AppendLine( "SELECT @Code = @@IDENTITY" ) Dim cmd As New SqlCeCommand(ssql.ToString, conn) Dim sqlCode As New SqlCeParameter( "@Code" , 0) sqlCode.Direction = ParameterDirection.InputOutput cmd.Parameters.Add(sqlCode) cmd.Parameters.Add( New SqlCeParameter( "@Description" , Description)) cmd.ExecuteNonQuery() Code = CInt (sqlCode.Value) ********************************************************************** The above code doesnt work. Firstly I am not sure if I can execute the two statements in one go. Secondly, I am not sure if output parameters are supported. I have been working with SQL Server since 6.5 but have always used sprocs and am feeling a little lost here without them. Any help getting started would be greatly appreciated. Thanks Tag: readonly custom property
  - 9
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: readonly custom property
  - 10
    - how to extract this text? I have options_field contains a lot of data.. here are examples: DT·NB·NM·ANI=80088080 39139662 ANI=80088080 36637576 ·DNIS=80088080·DT·NB·NM·UNIT ANI=80088080 39188390 ·ANI=8008808017403125·DNIS=80088080·DT·NB·NM·UNIT ANI=80088080 39653135 ·ALIAS·DNIS=80088080·DT·NB·NM·UNIT ALIAS·ANI=80088080 39169467 ·ANI=8008808017326875·UNIT·NM·NB·DT·DNIS=80088080 DT·NB·NM·DNIS=80088080·ANI=80088080 36331200 ·ANI=80088080 39318646 I want to extract every 39 and 36 mobile numbers in the ANI. All numbers are 8digits as highlighted ad some records will have more than mobile number while some won't have any mobile number listed. so the result should be 39139662 36637576 39188390 39653135 39169467 36331200 - 39318646 Tag: readonly custom property
  - 11
    - Differences in varchar size usage, declaring the maximum available of 8000 characters SQL Server does not really allocate space based on the datatype definition in your table. It allocates enough space to hold the data (so if you have 10 chars, it only allocates space for 10 chars). After the data is in memory, one of the checks we do is check the length of the data against the defined length. If the size of the data is bigger, we raise an error. Internally, SQL Server uses several algorithms to avoid too many memory allocations (sometimes it allocates more than needed if it finds out that a lot of string concatenation is being done). The defined size of a variable does not really play a big role here. Are you using SQL Server 2000 or SQL Server 2005 If you use SQL Server 2005, you can use the varchar(max) datatype, which will hold data up to 2GB, and you never really have to worry about the size. SQL Server will do the right thing for you. Only when your data gets bigger than 8K, you might get a small perf hit when using varchar(max) as it won't fit on a single page anymore, but if you have a lot of data that is smaller than 8K, you might as well use varchar(max) as internally in the engine varchar(N) and varchar(max) are treated very simular as long as the data is less than 8K. Hope this helps, Marcel van der Holst [MSFT] Tag: readonly custom property
  - 12
    - Daylight Saving Time DST 2007 Problems so, instead of a 5 hour difference between the two you should see a 4 hour difference Tag: readonly custom property
  - 13
    - end conversation : security context could not be retrieved HI I was reading the other thread about no security header and check the time in the enqueue time, which was ahead of the server time the last enqueue_time on the target was 2007-04-13 22:27:16 but when I did a select getdate() I get 2007-04-13 20:24:03 how can the enqueue time be in the future thanks Paul Tag: readonly custom property
  - 14
    - Unicode causes Dimension build failure? The SQL Server is using Collation SQL_Latin1_General_CP1_CI_AS The Analysis Server is set to Latin1_General, with Accent-Sensitive enabled. These appear to be the same, are these considered the same Tag: readonly custom property
  - 15
    - Change member properties order in excel 2007 pivot table Hi everyone, i am trying to change the member properties order in a excel 2007 pivot table but it wont work... I've found how i should do it according to Microsoft Office web site ( http://office.microsoft.com/en-us/excel/HA101777521033.aspx , see : Display member properties as data in a PivotTable report ) but even if i follow the instruction by the letter it is not working... I've searched a lot but i can't find anything on this... Anybody's having the same issues or know a way around it I'm using SSAS 2005 SP2 and Excel 2007 Thank you very much! Tag: readonly custom property
  - 16
    - SQL Server 2005 Limitation: Having many attributes for Neural Network No, I only care the attributes with value 1 on each row. For example: Jack = Attr1, Attr3, Attr100000 Sam = Attr2, Attr3 Mary = Attr1, Attr2, Attr100000 Customer Attr1 Attr2 Attr3 ..... Atr100000 ============================== Jack 1 0 1 ..... 1 Sam 0 1 1 ...... 0 Mary 1 1 0 ...... 1 To give a better idea of my problem. Here is the scenario. Say that I have a set words to describe each customer's characteristics. Customer Friendly Tall Rich ..... Good Looking =================================== Jack 1 0 1 ..... 1 Sam 0 1 1 ...... 0 Mary 1 1 0 ...... 1 Jack = Friendly, Rich, Good Looking Sam = Tall, Rich Mary = Friendly, Tall, Good Looking I also have 100,000 attributes (Friendly, Tall, Rich, ...., Good Looking). Each attribute can only have 1 or 0 value. Say that I have 1 million rows. In some cases, the same customer may appear more than once in the table. For example: Simon 0 1 1 ...... 0 Simon 1 0 1 ...... 0 I only care the attributes with the value of 1. Later, I want to use Neural Network to find the customers who are friendly and rich. What the best way to implement such idea in Neural Network Please assist! Regards, Mary Tag: readonly custom property
- Next
  - 1
    - Label in parameter Hello! Is it possible to create a row of "labels" in a multi-value parameter list i mean something like this: Name, Age JJ, 12 PP, 10 Thanks //C Tag: readonly custom property
  - 2
    - SSIS performance If you are running the package using "dtexecui" or "visual studio" then you might want to try running it using "dtexec". for example run this command from the command line: dtexec /reporting EW /file Package1.dtsx Tag: readonly custom property
  - 3
    - - DeWayne, Thanks for your help. I have other question: While am s etting up SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile. Receiving the following error. Error 22022 QLServerAgentError: Unable to get the default MAPI Address Book due to MAPI error 271: An error occurred while attempting to open the Window Address Book. Please specify a default mail delivery location in you profile. If I try to create MAPI profile IBM Lotus Domino Access for Microsoft Outlook - create - new profile through getting the below error. Failed to create new MAPI profile. Error creating personal Folders service Note: This error can be caused by an incorrect configuration of out look 2000. If you are using outlook 2000, Please verify that is running in Corporate/Workgroup Mode. Setup encountered an error and failed to create a MAPI profile. You will need to reinstall IBM Lotus Domino Access for Microsoft Outlook (Already we removed and reinstalled) Any help please Ven Tag: readonly custom property
  - 4
    - Problem in Configuring ASPState DB for .NET 2.0 Hi, I got this problem resolved by running the aspnet_regsql.exe with command line options to setup the ASPState DB. Anyways, Thanks for the suggestion. Thanks, Siva Tag: readonly custom property
  - 5
    - Restoring Differentials from 2000 to 2005 Have you thought of using SSIS to move the data, or, Replication Tag: readonly custom property
  - 6
    - Drive allocation The only significant benefit is in 'housekeeping' -easier to backup all files in a partition, for example. However, in this situation, it seems like a little extra overhead for no additional benefit. Hopefully, on a operational server, hosting no other applications except SQL Server, there will be very little disk activity required except for the TRANSACTION Log file -so there should not be any fragmentation, and the heads will most often be in the optimal location. Tag: readonly custom property
  - 7
    - summing semi-additive attribute this is resolved by concatenating 2 fields so that AS will treat it as one Tag: readonly custom property
  - 8
    - formating a text field using regular expression Hi Bob, I have tested this expression on the Report Server. It does work well. I have a red line, too, because SYSTEM.TEXT is not a built-in Class in Reporting Services. First, please make sure that you have installed the latest Service Pack for Reporting Services 2005 and Visual Studio. If the problem still exists, try to replace “First(Fields!JOB_NBR,Value,”main”)” with “A7034E0”. The expression “First(Fields!JOB_NBR.Value,”main”)” may cause the problem. Please post back if the solution doesn’t help. I’m waiting here to provide further assistance. Thanks Tag: readonly custom property
  - 9
    - Help with an Outer Join Hi, Can you please tell what you want to do in text By setting the WHERE clause like this, you are not making a FULL OUTER JOIN but a RIGHT OUTER JOIN. Why For all the records that are in QA_SCORES and that have no associated record in QA_DATA, the field QA_DATA.DATA_DATE will always be NULL. Therefor, these records can not pass the WHERE clause. You can prevent this by changing the WHERE keyword to the AND keyword so that the condition is included in the JOIN. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Tag: readonly custom property
  - 10
    - SQL Express database in published web site I have been working with Visual Studio 2005 and the Personal Web Site Starter Kit. All is well and working. My problem is that after the database is updated (as in uploading photos and album creation) and the original web site is edited and republished, the web site database is overwritten and all the work is lost. What is the proceedure to either copy the web database to the development site on my computer so updates will not be lost, or a method of publishing that will not loose the up to date content on the web server I would much prefer to be able to copy the database to my development computer as adding tables to the database is something that needs to be done. Any help on this would be appreciated. Thanks Tag: readonly custom property
  - 11
    - Transfer Login: Source Server Can not be same as destination server Hi! I have two servers. Server A and Server B Both the servers are in different domains and both have different names. Server A runs a clustered sql server (sql 2005 standard sp1) Server B also runs a clustered sql server (sql 2005 enterprise sp1) Both server A and Server B has same virtual server name X. So, when I try to copy all the logins from server A to Server B using Transfer Login task in ssis, I gert the following error- "Source Server Can not be same as destination server" I am using IP addresses to connect to both the servers. How do i solve this issue now Thanks Tag: readonly custom property
  - 12
    - A Simple Problem. But.... How about updating the table, using the OUTPUT clause to return what you've changed, like: UPDATE thetable SET islocked = 1 OUTPUT DELETED.* WHERE islocked = 0 AND ... --other criteria goes here This way, you'll get the locked rows, and the next user won't be able to. If you want to mark who locked it, then perhaps use a different type for islocked. Hope this helps. Rob Tag: readonly custom property
  - 13
    - Excel 2007 AcquireConnection error I'm creating a small test package that copies a value from an Excel 2007 worksheet into a SQL 2005 database (SP2). When I do an Execute Task, I get the following error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager \\lorip\MandEScorecards\SQLQueryExample.xlsx failed with error code 0xC0202009. However, if I do a "Preview" in the Editor for this same Excel Source task that fails, the data comes up as I would expect. What am I missing Thanks in advance! Tag: readonly custom property
  - 14
    - Join and heavy tables Hi Team, I have a query about the way join works when it comes to dealing with heavily populated tables. I have two tables tableA and tableB each containing lakhs of records but one table is containing less records. The realistic count will be (TableA 100000, TableB 80000). Now when I am performing a join which table should on the left hand side and which table should be on the right hand side Which of the following query should i prefer select * from TableA join Tableb on TableA.column = TableB.column Or Select * from TableA join Tableb on TableB.column = TableA.column Or Select * from TableB join TableA on TableB.column = TableA.column Does it matter if we replace the table names in the join clause and replace it back in the on clause. How does the parser perform the join Thanks in Advance, Vihang Tag: readonly custom property
  - 15
    - Updating an ADO recordset... I'm updating an ADO recordset inside VB6... We just moved the database from SQL Server 2000 to SS2205.... The following code has worked a long-time now when it tries to update the record with SS2205 on the back-end I get a run-time error '3219' Operation is not allowed in this context... Here is the Open statement... SampleRecordset.Open "Select * from samplereleased_view", SampleConnection, adOpenDynamic, adLockOptimistic, adCmdText Here is the line it errors on... SampleRecordset.Update Any thoughts on this issue would be great! Thanks-David Tag: readonly custom property
  - 16
    - SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN You should also run DBCC UPDATEUSAGE in the database, post-upgrade. Chris Tag: readonly custom property

HuangBo

Is there any way to provide a readonly custom property in the ProvideComponentProperties() method of a custom PipelineComponent implementation

Re: readonly custom property

Bob Bojanic - MSFT

No, currently we do not have a way to do that. What would you use the read-only properties for

Thanks.

Re: readonly custom property

HuangBo

I need to generate the value for a custom property internally and make it visible to developers, but I don't want them to modify it to ensure the data flow works correctly.
Hope we'll have a way to do that in the future.

Re: readonly custom property

JayH

HuangBo wrote:

I need to generate the value for a custom property internally and make it visible to developers, but I don't want them to modify it to ensure the data flow works correctly.
Hope we'll have a way to do that in the future.

Couldn't you override SetComponentProperty to reject the change

Re: readonly custom property

HuangBo

I was able to do that. But that's not user friendly since it's not really readonly.

Re: readonly custom property

Bob Bojanic - MSFT

Well, for now I would do what Jay suggested.

Feel free to open a request for adding this feature on the connect site.

Thanks.