Answer Questions

• mjpearce Data source column discovery at runtime? Help much appreciated

  Hi -- I am fairly new to SSIS development, although I am starting to appreciate it more an more, especially since I have started getting into extending the object model. Here's my question: I have a data flow that pulls data from any number of different delimited files with different numbers of columns. I have had no problem dealing with setting up run-time file locations and file names by using the expressions of a flat file data source, and ...Show All

• gharryh Lost connection with sqlexpress

  I installed on a w2k/sp4 local machine SQLEXPRESS. I copied the database also to the localmachine With the sqlexpressmanager I attached the database. Everythinks looks fine. I quit the manager, but then I start the manager again. Now the manager can't find the sqlserver. Timeout Expired is the message. Why is that I installed SQLEDXPRESS on a lot of machines. No problems. But those machine the manager lost the connection after the ...Show All

• Clark Anderson SQL Server 2005 Express Edition with Advanced Services

  Does SQL Server 2005 Express Edition with Advance Services comes with Reporting service. I mean to say If I have installed Express Edition in my computer, does seperate installation of Reporting service required. Hi there, I believe that the answer is "yes"....If you have installed only Express Edition you also need to get and install the "Advanced Services" download to get Reporting Services. Below is the blur ...Show All

• BigTuna99 Difficulty in creating Time Dimension - SSAS

  Hello all, I am familiar with Analysis Services 2000 in which creating a time dimension is very easy. In SSAS (2005) , i have a table in which there is field for DateTime which i want to use as time dimesion. In time dimension wizard , it asks for the column for year , month etc (which is created by default in AS 2000) . Since i have only one column having datetime datatype, how should i proceed by creating heirarchy (year,month , ...Show All

• jennifer.wu Why is this slow?

  The query is just... select name, max(date) from myTable group by name myTable had a clustered index PK, also non-clustered indexes on name and date. There are approx 1,000,000 rows and there are only 3 distinct names. This takes 10-15 secs to execute, even running directly on the server. Server trace says duration = 100, reads = 100 Profiler says CPU=20000, reads = 20000, duration = 10000 What on earth is going on ! ...Show All

• YoHackGrandDaddy SQLExpress ASP3.0 Permissions and Connectivity

  I'm teaching a class where the curriculum uses ASP 3.0, I thought it would be a good idea to introduce the students to VSNET 2005 web express as an editor and SQL2005 Express for a database. I'm having second thoughts since I can't seem to get ASP to successfully access the database (No problems with ASP.NET) OS: XP pro I've created the following in the Database: A simple database using managment studio ASQL login for the IUSR_ (a ...Show All

• Chuks What interface does Management Studio use?

  Hi, Does anyone know what interfaces Management Studio use It does seem to retrieve information about Server/Database objects without the performance issues that SMO suffers from How does it do it Regards, Joginder Nahil www.starprint2000.com This has a lot to do with smart defaults; http://www.sqljunkies.com/WebLog/mwories/archive/2004/10/22/4748.aspx Hi Simon, I have a product that prints the same information ...Show All

• Martin.Cruz SQL Authenfication

  Hi, i m trying to connect to msssql 2005 with SQL Authentication .but without success. "Server authentication is set to SQL Server and Windows Authentication mode". on connect i recive this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT:]" any help would be nice Luka I would guess your connectionstring might be ...Show All

• Nahar Need help on Combine both Avg() and Max function?

  Hi dear all, anyone can help me or guide me on how to use both avg and max function togather. or any other solution to solve my problem now i have a set of score, that is seperate into many day. so now i can get the average score for everyday. but now i also want to know which day is the highest score and min score. and sql not support max(avg(score)). so what should i do on it my table name is answer. i group it using the date colume. ...Show All

• Utsav Kedia XML Config files

  I am new to SSIS. I created a XML configuration file for my package. I found lots of data on how to do this but I can't find anything on how to get the values back out. I am trying to get them out in a Script file. Any help and maybe examples would be appreciated. Okay maybe I miss understood I thought you stored the values you want to use in the config file and the then you could use variables in your code to store them. I haven;t used c ...Show All

• Seiryuu SSMSE Cannot show requested dialog

  In Database Properties | Permissions when I highlight a "user or roles" and click "Effective Permissions" I get an error dialog as indicated below.  Given that this is beta software, is it a known bug, or is it something I'm doing John =================================== Cannot show requested dialog. =================================== Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\C ...Show All

• John Smallberries Connecting through ODBC

  Did anyone try fetching data from any database which is connected through ODBC. If so can you please share the details. In the data flow task of SSIS there is a facility for only oledb and not thru ODBC. From what I understand, ODBC was not implemented by MS in SSIS. See thread here ODBC works as a source but not a destination. An ODBC Destination was not implemented due to time ...Show All

• Cheval Pre-Execute AcquireConnection method call fails inside Sequence Container (transaction required)

  I've created an SSIS package that contains a Sequence Container with TransactionOption = Required. Within the container, there are a number of Execute Package Task components running in a serial fashion which are responsible for performing "Upserts" to dimension and fact tables on our production server. The destination db configuration is loaded into each of these packages using an XML configuration file. The structure of these "U ...Show All

• rvghst HELP: Failed to create the task. (Microsoft Visual Studio)

  I created my first SSIS project in BI Dev Studio but get the following error when trying to add a data flow task to the Control container: ================================== Failed to create the task. (Microsoft Visual Studio) =================================== Value does not fall within the expected range. (Microsoft.SqlServer.ManagedDTS) ------------------------------ Program Location:    at Microsoft.SqlServer.Dts.Runtime.Exec ...Show All

• Janny Regarding the System Tables

  Hi all, I would like to get the Database diagram for the System Tables and views. Where can I find it Thanks! Raju Check out this HTH ...Show All