Answer Questions

• Ewan Fraser SSIS Tutorial Lesson 5

  After I complete the SSIS Tutorial Lesson 5 and try to run the package, I found there's no any rows inserted into the error output file. I'm sure that I'd followed all the procedures. Anybody help Hey there, I was having the same problem and found this (hope it helps) http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=360470&SiteID=1 Cheers! ...Show All

• SHakeelGhauri77 What's the difference between "roles" and "users"?

  Hi, all. I've got a question that's truly newbie. I've added logins to the "users" of a database, but I've never used the "roles" area. What's the difference Is a role like a group account with some preset permissions We've got a user who needs read-only access to a database and I wasn't sure which way to add her -- to the users or to the roles, or both. Thanks. There are two types of roles: fixed roles that c ...Show All

• David Gustafson How to reference different databases on different servers in one query

    Using linked servers (first create it using te linked server procedures for that) you can issue this query: SELECT * FROM [Linkedservername].[ku.univ].dbo.Courses HTH, Jens Suessmeyer, --- http://www.sqlserver2005.de --- Take a look in Books On Line at a topic called Linked Servers. Although I am not 100% sure that they are supported in Express I think I'm not ...Show All

• Aleksandar Hajdukovi? Unable to connect to Analysis Services as a client

  Hi, I got SQL SERVER 2005 SP1 installed on a server and is running fine. I've installed BI studio on a client computer and I can access the database engine. On the client computer, while deloying my cube I get the following error : the project could not be deployed on the server "server_name\instance_name" due to connectivity problems. Verify that the server is running I've checked the project properties and in the deployment section ...Show All

• Preston Bostrom "...conversion between types DT_I1 and DT_I2 is not supported"

  I created a simple ragged file with 3 lines: 1 2 3 and coupled it to a Flat File Source. The Flat File Source suggested that the type was DT-I1. Next I created a “SQL Server Destination task and connected the output of the Flat File to the Sql Destination. In the Destination editor I created a table, whose one column was declared to be a sql smallint. Here’s the problem: the Sql Server Destination now disp ...Show All

• Ken H Accessing Mobile SQL Databases in VB2005 - Windows Apps

  I have both used the Data Connection Wizard and tried programatically to connect to a Mobile SQL Database from within a Windows Application and keep on getting the same Error at the connection point "Unspecified error [ sqlcese30.sys.dll ]" The Debug message is " A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll" I have added a reference to C:\ Program files\Microsoft Visual Studio ...Show All

• Ali Adnan High CPU Usage SSIS Package

  Anyone aware of anything I can look at to improve performance of my SSIS packages i basically have two master packages that call about 15 child package tasks each. All the package tasks are called sequentially and all they do is just load flat files into temporary tables and execute a simple stored proc. Each package tasks check to see if a file is there and if so it processes it else it just ends. The packages are scheduled to run every minute ...Show All

• Rizwanrs Data processing extension - ODBC problem - GetOrdinal

  Hello, I'm trying to develop new data extension for connection to Informix database. Reason is simple. Standard ODBC interface is locking rows in database, so I'd like to avoid it. And second problem with Informix is in date - specially DBNull value. It's presented as a "1/1/1" not as a null. So problem for me. I read the sample extension - File Share Data Processing - and started. My goal was completely simulate ODBC extension with sm ...Show All

• Mongrel Merge Replication and Unique contraints

  Hi, I have a slight problem which I'm sure must be a common happening. Here's my problem. I'm using Merge replication and I have a table the has a unique contraint on a non primary key column (the column is called [name]). The thing that goes wrong (for me) is that when a new record is added in a subscriber and a new record is added in the publisher before a synchronization and both records have the same [name] value then when the merge ag ...Show All

• PeterS878 Running Parametrized report From VB.NET

  Hi, I an new to SQL Server reporting Services. I have deployed my report on win2k server and is working perfectly when run from report server. Now I want to run that report from my Win2000 client Using VB.NET. Can any one have an idea how it will be done. I have no idea how to run that report from my win2k client and passing parameters from VB.NET programe to report on win2k server. ANy sample code will be very helpfull Thank you in ...Show All

• A Barber Encryption and database restore

  Hi Can anyone help I have a database using encryption with symmetric keys created using asymmetric keys. I backed up this database and restored it on another machine along with the service master key. I can read the encrypted data fine. But all the encrypted stored procs that are associated with the application that uses the data cannot read the data, they just return Nulls. If I regenerate all the encrypted stored procs from scri ...Show All

• Goshawk ExecuteSQL task has changed

  Since the last IDW. The column "ParameterName" has been added to the ParameterMapping tab of the ExecuteSQL task. I enter a statement of SELECT * FROM TABLE WHERE COLUMN = I map to a input variable.  The default name of the parameter supplied is "NewParameterName" My task now fails with Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "SELECT *  FROM  TheBigOne WHERE HostName = " failed with the ...Show All

• DingW Backup databases programatically.

  Hello 1. Sql Express supports SMO 2. If so How can I make a backup of a database programatically Thanks You do know that you can overload the Server instantiation to direct it to the server you want to connect to, don't you Example: Dim srv As Server srv = New Server("MyLapTop\Express") In VB.Net you can also set the property in the ServerConnection object: Dim srv As Server Dim srvConn As ServerConnection srv ...Show All

• Joe the Owl Updates to Live Web Server

  I'm developing a web app using ASP.NET and SQL Server 2005 Express. So far it's all been on my local computer, it hasn't gone live yet, so if I need to add a column to a table or make some other schema change I just do it right in Visual Studio, nice and simple. If I have to delete all the old content and start over, no problem. When I deploy it to a staging server I just overwrite the existing file with my new one, losing its data in the proces ...Show All

• B?R?K?M MEKAN?K SQL DTS Packages Data Transform Task

  Hello, I am working on a module to extract data from a Teradata server to SQL database. I am using a DTS package to extract the data and need to make the data source name (database name and object name) configurable at runtime and to be read from a Config table in the SQL database. What do you suggest is the simplest and most efficient method to do this I am trying to use a dynamic SQL query in the data tranform task with the data source as ...Show All