Search results for query: *

SQL Server System Type: datetime Example Date: 2011-02-23 00:00:00.000 Microsoft Access Field Type: Date/Time Example Date: 23//02/2011 Thanks

Hello, I have a Microsoft Access database table that links to an SQL Server database table. I have created an access query that retrieves the fields from the table. For some particular records they are not being shown in the query. For example I have tested this on one particular record and it...

My aim is to retrieve a cookie that is being set server side so I ca use the value of the cookie as part of my validation process. The cookie is being set in an .inc file and is: Response.Cookies("sessionId") = sessionId; When I run my app I am expecting to get this cookie, I have tried what...

Thanks, I used the code from the link and t work but it again doesnt return what I expect 24/11/2009 19:50:37 MyCookie Cookie: ASP.NET_SessionId 24/11/2009 19:50:37 MyCookie Expires: 01/01/0001 00:00:00 24/11/2009 19:50:37 MyCookie Secure:False 24/11/2009 19:50:37 MyCookie loop2 cookie0...

Hello All, Using asp.net I am trying to retrieve a cookie that is being set manually on the IIS server when the page loads. However I cannot seem to get the value. When I use firefox debugger all the cookies are showing correctly, but when I use a CookieContainer to loop through all the...

Is there a command line function to stop the Report Services? Thanks

OK. As my datasource, in this case a web service cannot sort my data I have to do it after I retrieved it. This is how i populate my list (System.Web.UI.WebControls.ListItem) ListItem itm = new ListItem(); itm.Text = cnt.entityId; ddUserList.Items.Add(itm); My list would contain no more than...

Thanks for the advice but I am using a web service to get my data and unfortunately it does not have the capability to order the data which is why I need to do it from the drop down list. Is this possible from the code I posted? Thanks

Hello, I need to know how to order a list alphabetically in a drop down list ddUserList contains the contents of the list This is my html code: <label class="fixed-label" for="text1">Who are you? <span>*</span></label> <asp:DropDownList ID="ddUserList" runat="server" CssClass="select"...

Thanks, this sounds exactly what I need. I'm not that hot with c sharp and don't get everything in the example you gave. The MapFrom(node) is saying I have invalid arguments. It doesnt seem to like TypeId = int.parse(node.SelectNode("typeID").Value) Error:'int' does not contain a definition...

Hello, I have an .xml file that I am using as a configuration file and I want to read the data in the file and use the values in a condition in my logic. This is my xml file: <?xml version="1.0" encoding="utf-8" ?> - <caseSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"...

Hello All, I need some help with the following process - not sure where to start but this is what i have to do in my integration package: For each row in my tableA I want to update it with a string value (the value is derived from an SQL statement using a condition - WHERE clause). The...

I think I must have been looking at my dtsConfig file too hard and overlooked one of the properties! I updated the <ConfiguredValue>ServerName</ConfiguredValue> in dtsConfig to my new value and it works perfectly now. Thanks for your input.

OK, so now what i have done - amended the original package and amended the dtsconfig file which includes the test server data source and is correct. Built the package and created a job. The job runs with success in SQL Server Management but not in design mode - so what is restricting it from...

That's very interesting. I built may package and then created a job from the build and executed it from the jobs folder in MS SQL Server management Studio and the job completed without errors and updated the database which is good news. I'm a bit puzzled about the connection manager reverting...

Thanks for the info. I decided to keep the original connection in the package as the name of the connection is referenced in .dtsConfig files. So after doing I changed the server name in the actual connection. I did this from the data flow tab in the Connection Managers sections (MS Visual...

Yes, i created a new package from scratch and done a simple write to the database and it is fine so there is no problem connection to the actual server and database. However... i have a further problem making a connection to my test server. In my package I removed the original connection and...

Incidentally, I copied the SSID over from another server.

Hi, i am trying to create a new connection using connection manager for an SSID solution. However the server name does not appear in the Server name drop down list. I am configuring the package on my server and the database resides on the server that I am trying to connect to. I'm using SQL...

just what I needed, Thanks very much