How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - Jump to URL Thanks for the reply rakam, Where do I write and store reportviewer.aspx Sorry for being illiterate here. Thanks Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 2
    - Migrating Data from MySQL I don't mean to sound like a total dummy but I sort of understand what is being said and there is some really good round about information but, it just isn't getting me there. I have a table right now for example that I exported in CSV format from MySQL that has 6 columns and 203 rows. If I create this same table in SQL2005 Express, how do I bring that data into my SQL 2005 database. Admittedly my experience level with SQL and Scripting is not quite beginner but I wouldn't consider myself intermediate either. Could you dumb it down for me a little Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 3
    - Cross Domain Windows Endpoint Authentication? Hi Remus Thank you for the response. So the forwarder simply forwards the message and credentials between initiator and target, correct The fact that the forwarder can connect to either does not resolve the matter Thanx Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 4
    - Periodic "SQL Server Assertion" error . , . - - . . Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 5
    - pass hidden parameter from one dataset to another I have 2 datasets in my report and I want to pass a field from the 1st dataset as a parameter to the 2nd dataset. How can I do this I tried to set the report parameter from a query using the 1st dataset but the parameter is always equal to the first record in the recordset-it never changes per row. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 6
    - Activation Failure Date 5/30/2007 9:36:02 AM Log Database Mail (Database Mail Log) Log ID 516 Last Modified 5/30/2007 9:36:02 AM Last Modified By sa Message Activation failure. I hope this helps. Thank you. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 7
    - How To Connect Remote Server's DataBase from another's Server's QueryWindow If the servers are part of a replicated topology you will have to set the server option for data access to true, is sp_serveroption 'ServerIWishToQuery','Data Access','True' and then select * from ServerIWishToQuery.Database.dbo.TableName Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 8
    - SSIS Yes. AS400 Table character set is defined as 937. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 9
    - Help - Can't get Compact Edition to work with CE.NET 4.2 ! Hi ErikEJ, Thanks for the mail. Unfortunately it didn't solve the problem. Here is what I did: 1. Hard Reset the Device 2. Installed the CF 2.0 SP1 3. Installed the SQL Server 2005 HotFix Cabs (see Note below) obtained from Microsoft: - sqlce30.wce4.armv4i - sqlce30.repl.wce4.armv4i - sqlce30.dev.enu.wce4.armv4i 4. Confirmed that the following SQL Files were in the \Windows Folder: sqlceca30.dll, sqlcecompact30.dll, sqlceer30EN.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll 5. Confirmed that my sample app references the SQLServerCe Dll: C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Device\Mobile\v3.0\System.Data.SqlServerCe.dll Version: 3.0.3600.0 Note : I e-mailed Microsoft re: KB article 924811 as the it seemed a bit misleading. My question was "Is SQL Server 2005 Compact Edition support on CE.NET 4.2". The first e-mail was response was "The current KB article applies to SQL Server 2005 Mobile Edition. It is being updated to reflect the correct information. SQL Server Compact Edition bits are not yet publicly available for Win CE .NET 4.2 devices. However, you may contact MS Tech support with details on your device spec (cpu type) and they can submit a request for you." Shortly after I got a second different response: " Yes, we support SQL Server Compact Edition for CE.Net 4.2. Currently it is released as a hot fix, you need to contact PSS to get the drop locations. As you mentioned the KB article title is very misleading. Actually the KB article is to fix the support for Win CE 4.2. We will change the title of the KB article." Anyone got any ideas on this one Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 10
    - What solutions make returning from a disaster easier? I didn't know about peer-to-peer replication. I started researching it in BOL and it looks pretty good, right up to the point where it said: Use of identity columns is not recommended. In some of our databases, we not only use identity columns, but we use them as foreign keys in other tables, so the workarounds don't seem to help. Nonetheless, in some of our other database (where we don't use identity columns), this looks like a feasible option. So, now I'm up to database mirroring. I'm going to give that a try.... Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 11
    - Error while importing Text file using Import Export Wizard dear sir thank for ur replay about what u say Import/Export wizard offers you the chance to save your package i didnt know how to do it is it in the Import/Export wizard then in column maping click in Edit SQL ... also when u say then open it up and look at the metadata of the pipeline i didnt under stand it ..... sorry but after long investegation i found the following i instal SQL2000 and SQL2005 and i create table inside each of them with the same spacifecation as follows all the colums with data type: varchar and length: 8000 for both tabels. i fined somthing very strange - when i use the Import/Export wizard of SQL2000 i can import the Text file to the table in SQL2000 and to the table in SQL2005 - when i use the Import/Export wizard of SQL2005 i can't import the same Text file to the table in SQL2000 and also can't import it to the table in SQL2005 - when i check the length of the value in the FRDNAME column in row 9 in the text file i found it 53 and when i reduce the length less than 50 for that value i found that the Import/Export wizard of SQL2005 works for both table in SQL2000 and to the table in SQL2005 Even both table have length for all colums as 8000 also i change this length to 100, 500, 1000 and other value but the same result !!!!!!!! Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 12
    - Read the transaction log (ldf) file. My first post ever :) Thanks for the reply. I know there exist som applications that can read log files, like Lumigent Log Explorer. But it would be nice with an freeware version Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 13
    - SSIS Connection Manager passwords I downloaded Service Pack 1 for Visual Studio 2005, Version 8.0.50727.762 (SP.050727-7600), but I still get this error message. I tried the SA username and password for the connections in connection manager, but even after I checked the save password box and close the connection and reopen, it gives me the following error message: "Test connection failed because of an error in intializing provider. Login failed for user 'sa'." Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 14
    - How to drill down on fields Hi Jens , Thanks for did that and am able to see the data .. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 15
    - System.Data.SqlServerCE.dll reference causes error ... What happens if you remove this reference again - does it go back to working properly Have you added a reference to the correct version of system.data.sqlserverce.dll (see this post across at www.sqlserverce.org ) as this might be a cause - although it normally manifests itself as a build error rather than a runtime issue. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 16
    - Deploying reports to MOSS 2007 The TargetDataSource Folder is http://vpc001/ReportingServices/DataSources, the TargetReportFolder is http://vpc001/ReportingServices/Reports and the TargetServerURL is http://vpc001/ReportingServices. I can see all of these locations. When I try to deploy I get the Reporting Services Login window with the Server set to http://vpc001/ReportingServices . Thanks for your interest in helping me understand what is going on here. Regards, Michael Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
- Next
  - 1
    - Help with expression to display a per-week daterange value! Thanks for the help, it worked well. I had to add SUM(Fields!Rejections.Value) and SUM(Fields!Amount) to add the rejections and amounts up for each line per week, but in all, it did work! I bet you assumed I knew that, but I didn't, but I did figure it out. Now my issue is how do I make it so it shows all the weeks Refer to my goal example above. I was able to replicate Jarret's results, but I'd like it to show the missing weeks of 2,3,5,6 with 0 values. Keep in mind there are no data that falls into these weeks, I just want to display the weeks and show 0 as values for both rejections and amounts. What do i need to put into the expression to place so-called "dummy" weeks on the report Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 2
    - Trigger programming SQL 2005 vs SQL 2000 First, I would carefully examine and ask WHY a CURSOR is being used in a TRIGGER. In almost all situations, the use of a CURSOR in a TRIGGER is a very bad idea. It increases the lenght of the TRANSACTION, holding locks longer than necessary, increasing the chance of blocking behavior. Almost always, a CURSOR in a TRIGGER is the result of not understanding how to process SET based data. My recommendation: Post the entire TRIGGER code and the TABLE DDL. Folks here will help you determine if there is a more efficient method to accomplish the task. You will get excellent assistance to make your database operate more efficiently. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 3
    - Problems with Roles and sp_helpRoleMember This is a windows authenticated user. Based on previous posts in this forum, I've already looked at those 2 tables (principals and rolemembers). Indeed, the guy's principal ID never is added to the rolemembers table when I check off the role for that guy's login or use sp_addrole. Either I don't have permissions (which I do - Admin) or something is overriding this guy's role configuration. And why would he only see 1 from sp_helprolemembers and I see 20 Please help me make some sense on what's happening... (thanks for your reply Buck) Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 4
    - Join Using a substring function I already have a SQL script (SP) that works fine, however what I am trying to achieve is get rid of this SP/view concept and replace with SSIS packages/tasks/transformations. Thanks for helping. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 5
    - What's wrong? Whats the statement just before the IF statement Remember, @@ROWCOUNT gives you the number of rows affected by the last processed statement within the batch. Its good practice to always set the value of @@ROWCOUNT to a variable if you're going to use the value later on in a stored procedure. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 6
    - error 1155 message Can anyone help please, I'm trying to install post smile. www postsmile.com. I keep getting the error setup message. Unable to execute file code 1155 Shellexecute Ex failed. I haven't a clue what this means except it won't connect me to the site and I have paid for this and entered the code. I've altered my firewall to accept it in case it was this but still no luck.Is it a fault with the company or my computer Many thanks in advance. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 7
    - Running job error in schedule Dear rottengeek, I have found that there is no that check box saying show step details. Please advise if you have any further instructions. Regards, LG Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 8
    - Image insertion to ss2005 from Windows Mobile Hi , I am trynig to insert an image from the Windows mobile to the SQL database. Is it possible to perform this using RDA After some search in this forum , I got an impression that the only way to do this by storing the image in a local database and then do a merge replication. I do not want to do the merge replcation just fo rthis reason. Is it possible in RDA Debugging shows only some part of the data is getting updated. While trying to retrieve the image in a webpage error is poping up. My code is : string strbytes = ( Convert .ToBase64String(bytes)).ToString(); DbObj.GetSubmitSql( "Update Odrs set SignedBy ='" + txtSign.Text + "', Signature = Convert(Image,'" + bytes + "') where OrderId=" + orderNo + "" ); Please help.... Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 9
    - error hi thanx for reply now i m getting this error Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 10
    - Second opinion on how to build this cube Thank you for your reply. Please can you guide me on how to "get AS to perform the same functionality as the lookup" mentioned in your reply. Or do I need to perform this "lookup" functionality if I attached the "population" measure to the main "production" table cube and shared the dimensions in the "dimension usage" tab. I would think once I share the dimensions between the two measures, AS will automatically know where the "population" measure is associated with the dimensions. Thanks. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 11
    - Named Pipes Provider, error: 40 - Could not open a connection to SQL Server Nan, Before I get on with this post - thank you for your reply. The XPSP2 machine actually had the firewall disabled, and I verified that it could accept connections on the the associated ports with the Shields Up utility. I tested this on both machines. I can connect to the server from the XPSP2 machine, Import / Export, manage, view logs, and do everything EXCEPT get the Copy Database package to run. SQL Server Agent always fails on the last step with the following error: Event Type: Error Event Source: SQLISPackage Event Category: None Event ID: 12550 Date: 1/10/2006 Time: 1:34:15 PM User: NT AUTHORITY\SYSTEM Computer: 401SERVER Description: Event Name: OnError Message: Failed to connect to server BETHESDA. StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp) InnerException-->An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity) at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() Operator: NT AUTHORITY\SYSTEM Source Name: BETHESDA_401SERVER_Transfer Objects Task Source ID: {86F355AD-3B74-4D7B-8D2D-C743C790A269} Execution ID: {91B7C32C-C439-4EDB-8A0F-9F8BF207BC06} Start Time: 1/10/2006 1:34:15 PM End Time: 1/10/2006 1:34:15 PM Data Code: 0 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Have you (or anyone else) successfully executed a Copy Databse task Steve Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 12
    - SQL databases and SBS 2003 I have run into this issue repeatedly when installing applications on SBS 2003. The application needs a database and looks for one when installing. It sees the SQL 2000 databases pre-installed on SBS 2003 for monitoring and reporting and assumes it can use them. Ultimately the program grinds to a halt because these instances cannot be used for the application (I'm assuming). The program should install it's own instance of SQL . I end up spending quite a bit of time mending the installation by manually installing some "lite" version of SQL and piecing it to the application. Is there anyway to use the existing SBS 2003 SQL databases for a new app, like a backup program There is no SQL management software on SBS 2003, so how is that done Should I always install a new instance of SQL server for a new application I would love to see some official documentation on how to do this. Thanks! Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 13
    - MDX calculated measure Thanks Bryan, I will try something like you described above. Do you know if there is a way to get a value from a specific level in the hierarchy I can get the values I need but I have a problem to write the mdx question that will give me the percent value as answer. With one of these code samples I get the values that I want to divide in the calculated measure (They give the same result) 1. Code Snippet distinctcount ([Customer].[Customer]. members ) 2. Code Snippet COUNT ( CROSSJOIN ({[Measures].[Sales]}, {[Customer].[Customer]. members }), EXCLUDEEMPTY ) For example: Vendor1 10 Article1 8 Article2 5 Article3 10 Vendor2 26 vendor3 54 Vendor1 have a total of 10 customers and Article1 are sold to 8 of those customers, Article2 to 5 and Article3 are sold to all 10 of the customers. What I want to do is to have a calculated measure that divides Article1 value with Vendor1 value(8/10), Article2 value with Vendor1 value (5/10) and so on. The values are from the same code sample so Vendor1s value of 10 uses the same code as the Article1s value (distinctcount([Kund].[Kund]. members )) And Code Snippet distinctcount([Customer].[Customer]. members ) / distinctcount([Customer].[Customer]. members ) wont work of course I want to have a calculated measure that dont change when I drill down Vendor. Like: A B Vendor1 10 10 Article1 8 10 Article2 5 10 Article3 10 10 Vendor2 26 26 Vendor3 54 54 Then I just need to divide A / B*100 and I have the value that I need. If someone knows how to do this I would be very happy Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 14
    - SQL 2005 Pull Subscriber stuck "Uploading data changes to publisher" I haven't run the profiler yet, but all dependet objects are included in the publication. While doing some more testing, I realized that the two suspect subscribers have another symptom in common. A simple update query on a simple table with 10 rows took over a minute on both databases. I looked in the activity monitor and couldn't find any locks on the object. As soon as I stopped the merge agent at the subscriber, the query ran instantly! I started the agent back up, and again, the query took over a minute. Is my best option to just drop and recreate the subscriptions This is possible now, since we aren't in production yet and the amount of data being reintialized is small enough to replicate within a few hours. Should I drop and recreate the publisher and all subscribers I feel like it is best to start on a clean slate while I still can. Drew Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 15
    - How to export to a fixed width flat text file with row delimiters? To make this work so that each row is exactly the same length, you may need to add a zero length column as the last one in the connection manager, and set the row delimiter on that one. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
  - 16
    - Management Studio - Script Date Comments These auto generated by SMO Scripter Options. By default it only have the following options, IncludeHeaders IncludeIfNotExists DdlBodyOnly DdlHeaderOnly ExtendedProperties ScriptDrops I am not sure whether we can change these settings on Management Studio or not. But on SMO we can control all these. Tag: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005

vadoriu

Hello!

I'ave got a problem of setting more than one Variable in ReadOnlyVariables Property of ScriptComponent...I provide comma separated list of names ( As described in the help ) byt VS Studio Editor can not be opoened claiming that there is no a variablle with such a name...Looks like it doesn't treat the list as a collection of names...

Please help.

Vladimir

Re: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005

Phil Brammer

Make sure there are no spaces in the list.

Var1,Var2,Var3

This will not work:

Var1, Var2, Var3

Also note that variable names are case sensitive.

Re: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005

JayH

Triple-check your spelling and the scope your variables are defined in. I got the error just this morning and it was a spelling problem.

Re: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005

vadoriu

Thanks for your response...

I verified the spelling got rid of spaces...but result is the same

It is interesting thing.. I have only two variables: One is set on a package level and another is on the Data Flow Task level...

When I set one of them in ReadonlyVariables and another in ReadandWriteVariables it allows me to open VS for Applications. If I move both to the same location ( ReadonLy or ReadAnd Write with comma separation and no spaces ) it issues the message I described...

I tried specifying the namespaces for the variables, but with no Luck...

Not usre what to do...

Any ideas will be greately appreciated...

Thanks,

Vladimir

Re: How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005

Phil Brammer

What version of SSIS are you using

RTM SP1 SP2