Answer Questions

• Linda-De File Connector w/ Execute Package Task Expression Bug?

  Hi. We are trying to 'drive' the list of package to be executed by placing the package file names in an external datasource (a flat file). The idea being that the end user can modify the file to switch on / off the packages to execute or modify the order they are executed without having to use the Visual Studio IDE. We've gone about this by the following: 1)   Read the external datasource into a recordset using a dataflow task. 2)&n ...Show All

• Nishant Microsoft SQL Server 2005 Reporting Services -- Error 1303

  I am trying to install Microsoft SQL Server 2005 Reporting Services, Receiving the following error   Microsoft SQL Server 2005 Reporting Services -- Error 1303. The installer has insufficient privileges to access this directory: C:\Config.Msi.   The installation cannot continue.   Log on as administrator or contact your system administrator.     I am already logged in as Administrator and should have a ...Show All

• Christophe Kung Cannot Connect to SQLExpress

  Hi everyone, I'd like to ask some help. My prob may seem very basic but as a matter of fact i'm a newbie to .net and sql 2005. I'm trying out this product but I encountered an error. After installing sql server express 2005, and using my server instance name (the default name "SQlExpress" during install) and password to connect, I always get the error "Timeout expired. The timeout period elapsed prior to completion... blah blah blah". Thoug ...Show All

• Nallasivan Using another app to store reports

  Is it possible to write another application which stores reports itself and then gives them to reporting services to render (Or maybe reporting services knows to query this application for a list of reports, and then requests one). How would this application gain control of the reports after one is designed in report designer Would it have to be "deployed" to my application Thanks ...Show All

• Gary Bouchard System Configuration Check

  Hi all, when I try to install SQL Express 2005, it seems to install SQL Server Native Client & SQL Support Files OK, but at the end when I click next a window pops up labeled "System Configuration Check" with a message which reads "SQL Server Setup is scanning your computer's configuration" The problem is that the Configuration window doesnt seem to do anything after that, the Configuration window just stays there ...Show All

• Andrew "The statement did not return a result set" error on SPs with exec

  I'm trying to modify our application to use the SQL Server 2005 JDBC driver. After making the appropriate changes most stuff seems to work OK, except for any stored procedures that contain an exec statement and return a result set. When the stored procedure is called with executeQuery it throws a SQLServerException with the error "The statement did not return a result set". Other query SPs that don't have an exec work just fine. It doe ...Show All

• alok yadav Insert into Table with no values using the identity column

  Hello Everyone! SQL Question: Can you insert a record into a table that has an identity column with no values (on condition that the other fields in the table allow null or have default values). Such as: Insert into Table () values () //Auto increment record with no other values Possible Let me know if you need additional information. Yes:   INSERT Table DEFAULT VALUES -- Adam Machanic ...Show All

• twolfkg SQL Express uninstallation

  I am trying to uninstall SQL Express beta so I could install the latest version but unfortunately I cannot remove it. I tried going through my control panel but it wasn’t there, I tried using the uninstaller from Microsoft.com ( http://msdn.microsoft.com/vstudio/express/support/uninstall/ ) but it gave me error messages like saying …” The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is: F ...Show All

• AgusPac Directory and file names - case sensitivity

  I have a package variables that specify network paths and file names for input and output files. These have generally been working just fine for several months, however for reasons unknown, one level of a path name changed from all upper case to all lower case, and the package failed. I can probably get around this by using some script task/component to search for the correct name and update the package variable accordingly, but t ...Show All

• cowanm IBM Informix Ole Db Provider

  Hello, I'm getting the below errors when using sql server's data import wizard. Please Note: My test connection was successful and the error occurs when I click the "Next" button after closing the properties window. For Security reasons I've filled the User Id and DataSource with a bogus account, database, and server i.e. xxxx. Notice the password is blank ... Is that normal I'm in a jam and appreciate your help. Thanks, Mat ...Show All

• Brian Cordell "Too low memory" and XML in cache

  Hi, I've read that the parser can use 1/8th of the available memory for the xml-cache, but I've run into this limit much sooner than I'd expect. I'm not using "sp_xml_preparedocument", but rather operating on columns with XML as datatype. This means I don't have the handle to the document and can't use "sp_xml_removedocument" to free the memory. It's a simple application written in C#, so should it be sufficient to & ...Show All

• CsOtto Active Directory Groups Authenticate

  I've got a windows application that needs to authenticate to the active directory. But the only members of certain group can start the application. for example only the administrators of the active directory can start the application. Cheers, Mike Try posting this question on an Active Directory forum. Thanks Laurentiu ...Show All

• Slaxa Dynamic Filter Not Updating Correctly

  I have several SQL Mobile devices (WM5) syncronizing with a SQL 2005 database through merge replication. We are using the HOST_NAME parameter to filter several tables. A few of these filters use a sub-query to filter the data because of the complexity of the filter (need to do more than join to one table). The subquery will use the HOST_NAME parameter. For example, I want to get a list of all users in the current user's company I need to use hos ...Show All

• Brian Speck SQL Server 2005 Express Installation Problem: Incompatible components from beta version of .NET Framework

  Hi all, Yesterday, I just downloaded the SQL Server 2005 Express (SQLEXPR.EXE) and tried to install it in my Windows XP Pro PC that is on Microsoft NT 4 LAN System. I got the following error:                                          &n ...Show All

• Ach25572 Create Flat File source programatically

  I created a SSIS package, added Script task. created data flow task programatically, trying to add a flat file source component programatically. stuck at this point. my goal is to add flat file source component to the data flow task and insert into a table in sql server using oledb destination component all programatically. any help is appreciated. thanks. External columns are automatically ...Show All