Setting Field Description Property...
May 19, 2008
I'm selectively migrating a load of data from one database to another and would like to be able to get & set a table fields Description property (as seen on the Design window under Column Properties) programmatically. I'm having a spot of bother in actually finding how to do it - anyone know?
Ta,
Rob
P.S. Just thought I'd mention - I do know about sp_addextendedproperty, and while I will use that if I have to, it would be nice to be able to use the existing column property Description so that when editing, the user can see the value.
View 2 Replies
ADVERTISEMENT
Feb 2, 2008
I am trying to figure out how to set the Description of a Column in my database table by making a SQL function call. I know that I can go into Microsoft Studio Express and type in each desciption for each column. I just have about 1000 variables and each variable's description is in an Excel spreadsheet. I want to be able to build SQL code that will set each of the 1000 variables own description.
Thanks for any help.
Wesley Marshall
View 4 Replies
View Related
Jun 6, 2007
I would like to create table by T-SQLand need to specify DescriptionBut I can't find any sample to add Description property by T-SQL Additionally, I also would like modify Description property by T-SQL. What can I do ????? Please help me ......
View 2 Replies
View Related
Aug 24, 2006
I am adding two OLE DB Source components to my pipeline and giving them different names
(via the Sourcename variable) but like they are assuming default name and description i.e. OLE DB Source which is causing the following error message on opening the package that was generated.
The package contains two objects with the duplicate name of "component "OLE DB Source" (37)" and "component "OLE DB Source" (1)"
Here is how I am doing it, in the debugger the names in both instances seem to have set correctly based on the variable but when saved they are lost. What am I doing wrong here?
IDTSComponentMetaData90 source = dataFlowTask.ComponentMetaDataCollection.New();
source.Name = Sourcename;
source.ComponentClassID = "DTSAdapter.OleDbSource.1";
source.Description = Sourcename;
Thanks
View 1 Replies
View Related
Sep 30, 2004
Hi
Getting an error on the following SQL. The field in question is the Description field which has * in the description. Not sure how I should have the SQL to solve this
UPDATE Taylors
SET Area=::Area::,Avail=::Avail::,Address=::Address::,Type=::Type::,Price=::Price::,Bedrooms=::Bedrooms::,HotProps=::HotProps::,Office=::Office::,Description=::Description::
WHERE RefNo =::RefNo::
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* modern retirement flat * double bedroom * south lounge * fitted kitchen * good size bathroom * communal gardens * residence parking *'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
View 1 Replies
View Related
Oct 8, 2007
Hi,
I am using SSRS where I came across one text box what I want from it is..its string is "Employee Name" but I want that in format like "Employee Name"
What property i need to set for TextDecoration
Please help me
T.I.A
View 3 Replies
View Related
Feb 1, 2007
Hi,
How can I set the provider-specific property? Please let me know whether my code is correct.
For example, I want set provider-specific property set DBPROPSET_SQLSERVERDATASOURCE for memory based bulk copy operation. //Initialize the COM library.
...
//Obtain access to the SQL Native Client OLE DB provider.
hr = CoCreateInstance(...);
InitProperties[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
... InitProperties[1].dwPropertyID = DBPROP_INIT_CATALOG;
...
InitProperties[2].dwPropertyID = DBPROP_AUTH_INTEGRATED;
...
InitProperties[3].dwPropertyID = DBPROP_AUTH_PASSWORD;
...
rgInitPropSet[0].guidPropertySet = DBPROPSET_DBINIT;
rgInitPropSet[0].cProperties = 4;
rgInitPropSet[0].rgProperties = InitProperties;
hr = pIDBInitialize->QueryInterface(IID_IDBProperties,
(void **)&pIDBProperties);
hr = pIDBProperties->SetProperties(1, rgInitPropSet); pIDBProperties->Initialize();
// set provider-specific property
DBPROPSET DbPropSetFL[1];
DBPROP DbPropFL[1]; DbPropFL[0].dwPropertyID = SSPROP_ENABLEFASTLOAD;
DbPropFL[0].vValue.vt = VT_BOOL;
DbPropFL[0].vValue.boolVal = VARIANT_TRUE;
DbPropFL[0].dwOptions = DBPROPOPTIONS_REQUIRED;
DbPropFL[0].colid = DB_NULLID; DbPropSetFL[0].guidPropertySet = DBPROPSET_SQLSERVERDATASOURCE;
DbPropSetFL[0].cProperties = 1;
DbPropSetFL[0].rgProperties = DbPropFL; IDBProperties* pIDBPropertiesFL = NULL;
hr = pIDBInitialize->QueryInterface(IID_IDBProperties,(void **)&pIDBPropertiesFL);
hr = pIDBPropertiesFL->SetProperties(1, DbPropSetFL);
hr = pIDBPropertiesFL->Release();************************************************************
and,in SQL Server 2005 BOL,it mentioned
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.ko/dataacc9/html/6e14fefc-4e0b-4847-a833-4cf0abe65d50.htm)Description: To bulk copy,
SSPROP_ENABLEFASTLOAD property is set to VARIANT_TRUE.
With this property set on the data source,
the newly created session allows consumer access
to the IRowsetFastLoad interface.If the property is set to VARIANT_FALSE,
IRowsetFastLoad interface is available through
IOpenRowset::OpenRowset by requesting the
IID_IRowsetFastLoad interface
or by setting SSPROP_IRowsetFastLoad to VARIANT_TRUE.Are there any one who provide a sample of above red-mark's not blues?
View 1 Replies
View Related
Mar 20, 2001
On the Design Table screen for SQL 2000 there is a Description field along with the Default, Identity, etc. options. Once I put a description in there, is there a way to retrieve it through T-SQL?
Thank you!
View 2 Replies
View Related
Mar 20, 2001
On the Design Table screen for SQL 2000 there is a Description field along with the Default, Identity, etc. options. Once I put a description in there, is there a way to retrieve it through T-SQL?
Thank you!
View 1 Replies
View Related
Dec 1, 2005
I have a query in which I'd like to use the username of the user currently logged in. The expression im using to retrieve the username is: Membership.GetUser().UserName. Currently I have the following: <asp:SqlDataSource ID="ProjectSource" runat="server" ConnectionString="<%$ ConnectionStrings:Code %>" ProviderName="<%$ ConnectionStrings:Code.ProviderName %>" SelectCommand="Select Name, Namespace from Project where User = $Username"> <SelectParameters> <asp:Parameter DefaultValue="" Name="$Username" /> </SelectParameters> </asp:SqlDataSource> <asp:GridView ID="GridView1" runat="server" DataSourceID="ProjectSource" />I'd somehow like to set up $Username to be equivlent to Membership.GetUser().UserName.
View 2 Replies
View Related
May 16, 2006
Hi,
I want to set the language property of a report programatically. I get the language locale at runtime and once I get it, I need to go to all the reports which are published or still are on the local system (in rdl format) and set the language property on each of the reports.
Thanks,
View 6 Replies
View Related
Jan 12, 2007
I have SQL Server 2005 Epress and I want to get the field's dscription..
View 1 Replies
View Related
Apr 10, 2007
The Description field in SQL Server 2005 Reporting Services just defaults to "Send e-mail to email@domain.com" (obviously a dummy e-mail address) when you create an e-mail subscription. You cannot edit the Description when you select "Edit" beside a subscription.
The Description may be edited directly in the Subscriptions table under the ReportServer database but this is not end-user friendly.
I thought of using an add/update trigger to set the Description to the "Subject" out of the Extension Settings field. The Extension Settings field is XML so you would have to parse the Subject out of there first. The "Subject" is the e-mail Subject for the e-mail that is sent to the subscriber and it much more adequately describes the report.
My boss understood what I wanted to do but wanted to make sure in the industry literature that the product was not that lacking. Hard to believe that you cannot directly edit the Subscription Description through the web browser interface - would love for someone to prove me wrong.
View 5 Replies
View Related
Sep 19, 2006
Hi all,
I have been playing with integration services for a few days and at the moment, its up there with my list of software that I find ......painful.
What I am trying to do is read different tables from my one SQL database, then populate my Access database with its data.
I have put a foreach loop which goes through a collection SQL statements that I have entered into it. It first assigns it to a string variable called tablenameVar which contain statements such as "Select * from Terminals". Then the datareader is supposed to execute it based on the connectstring which never changes, and the SQLCommand value which I passed using the variable @[User::tableName]. However when I try to run it, I'm getting this error.
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [DTS.Pipeline]: "component "DataReader Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
Does anyone have an idea of what I should do? or maybe a better way to do it? I appreciate you guys for taking a time to look at this.
Thanks,
Joseph
View 1 Replies
View Related
May 19, 2015
I have a main package calling another package through the Execute Package task.
The main package is passing the Job Instance id as a parameter to the other package.
When i execute the Execute Package task the concerned package is not showing any execution progress.However when i set the Delay validation Property to True , I saw that the package executed instantly and the desired result was obtained.
I am not sure how the Delay Validation property worked for the cause , as in my package I had no scenario of a temp table being called or any other temporary variables being used which needed a Delay Validation.
View 7 Replies
View Related
Jun 1, 2006
I live in Brazil, and use SQL Server 2000 SP4 with Visual Basic 5.0 SP3, with connectivity to ODBC through RDO/ADO.
I have an example table with the following structure:
Table Name: Autioneer's (translated from Portuguese)
'Field 1/3
Name: Code
DataType: int
Description: Auctioneer's Code
'Field 2/3
Name: Name
DataType: nvarchar(50)
Description: Auctioneer's Name
'Field 3/3
Name: RegNum
DataType: nvarchar(20)
Description: Auctioneer's Registration Number
I need a way to programatically extract the Fields Description Property from the table
example sintaxe:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='AUCTIONEERS'
Thanks for any help that can be offered here
Neil Ramkeerat.
Replies can be sent to neilramkeerat@hotmail.com
View 3 Replies
View Related
Feb 12, 2007
I've got a CLR stored proc I'm trying to deploy to SQL2005, when I try to debug it I get the error message:
Method, property or field 'usp_Evaluate_eTranscript' of class 'ACS_eTranscripts.StoredProcedures' in assembly 'ACS_eTranscripts' is not static.
The class & procedure are declared:
Partial Public Class StoredProcedures Private Structure CalcGPA Friend intGrdTot As Integer Friend intCrsKnt As Integer End Structure <Microsoft.SqlServer.Server.SqlProcedure()> _ Public Sub usp_Evaluate_eTranscript(ByVal SSN As String)
When I change the sub's declaration to:
Static Sub usp_Evaluate_eTranscript(ByVal SSN As String)
I get an error message that:
Methods cannot be static.
So, is this a Catch 22 or what am I missing?
Any help would be greatly appreciated as this is a major project and I am woefully behind because of emergency surgery.
View 8 Replies
View Related
Jul 31, 2007
I have this Stored Procedure:
Create PROCEDURE ListEventas If MONTH(GetDate()) <= 6 Begin SELECT EventTitle, EventDuration, (CASE WHEN MONTH(StartDate) = 1 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Jan', (CASE WHEN MONTH(StartDate) = 2 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Feb', (CASE WHEN MONTH(StartDate) = 3 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Mar', (CASE WHEN MONTH(StartDate) = 4 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Apr', (CASE WHEN MONTH(StartDate) = 5 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'May', (CASE WHEN MONTH(StartDate) = 6 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Jun'FROM dbo.tblEvent INNER JOIN dbo.tbl ON (tblEvent.EventID = tblEventdate.EventID)WHERE YEAR(StartDate) = Year(GetDate())group by EventTitle, EventDuration,StartDate,EndDateEnd Else BeginSELECT EventTitle, EventDuration,(CASE WHEN MONTH(StartDate) = 7 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Jul', (CASE WHEN MONTH(StartDate) = 8 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Aug', (CASE WHEN MONTH(StartDate) = 9 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Sep', (CASE WHEN MONTH(StartDate) = 10 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Oct', (CASE WHEN MONTH(StartDate) = 11 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Nov', (CASE WHEN MONTH(StartDate) = 12 THEN Datename(Day,StartDate) + ' - ' + Datename(Day,EndDate) ELSE '' END) AS 'Dec'FROM dbo.tblEvent INNER JOIN dbo.tbl ON (tblEvent.EventID = tblEventdate.EventID)WHERE YEAR(StartDate) = Year(GetDate())group by EventTitle, EventDuration,StartDate,EndDateEnd
When I execute it in the SQLExpress, the result returned as expected. But when I bind to Gridview I got this error:
A field or property with the name 'Jan' was not found on the selected data source.
How do I solve this?
I am using drag and drop SQLDatasource to call the Stored Proc and VB.net is the language. Thanks
View 4 Replies
View Related
Jul 20, 2005
Hi,I am trying to convert string entered in a field to uppercase usingits formula property.I know it can be done using trigger but still I want to use formulaproperty to achieve the same.Any help will be greatly appreciated.-Max
View 3 Replies
View Related
Apr 1, 2008
How do i get the result 'puzzle' from the SQL and assign it to Integer and use it to compare with Request.Form ?
Protected Sub Page_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Me.Load
Dim connString As String = _ ConfigurationManager.ConnectionStrings("Local_LAConnectionString1").ConnectionString
Dim strsql As String = _
"Select CustomerID,CustomerNo,dbo.LA_DEC(Passkey) as passcode,dbo.LA_DEC(PuzzleKey) As puzzle, PuzzleFlag, NickName from Customers Where CustomerNo = '" & myAccount & "'"
Using myConnection As New SqlConnection(connString) Dim myCommand As New SqlCommand(strsql, myConnection)
myConnection.Open()
Dim PuzzleDataSet As New DataSet
Dim PuzzleAdapter As New SqlDataAdapter(myCommand) // <---- Coding here
myConnection.Close()
End Using
End Sub
View 7 Replies
View Related
Mar 3, 2007
I am totally confused, i have set my data type in the ID field for my database as VarChar (SQL Server Database)
I am confused a have it declared in ASP.NET 2 as a string but it doesnt recognise it when i try and insert the data into a database, what am I doing wrong?
Thanks
1 <%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
2
3 <script runat="server">
4
5 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
6
7 End Sub
8
9 </script>
10
11 <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
12 <span style="font-size: 11pt" id="SPAN1">
13 To initiate a new project, Enter details and
14 select <strong>Insert</strong>.
15 <br />
16 <br />
17 <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False" DataSourceID="SqlDataSource1" Height="50px" Width="324px" DefaultMode="Insert">
18 <Fields>
19 <asp:BoundField DataField="ProjectID" HeaderText="ProjectID" SortExpression="ProjectID" />
20 <asp:BoundField DataField="ProjectName" HeaderText="Project Name" SortExpression="ProjectName" />
21 <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
22 <asp:TemplateField HeaderText="Project Manager" SortExpression="ProjectManagersID">
23 <EditItemTemplate>
24 <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ProjectManagersID") %>'></asp:TextBox>
25 </EditItemTemplate>
26 <InsertItemTemplate>
27 <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="ProjMan" DataTextField="PMName"
28 DataValueField="ProjectManagersID" SelectedValue='<%# Bind("ProjectManagersID") %>'>
29 </asp:DropDownList><asp:SqlDataSource ID="ProjMan" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
30 DeleteCommand="DELETE FROM [ProjectManagers] WHERE [ProjectManagersID] = @ProjectManagersID"
31 InsertCommand="INSERT INTO [ProjectManagers] ([PMName]) VALUES (@PMName)" SelectCommand="SELECT [ProjectManagersID], [PMName] FROM [ProjectManagers]"
32 UpdateCommand="UPDATE [ProjectManagers] SET [PMName] = @PMName WHERE [ProjectManagersID] = @ProjectManagersID">
33 <DeleteParameters>
34 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
35 </DeleteParameters>
36 <UpdateParameters>
37 <asp:Parameter Name="PMName" Type="String" />
38 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
39 </UpdateParameters>
40 <InsertParameters>
41 <asp:Parameter Name="PMName" Type="String" />
42 </InsertParameters>
43 </asp:SqlDataSource>
44 </InsertItemTemplate>
45 <ItemTemplate>
46 <asp:Label ID="Label1" runat="server" Text='<%# Bind("ProjectManagersID") %>'></asp:Label>
47 </ItemTemplate>
48 </asp:TemplateField>
49 <asp:TemplateField HeaderText="Project Type" SortExpression="ProjectTypeID">
50 <EditItemTemplate>
51 <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ProjectTypeID") %>'></asp:TextBox>
52 </EditItemTemplate>
53 <InsertItemTemplate>
54 <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="ProjType" DataTextField="ProjectType"
55 DataValueField="ProjectTypeID" SelectedValue='<%# Bind("ProjectTypeID") %>'>
56 </asp:DropDownList><asp:SqlDataSource ID="ProjType" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
57 DeleteCommand="DELETE FROM [ProjectType] WHERE [ProjectTypeID] = @ProjectTypeID"
58 InsertCommand="INSERT INTO [ProjectType] ([ProjectTypeID], [ProjectType]) VALUES (@ProjectTypeID, @ProjectType)"
59 SelectCommand="SELECT * FROM [ProjectType]" UpdateCommand="UPDATE [ProjectType] SET [ProjectType] = @ProjectType WHERE [ProjectTypeID] = @ProjectTypeID">
60 <DeleteParameters>
61 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
62 </DeleteParameters>
63 <UpdateParameters>
64 <asp:Parameter Name="ProjectType" Type="String" />
65 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
66 </UpdateParameters>
67 <InsertParameters>
68 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
69 <asp:Parameter Name="ProjectType" Type="String" />
70 </InsertParameters>
71 </asp:SqlDataSource>
72 </InsertItemTemplate>
73 <ItemTemplate>
74 <asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectTypeID") %>'></asp:Label>
75 </ItemTemplate>
76 </asp:TemplateField>
77 <asp:BoundField DataField="StatusID" HeaderText="Status" insertvisible=False readonly=True SortExpression="StatusID" />
78 <asp:CommandField ShowInsertButton="True" ButtonType=Button />
79 </Fields>
80 </asp:DetailsView>
81 <br />
82 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
83 DeleteCommand="DELETE FROM [Project] WHERE [ProjectID] = @ProjectID" InsertCommand="INSERT INTO [Project] ([ProjectName], [Description], [ProjectManagersID], [ProjectTypeID], [StatusID]) VALUES (@ProjectName, @Description, @ProjectManagersID, @ProjectTypeID, @StatusID)"
84 SelectCommand="SELECT [ProjectID], [ProjectName], [Description], [ProjectManagersID], [ProjectTypeID], [StatusID] FROM [Project]"
85 UpdateCommand="UPDATE [Project] SET [ProjectName] = @ProjectName, [Description] = @Description, [ProjectManagersID] = @ProjectManagersID, [ProjectTypeID] = @ProjectTypeID, [StatusID] = @StatusID WHERE [ProjectID] = @ProjectID">
86 <DeleteParameters>
87 <asp:Parameter Name="ProjectID" Type="Int32" />
88 </DeleteParameters>
89 <UpdateParameters>
90 <asp:Parameter Name="ProjectName" Type="String" />
91 <asp:Parameter Name="Description" Type="String" />
92 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
93 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
94 <asp:Parameter Name="StatusID" Type="Int32" />
95 <asp:Parameter Name="ProjectID" Type="Int32" />
96 </UpdateParameters>
97 <InsertParameters>
98 <asp:Parameter Name="ProjectID" Type="String" />
99 <asp:Parameter Name="ProjectName" Type="String" />
100 <asp:Parameter Name="Description" Type="String" />
101 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
102 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
103 <asp:Parameter Name="StatusID" Type="Int32" DefaultValue=1 />
104 </InsertParameters>
105 </asp:SqlDataSource>
106 </span>
107 </asp:Content>
108
109
View 1 Replies
View Related
Mar 2, 2005
Hello!
I am using a Ms-Access DS which is accessed by a website's server-side scripts.
What I would like to do is set an existing record's date/time field to null. I have tried to simply alter its value by not including any data within the sharps (##), however that did not work.
How can I accomplish this?
Thank you!
Dave
View 2 Replies
View Related
Jun 16, 2006
I am having problems exporting data into a flat file using specific code page. My application has a variable "User::CodePage" that stores code page value (936, 950, 1252, etc) based on the data source. This variable is assigned to the CodePage property of desitnation file connection using Property expression.
But, when I execute the package, the CodePage property of the Destination file connection defaults to the initial value that was set for "User:CodePage" variable in design mode. I checked the value within the variable during runtime and it changes correctly for each data source. But, the property of the destinatin file connection doesn't change and results in an error.
[Flat File Destination [473]] Error: Data conversion failed. The data conversion for column "Column01" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[DTS.Pipeline] Error: The ProcessInput method on component "Flat File Destination" (473) failed with error code 0xC02020A0. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
If I manually update the variable with correct code page and re-run the ETL, everything works fine. Just that it doesn't work during run-time mode.
Can someone please help me resolve this.
Thanks much.
View 5 Replies
View Related
Oct 24, 2007
Hello,
I have a report which displays a customers invoice, in both the companys local currency, and the customers local currency.
The report language is "English (United Kingdom)"
The fields showing customers currency language setting is set to something else, i.e. "France (French)" to display the Euro currency.
The application handles 34 currencies, the query returns the language string, ("France (French)"), to allow the report to bind its language setting to the querys output.
However, it doesn't work, a normal textbox will display the correct country name string, but Reporting Services cannot bind the language setting to a query result. So I also tried setting it as a report parameter, but no joy either (all currencys revert to USD).
I'm using =First(Fields!curFormat.Value, "myDataSet") to bind the 'language' setting, the result of this expression returns "France (French)", which is a valid option for this language setting, as it's in the drop down list.
Rather than create 34 seperate reports for each currency, are there any suggestions on how to bind a fields language setting to a query result?
View 3 Replies
View Related
Apr 17, 2008
Hi,
I developed a simple custom control flow component which has several read/write properties and one readonly property (lets call it ROP) whichs Get method simple returns the value of a private variable (VAR as string). In the Execute method the VAR has a value assigened. When I put the value of ROP or VAR into MsgBox I can see the correct value. However when I execute the component I can not see the value of the ROP in the property window. I see the property but its value is empty string. For example when I put a breakpoint to postexecute or check the property before click OK in a MsgBox I would expect that the property value would be updated in SSIS as well. Is there a way how to display correct values of custom tasks properties in property window?
Thanks for any hints.
View 3 Replies
View Related
Feb 29, 2008
I am trying to get a function I created in VB 5 for Access and Excel to work in SQL 2005. I was able to update the old VB code to work in VB 2005. I compiled and made a .dll, and I was able to register the new Assembly in SQL Server. When I try to create the Function, I get an error:
CREATE FUNCTION dbo.Temperature(@FluidName char, @InpCode Char, @Units Char, @Prop1 varchar, @Prop2 varChar)
RETURNS VarChar
AS EXTERNAL NAME FluidProps.[FluidProps.FluidProperties.Fluids].Temperature
Error returned:
Msg 6573, Level 16, State 1, Procedure Temperature, Line 21
Method, property or field 'Temperature' of class 'FluidProps.FluidProperties.Fluids' in assembly 'FluidProps' is not static.
Here is the code (part of it) in the VB class:
Header:
Imports Microsoft.SqlServer.Server
Imports System.Data.SqlClient
Imports System.Runtime.InteropServices
Imports System.Security
Imports System.Security.Permissions
Namespace FluidProperties
'Option Strict Off
'Option Explicit On
Public Partial Class Fluids
Function:
Function Temperature(ByRef FluidName As Object, ByRef InpCode As Object, ByRef Units As Object, ByRef Prop1 As Object, Optional ByRef Prop2 As Object = Nothing) As Object
Call CalcProp(FluidName, InpCode, Units, Prop1, Prop2)
Temperature = ConvertUnits("-T", Units, T, 0)
End Function
If I change the Function Temperature to Static, I get an error that functions cannot be Static. Its been a long time since I created the code and am having a hard time in my older age of getting the cobwebs out to make it work.
I have no problem getting the function to work if I call it from a VB form....so what do I need to do to get it to work on data in my SQL server?
Thanks
Buck
View 20 Replies
View Related
May 7, 2008
Untill recently I had a smooth running SSIS package,but suddenly it throws error syaing
"OnError,,,,,,,The result of the expression
"@[User:trTextFileImpDirectory] +"SomeTextStringHere"+ @[User:trANTTextFileName] +(DT_STR,30,1252) @[User:taging_Date_Key]+ "SomeTextStringHere"
" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property."
I have child SSIS package running under a parent package (through execute package task)
I have few flat file connection managers in child package for text file import , in which I am building text file path dynamically at run time by assigning an expression in connection string property of connection manager.
The Expression is as follows
"@[User:trTextFileImpDirectory] +"SomeTextStringHere."+ @[User:trANTTextFileName] +(DT_STR,30,1252) @[User:taging_Date_Key]+ +"SomeTextStringHere"
Where @[User:trTextFileImpDirectory] is a variable which contains path of directory containg text
files.Value in this variable is assigned at runtime from parent package's variable,which in turns fetch
value from a configuration file on local server.
With my current configuration this path has been configured to some other server's directory over network ( I.e my package picks text files from some other servers folder over network)
While
"Some string here"+ @[User:trANTTextFileName]" part of file name string.
(DT_STR,30,1252) @[User:taging_Date_Key] Contain the date of processing ,value in this variable is also picked up at run time from parent package variable.
1) So can someone give me some insight into possible reason of failures.
2) Is it possible that problem arises if directory (from which I m picking text files) is assigned password or is there exist some problem in accessing forlders over network ?
3) Or there can be some problem in package configuration at design time( I.e where I m assigning value in variable from parent package vriables)?
View 10 Replies
View Related
Nov 6, 1998
Hi everyone,
I have a table which have several fields. I have a field that is made required by mistake. I would like to change this field to not require. Can someone help with the syntax?
Any help is greatly appreciate.
View 1 Replies
View Related
Feb 15, 2007
Hello,
I have a group I'll call G4.
The header table row for G4 contains 3 textboxes containing the sums of the contents within G4. The header table row for G4 is visible while it's contents, including the G4 footer table row, is kept invisible until the report user drills down into the group.
When the report user drills down into G4 the footer table row becomes visible and the sums of the contents of the group are displayed for a second time.
At this point I want the sums in the header to be set to invisible when the sums in the footer are made visible by the drilldown.
When I try to reference the hidden property of textbox66 in the G4 footer in order to set the hidden property of header textbox57 in the G4 header I get to this point...
=IIF(reportitems!textbox66.
When it fails to give me an option of choosing the .Hidden property and instead only gives me a .Value.
If I complete the IIF statement manually so that it spells out .....
=IIF(ReportItems!Textbox66.Hidden = False, True, False)
...the report chokes on it.
So my question is, how do I reference the hidden property of one or more textboxes in a group to use as condition checks to set the hidden property of another textbox in that same group?
Thank you for any help you can provide. We are only now beginning to implement reporting services and I have not yet had the chance to research this in greater detail for lack of time.
View 1 Replies
View Related
Nov 12, 2003
Hello,
How do I get SQL server to insert the current date on inserting a record in a field of datetime?
Thanks
Grant
View 2 Replies
View Related
Jul 27, 2005
Hi,I have a SQL that is working fine:
SELECT DISTINCT T1.ATCkod FROM ATC_tot T1 JOIN ATC_tot T2 ON T2.ATCkod = T1.ATCkod and T2.Typ_lakemedel LIKE '%' + @Kod2 + '%' JOIN ATC_tot T3 on T3.ATCkod = T1.ATCkod AND T3.Typ_lakemedel LIKE '%' + @Kod3 + '%' WHERE T1.Typ_lakemedel = @KodNow I need to have a description together with the ATCkod, tablename ATC columnname ATCdesc. ATC_tot.ATCkod = ATC.ATCkod. I have tried Inner join without success. Any good suggestions ...?
View 1 Replies
View Related
May 18, 2005
Hello, it seems I forgot how to do it,
I want to create a query to get the column description table, I mean get structure without data.
I remember it was select DESC or something like that, donno if im right!!!
regards
View 6 Replies
View Related
Mar 22, 2001
WHat does *= do in SQL syntax?
eg, SELECT * FROM Cars WHERE COLOR *= "Blue"
thanks,
Nick
View 1 Replies
View Related
