Answer Questions

• trogdor2323 Can We assign DataSet object to Object Type

  Hi Friends, I am having a Package scope variable DS of type system.object .In the Script Component which accept this variable as ReadWrite type I am Making the following assignment. Public Overrides Sub PostExecute() Variables.DsReport = DsReport // DsReport is a Data Set Object Created and Populated inside the script Component End Sub I am getting error while doing this sort of assignment. Please help me to solve this problem Regards, Mahe Which error do you get -Tom ...Show All

• vab SQL 2005 Sp2

  I would like to know the official release of SQL 2005 Sp2. Right now I can see SQL Server 2005 Service Pack 2 - Community Technology Preview (CTP) December 2006. You can expect the release of SQL Server 2005 SP2 in the next 30-60 days. Current plans is to ship in first Qtr. Thx Ajay Be patient, this is the last CTP, so it will not take long for the RTm version ;-) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• zu35926 unable to insert records in a mssql database with a access front end

  I have a database that is in mssql and I'm using an odbc link to an access database where I want to add records to the mssql table. When I open the linked table in access it does not allow me to add a record. I have created a user account in mssql that has ownership to the database and I use this user in setting up the odbc link. You may be violating a constraint such as a Primary Key. Use the osql command to perform an insert to the table to make sure it works. Try running the osql operating system command on the database server, replacing the database and table names, as well as the values you want to insert: osql -E -dMyDatabaseName -Q"INSERT INTO MyTableName VALUES('Value', 'Value') You can ...Show All

• Adrian Heath Connecting to SSAS on workgroup W2K3 server using SQL Server Management Studio...how?

  Hi All, I'm trying to connect to SSAS on a workgroup (i.e. non-AD) Windows 2003SP1 server from my XPSP2 PC, using SQL Server Management Studio and/or Visual Studio, with no luck. I have set up SSAS to accept anonymous connections, firewall is off, no anti-virus software, etc. I have added 'Everyone', 'NT Authority\ANONYMOUS LOGON' to the SSAS 'server' role (I don't care about security at this stage). I can connect to SSAS from my PC via code , though I have found out by trial-and-error that I need to specify a connection string that includes a User ID and Password; e.g.: "Data Source=sandbox; Provider=msolap; Initial Catalog=Analysis Services Tutorial;User ID =some_user; password= password ;" When I try to connect ...Show All

• Recency How to assign a column's value to another column's default

  I got a table. i m using SQL 2005. tblMy -------- col1 varchar(10) NotNull col2 varchar(10) AllowNulls col3 varchar(10) AllowNulls Question: How to assign the col1's value to col3's default value. If user enters a data to col3 , its ok , but if don't SQL will automatically insert the value of col1 to col3. Happy Coding.... View may be solution to another problem, but not mine. But trigger is a good idea, i thought before , but im inexprienced on triggers. I'll try to learn as quick as i can. Thanks for your post. Happy Coding...  I don't think a default constraint will work for this.  You could use a trigger though. Alteratively, you could mimic thi ...Show All

• Michael_P2234 Passing a schema to a cube via AMO

  I'm having a problem passing the Schema name to the cube when building it using AMO. Oh, i'm using SQL Server 2k5. When i build the cube through Dev Studio, it will process dimensions as expected. So, when pulling data, i can look at the SQL and see (for example): "Select blah from Schema.TableName" Which is what i want. However, when i build the cube using AMO i can not process the dimension, and it's failing because the SQL reads: "Select blah from TableName" A quick fix for me is to remove the Schema from my tables.. so, dbo.TableName works fine. But that's not exactly what i want. Or, i can create stored procs that pull the data from any table/schema, but that's not what i want either.. So, i guess i'm asking if th ...Show All

• eLado Backing up to a remote server

  I am just getting started with MS SQL and am having to learn from scratch. I have a DB running with an ISP which I need to back up to one of my local machines. I have installed MS SQL Server 2005 and also MS SQL Server Management Studio Express. Using this, I have opened a new DB on the local machine and then accessed the DB on the remote server. If I then right click on the remote DB file and select Tasks\Backup, I see the backup options screen. The problem is that the destination for the backup is automatically set to a folder on the remote server and I cannot figure out how to change this so that I can download to the local machine. If I click on the 'Add' button to create a new backup path, it will only offer me a view of the remote ma ...Show All

• Amos Soma Triggers

  I understand that triggers is not currently supported in this release, and that Microsoft may be considering supporting them in the future. Will the final release have support for triggers, or will this have to wait until the next major release Thanks Hi Ambrish I'm not quite sure if this is what you mean by notifications but this scenario is important for our application. In our experience interaction between .net code and a .sdf database is usually costly. In one particular test, by reducing the amount of calls to the database from 4 to 1, we where able to reduce time from 2.3 seconds to .680 seconds in our applications response time. With that being set, a trigger would greatly improve the amo ...Show All

• Phil026 SQLServer 2005 JDBC Driver - Date rendered correctly on local environment(windows), but not on Websphere server (unix)

  Hi, We are trying to move our application from SQL2005 to SQL2005, we are using 2005 jdbc driver 1.1. The problem we have is, when a date is retrieved from the database, only the year part got correctly, but the date is automatically set to January 1 of that year. The interesting thing is this problem doesn't occur on local development environment (developer's windows platform), it only happens when we deploy the application to production server (unix). Does anyone know what is going on, how to fix it Thanks. Cathie We are experiencing the same problem. We use IBM VM V1.4.2. The problem can be reproduced even in standalone applications, using DriverManager directly. The problem doesn't ...Show All

• AlucardHellSing Read CSV file - Save Columns into rows

  I want to import CSV file and convert columns into rows depending on Customer count(2nd record in each row of CSV file) and save to SQL table --CSV file format State, Customer_Count, Name_1, Total_1,Name_2, Total_2,Name_3, Total_3..can go upto 350 GA,2,'John Doe',14.00,'Roger Smith',15.00 FL,3,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00 SC,5,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00,'James Brown',17.00,'Rick Davis',18.00 Data in SQL table from csv file should look like this State,Name,Total GA,John Doe,14.00 GA,Roger Smith,15.00 FL,John Doe,14.00, FL,Roger Smith,15.00 FL,Sally Cox,16.00 I have multiple CSV files with millions of records. How can i achieve this using Integration Services or Bulk Data I ...Show All

• chadhowell SQLDependency Disconnects for Web application

  Hi, On my ASP.NET 2.0 application and SQL 2005 database server, i am using SQLDependency API to recieve notifications on the dataset changes from SQL 2005 server. I get the notification sucessfully (irrelevant of number of attempts). So here's the problem, i wait for 3-4 mins and make sure that there is no activity on my web server. Now if the data changes the service broker fires the event (i validated through trace). But the notification is never received by my web application. It gets lost in between. I read about this 'Abrupt client disconnects' problem in the article http://blogs.msdn.com/remusrusanu/archive/2006/06/17/635608.aspx but this didn't help much. Also i sometimes see following messages in the profiler <qnev:QNEv ...Show All

• Harri Pesonen SSIS in production

  We have developed a project with many SSIS packages. Now we are in a stage where we are deploying this into production. The operaitons team has asked us what are the things they need to known and do to make sure that the production system of SSIS keeps running. Can you help me in comming up with a detailed list which I can give to the operations/admin folks so that they can ensure that this project keeps running I would appriciate any help in this matter. regards, Abhishek. Well, will they be monitoring the error reports The list of things that I can think of would be: restarting the package upon failure job execution of the package (how to, when, how often, etc...) do they need to set ...Show All

• FloDEM Trying to get new Row ID on a Data Import and insert into another table

  I am new to SSIS, and was only a novice to intermediate skill level with SQL 2000 DTS, so please excuse me if this is an easy question. I am trying to import data from a table in one DB into a table in another. After insertion, I need to store the newly created ID (an identity seed) in a separate table that maps to the original DB's row id. My eventual goal is to import a bunch of related tables from the old DB into the new DB, and maintain relationships, so the mapping of newly created IDs is necessary to make sure data is imported with the correct relationships. Any advice would be greatly appreciated! So I would have to insert the newly created ID (allow identity insert), correct Similar to your sugge ...Show All

• davidy13 Problem on Sync Access database

  Dear all, I have a software written in C#, using RDA to sync access database from desktop. But it is tricky that some time during "Pull" data from SQL Server Agent, my PDA tell me "A request to send data to the computer running IIS has failed. For more information, see HRESULT". This also happening when I try to unplug the ethernet cable from my desktop however the push and pull actions did not required to go through internet. Here are part of my codes m_intdb = new SqlCeRemoteDataAccess("http://desk01:1024", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\inttemp.mdb; Jet OLEDB:System Database=C:\\Documents and Settings\\user\\Application Data\\Microsoft\\Access\\System.MDW"); m_intdb.Inte ...Show All

• chire SSIS and Replication

  We have two database servers in production running transactional replication. This weekend we tried to use SSIS to transfer the data from a table we have in our test server, to the table in production. We received an error along the lines of, could not truncate table'tablename' because the database is in replication. So I had to delete the publication, transfer the data, then re-do the replication from scratch. this was a pretty lengthy process. Is there a better solution itznfb wrote: We have two database servers in production running transactional replication. This weekend we tried to use SSIS to transfer the data from a table we have in our test server, to the table in production. We received a ...Show All