Answer Questions

• Tryst SSIS Classes -- Recommendations (Brian Knight's classes are full)

  Anyone have a recommendation on SSIS classes (providers and instructors) It looks like Brian Knight's classes must be at the top of the list. His classes are always full! Probably the best SSIS classes are given by SoliQualityLearning. Look out for Erik Veerman as the tutor. He is a master and a class act!! He is the chief architect of Project Real. So nothing better than real world experience in SSIS. No, Brian, it's definitely your good looks. They're not looking down at you, they're looking down at your legs. :) Highly recommend Brian's classes. K If you're still looking, we just announced the Jacksonville class here and there are plenty of seats: http://whiteknighttechnology. ...Show All

• brian_tsim ssis developers

  where can i find pay rates or salaries for ssis developers thanks in advance. My company is working with an SSIS consultant and we are paying him $300/hour. Los Angeles, CA yosonu wrote: My company is working with an SSIS consultant and we are paying him $300/hour. in which city ...Show All

• sagittarian Execute SQL Task: Error

  I am running a Execute SQL Task which runs a script on a table. It gives me following error: [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow". Thanks, Your query in the execute sql task is returning more than one row. Pretty much just what the error states. If you don't need to return the results of the query to a variable, select "none" instead of "single row" in the ResultSet box. If you do in fact need to return more than one row into a variable, you'll need to select "Full Result Set." The variable you populate with single row needs to match (or be able to cast) the data type of the returned value. If you are ...Show All

• NagySaNa No. of User Accounts in SQL SERVER 2000 and SQL SERVER 2005 ..plz

  I want to know the maximum number of users that can be created in SQL SERVER 2005 and the previous version... Yorker: I am going to assume that you will hit the limitations of the "uid" field. This field is a SMALLINT datatype; however, it appears that groups begin @ 16384 and that this field must be non-negative. Therefore, it appears that a user database MIGHT be limited to 16384 distinct users. However, on a serverwide database you can have many databases therefore leading to at least N x 16384 distinct users. There does not look to be any "variable size" limitation on the LOGIN side because this is based now on SIDs whereas in much older versions of sql server it was formerly b ...Show All

• Chris Aus ReportViewer Toolbar

  Hi I have deployed my Reports using SQL Reporting Service 2005, but i use ASP.NET page using Report viewer to show the reports to the users. when viewing the report using Reportviewer i would like to customize the toolbar like the background color which comes in gray i would like to change to white. any dea Also i have multivalued parameter, i would like to have a<Select All option > inside on clicking it should select all the options in the list. Any possibility Look for the CSS files in the reporting services folder. They hold the configurable value for the GUI. The Select all (in common only (ALL) should be present if a multiselect value is used. HTH, Jens Suessmeyer. --- ...Show All

• Titou Need Assistance: Trying to run jobs and getting nowhere/SQLServerAgent

  I've gone through hundreds of posts here and on the Net. I'm creating an ssis package to access my db on my desktop. I then save a copy as "Test" on the msdb database on our sql 2005 box. Try to create a job and I'm getting nowhere. My SQL Server Agent account is a member of local Administrator group and a member of the domain. Now what I noticed is if I run the dtsexec from the command prompt and use the command line string then it works. Just seems like I'm not able to run anything from the SQL Server>>Jobs interface. Please Help :) I have it working with the set password but I'd like not to do this in case other developers create packages and then forget. I'd like to use the b ...Show All

• Rimey57 MDX Filter Problem

  Hi, I am using AS 2000 FoodMart 2000 DB . My problem is when I run the below query I am getting an error. Query 01 SELECT {[Measures].[Unit Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales] WHERE [Product].[All Products].[Drink] “ Duplicate dimension across (independent) axes when calculating a query axis ” But it is understood that I can use any other slicing dimension with WHERE clause to filter instead of the Product dimension, just like the below query: SELECT {[Measures].[Unit Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales] WHERE [Customers].[All Customers].[USA].[CA] This query works fine. My point is that I know AS 2000 does not use the same dimension in two ...Show All

• Jamie Thomson Doing the same replace on several columns?

  In the derived column task you can choose each column and write an expression for each column. But when you need to do a <ISNULL(status) "0" : statusdato> on 40-50 columns it get kind of irritating. Is there a way easy to do the sam expression on a selection of columns like a sort of derived column task, where you write an expression and assign that to a selection of columns (otherwise this would be a wish :-) ) Sorry, there is no such feature. Sounds like a good candidate to enter as a suggestion. Note: it would be possible to write code that programmatically does what you are looking for, by loading a package, finding the derived column transform, getting the input column collection, ...Show All

• NLebron SQL Server 2005 Express Toolkit & Reporting Services

  Hi, I had previously installed SQL Server 2005 Express edition (and later, SQl Server Management studio express). Recently, I wanted to try out 'Reporting services' and downloaded 'SQL server 2005 express Toolkit'. After installation, I have a new program group 'Visual studio 2005' . I started that with 'New Report Project'. I tried to attach an existing database (to be precise, in 'connection string' part) , but it is giving error saying 'An error has occured while establishing connection to Server. When connecting to SQL Server 2005 ( ) ,..... may be caused the fact that under default setting SQL Server does not allow remote connections ' I tried my existing SQL Server 2005 express edition Surface Area Configuration and it is configure ...Show All

• zion99 Files not creating on Win2003

  I have created a package which extracts data from a table and creates several files. This works fine on my PC (WinXP SP2), but when i deploy it to the server it doesn't work. I have also tried to create the package from scratch on the server as the administrator and it still has the same problem. Anyone have any ideas Sean, The package is deployed on a Windows 2003 Standard server, SQL Server 2005 Standard. I am writing the files to a directory on C:\ and have tried giving Everyone full control on the directory and still no files are created. Is there anywhere else i can check for the correct permissions Thanks You haven't provided a lot of information here, but the fi ...Show All

• Tej62007 Checking Job Status using T-SQL

  Hi. How can i check the job status using SQL Query Raja, I meant If the job (last execution/historical) executed successfully or not..From the above query.. KangKang, use RUN_Status column to find the status 1=Executed Successfuly 0=Failed with error When Failed you can find the details from the Message Column Look up using [sp_help_job] in Books Online. The problem with using sp_help_job in a batch is that you can't return the results to a table. This is because sp_help_job itself returns results to a table as part of its processing, and An INSERT EXEC statement cannot be nested. I guess I don't understand why you think sp_help_job is so complicated. Yo ...Show All

• vishnu_gawali SQL Server over Point-to-Point T1

  I'm running SQL Server 2005 on a Server 2003 machine serving both our home network as well as a remote site through a point-to-point T1. While file transfer speeds are up to par, the remote site's interaction with SQL Server (Point of sale system) is very slow. After testing I am certain that it has nothing to do with the actual physical machine in place neither is it an issue with the program itself since speeds are as they are supposed to be over the home network lan. It seems that there might be a packet size issue or something of the sort. Has anyone dealt with this before or have any thoughts Thanks, Peter How bad is the speed What is your configuration and connection string Do you keep connection open Do you have encryption ...Show All

• RaviKanthReddy Considerations when delete records from table.

  Hello, I'm developing application which monitors network packets. The monitoring data are saved into table. Monitoring table maintains the data for fixed quantum time,for example during one 1 hour. So, every minute before or after insert new data, I delete the time-expired data. I doubt that the endless delete operation would results in some problems(increasing index,etc..). Is this mechanism safe to the dbms Aren't there round-robin( ) style table thats wat OLTP is for.... just keep the update statistics to auto (its default) , if ur using indexes.....also there may be fragmentation issues ...but thats a DBA activity/Db maintainance... ...Show All

• Species2175 Error managing

  Hi everyone, When an error occured in a transaction and we can also create a message for this error ourself too by using @@error in order to print a message . However, I wonder that is it possible to really catch and handle the error For example, when error occured it makes the transaction terminated. So how can we prevent transaction from terminating Meanwhile, I also examine RAISERROR statement but it also does not prevent a transaction from terminating instead t only provide an additional message for the error. I think that I kept the idea about when to use and why to use RAISERROR statements and also return statement in Stored Procedures. When we need to cre ...Show All

• Philipp Lamp variable value not changing as expected

  I have an Execute SQL Task that selects one column value from one row, so General > ResultSet = Single row. Result Set > Result Name = 0 (the first selected value) and Variable Name = User::objectTypeNbr. The task runs successfully, but after the it runs the value of User::objectTypeNbr is not changed. User::objectTypeNbr > Data Type = Int32. When I declared the variable Value could not be empty so I set it to 0 arbitraily, assuming it would be overwritten when assigned a new value by the Execute SQL Task, but it remains 0 after the task runs. What am I missing here mruniqueid wrote: Great - debug shows it's the proper value at runtime. I thought / hoped it would retain its value at d ...Show All