Answer Questions

• Brian Donahue Problem with DTSX

  I am trying to execute an DTSX for Exporting data from SQL 2005 to Access Database. From SQL Wizard, the Export process is running fine.  When I tried to execute the same using an Stored Procedure (     XP_CMDShell 'dtexec /F E:\Shared\Export\Export_Fame_Entity.dtsx' ) it is getting executed for long time.. but never gets completed and thus, not giving any error also. Help required......... regards, Ravi K Mascon Global ...Show All

• C McGlothen Loooonnngggg delay in loading due to "pre-validation". Can it be turned OFF?

  During dev. I _know_ certain things are invalid. I don't need the validation, it just wastes a lot of time... You can set SSIS to be offline (SSIS Menu), or set the delay validation on the component. Both these mean you can't validate the component at design time. Perfect. Thanks! And thanks for not saying "RTFM"! (I have been reading but all it takes is one moment of lack of concentration and you miss some detail ...Show All

• minh bui How to add Drill down option in the Dataset ( + )

  Dear Friends, I have created a Dataset and displayed in the report. In the report, its showing as expanded values by default. There is no option for me to Collapse and Expand. If I create a Table with Report Wizard, I am getting the Collapse & Expand ( + ) option in the report. Is there anyway, I can add the Collapse / Expand in the Dataset kind of reports. Thanks. Warm Regards Rakin Singapore. ...Show All

• wayne62682 Wait for Recieve Fails to recieve message when called from .Net sqlClient

  I have been building out an application and Service Broker has been working great but I have this one nagging problem. There are some scenarios that involve users waiting for a response so I call a stored procedure that sends a message on a service and then waits for a responses on the conversation handle on which it sent the request. When I call the stored procedure from a query window inside management studio it works perfectly. When I call i ...Show All

• tbohon SQL Agent Hangs

  I have an SSIS .dtsx package that will run fine during debugging, however, when I run it as a job under the SQL Agent the job won't start. To be more specific, the Agent will load the package, ensure that it passes validation (which it does), then sit there without starting the rest of the package. The job will run under the "executing" status until I stop it manually. Does anyone have any idea why it might be doing this ...Show All

• Sumith Koshy SQL 2005 upgrade and 32bit/64bit mixed environment questions

  We are planning to upgrade our entire environment from SQL2000 to SQL2005 Standard and I have a couple questions: 1. If our developement servers are going to be running SQL2005 32bit and our production servers are going to be running SQL2005 64bit are there going to be any compatibility issues between them We will be transferring tables and objects back and forth between them on a regular basis and will also perform db restores on the 64bit ...Show All

• Ebnez HTTP Endpoint Can't Authenticate

  I have setup SQL 2005 Apr CTP on a Windows 2003 SP1 system and created an endpoint. I can access it just fine, logged in as any user with connect priviledges granted to them, but only on the computer that is running SQL 2005. If I try to access the endpoint from any other computer system in the same domain (I have tried several) it just keeps prompting me for login credentials over and over again. The endpoints are enabled and started. ...Show All

• JoeLLPark Is it possible to use T-SQL to create a user in Active Directory?

  Is it possible to use T-SQL to create a user in Active Directory Larry, A stored procedure is more along the lines of what I am looking for anyway. I have been going over some documentation regarding LDAP, ADSI, and System.DirectoryEntry information, but they all basically require that I write code using VB, C++, or C#. To further explain the purpose, My company is going to eventuallu migrate to an HRIS ...Show All

• lee_connell Sql server Express 2005 Advanced

  Have been trying to use an 'iif' statement as a simple expression within a computed column. I cannot get the server to accept the statement. Every variation of commas quotes, spaces within the iif statement produces the same result. The statement is very simple : iif(Mileage>0, Mileage*.40, 0). The column is of data type 'money' and mileage is a numeric field (within the same table of course) I'm in the process of adding data tables in ...Show All

• Tom U RS 2005 run on SQL Server 2000 Database?

  Our product currently works with Cystal Reports but we decided to enhance it so it works with another reporting platform (MS Reporting Services).   We are in the beginning stages of developement and trying to decide which version of RS (2000 or 2005 ) to build the reports and integrate our web UI with.  Most of our clients are using SQL Server 2000 for their database platform and we don't anticpate them upgradi ...Show All

• JRafe Replication for Full-Text Index

  I have built a Full-Text Index on a indexed view. I'd like to replicate this indexed view from a control database to a live database. What values should I specify for @type and @schema_option for the sp_addarticle sproc to ensure the Full-Text Index is still functional after it's replicated For now, I have set @type="indexed view logbased" and @schema_option=0x90000F3. Are these values correct Could anyone give me some advice on ...Show All

• GregV 64 Bit OLE vs. 32 Bit OLE

  I have a SSIS package that works on Windows Server 2003 32 Bit with SQL Server 2005 32 Bit when I move it to a Windows Server 2003 64 Bit (AMD) with SQL Server 2005 64 Bit it fails with error 80040154 on the connection to an Access 2000 database. The solution maybe Jet 4.0 SP8 however I can not find SP8 for Windows Server 2003 64 Bit AMD (I can find Jet 4.0 SP8 for Windows Server 2003 32 Bit, Windows Server 2003 64 Bit Itanium however). Ju ...Show All

• Jack3r Error on order by with union all

  Hello, I want to order by a field that is a code, like 1,2,3,11,12,13, and i get the following error "Only text pointers are allowed in work tables, never text, ntext, or image columns sql server" Why do i get this, what can i do to overcome this Thank you Do you need a UNION operator with or without ALL clause In other words, do you need to eliminate duplicates between the multiple SELECT statements If each SELECT ...Show All

• guzarva16 determine which version of CTP I am running?

  How do I know which version of the CTP I have I am currently running v9.00.1116.00... Thanks! Brian Brian Try this SQL command.. select @@version Thanks  Shaun    ...Show All

• Samuel Lester - MSFT DB2 ODBC Connection Problems

  Hello, I've recently run across a couple of problems trying to connect to DB2 using the .NET ODBC Provider. 1) I can create a DataSource using the DataSource designer, and when I edit the connection, the User Name and Password text boxes are empty.  If I fill in the correct information and hit "Test Connection", I am able to connect.  However, this information is not saved in the DataSource the next time I open it or try to run a ...Show All