Answer Questions

• oldboy67 How to enable or disable a task programmatically using Script Task

  I have made one package which extracts data from the source does transformation and submits the data to destination. Subsequently it also updates the required control files. Now I want to add a functionality : If the package is executed again it should check the status of previous execution in control file if success mark all tasks disable and stop if failure mark all tasks at enable and start extracting data and continue furth ...Show All

• trishide Cannot create new SQL database file.

  Hello, I'm using MS Visual C# 2005 Express, but I can't create a new local database file in the "Add -> New Item" dialog. The Studio doesn't create the database, but shows a file not found message. Any ideas Hello, There are two instances listed in the SQL Configuration Manager. The first is labeled "SQL Server (SQLExpress)" and is running. The second one is "SQL Server Bro ...Show All

• foolish frost Reporting Services Access Issue

  Hi Iam using the following code. Sorry it has Looong. Iam trying to generate a report in PDF format, by using DataSet(filling using stored procedure ). Actually the below in running perfectly until it reaches "rs.render" line. Iam getting "Object reference not set" error object. This error is not coming in our environment. Iam getting only at the Client Environment. We are using windows XP, Sqlserver 2000 (with SP ...Show All

• Pat Backowski Re : Enabling / Disabling Data Flow Tasks

  Hello, I have created around 10 seperate packages for our application data load. Now I am planning to create a master package (or a wrapper package) which will execute all the 10 packages (thru execute package task). Then I have a job which executes the master package at a given date and time. Question : How can I enable / disable execution of each package within the master package depending upon a flag variable. The reason why I need ...Show All

• Renate Text manipulations with null string

  Hello, I generate some report with Reporting Services. I want to sort several columns dynamically by user. I set Interactive Sort checkbox and use some text functions like - "Fields!mydate.Value.Substring(6,4) & Fields!mydate.Value.Substring(3,2)". Everything is OK but in some cases there are null values in this field (mydate). I receive following error - "An error has occurred during report processing. (rsProcessingAbort ...Show All

• NuSoul BUG: SSIS imported package errors with 'Guid should contain 32 digits with 4 dashes'

  I have imported a package using SSIS into the Maintenance Plan folder from another server. It imports fine, but when i Modify the package then click save I get the following error : 'Guid should contain 32 digits with 4 dashes'. This has been reported on other forums without resolution. Pete Please see the following article for a possible solution: http://support.microsoft.com/kb/922651 ...Show All

• Aurelien Couderc Problem with subscriuptions (e-mail) and reports produced through the Report Builder

  I created a Data Source, a data source view and a report model through the Business Intelligense Studio. After this, I used Report Builder to create a report that will be used and customized by my customers. The problem is that this report cant be sent automatically by e-mail using the Subscriptions option provided by Report Manager. The Report Model was created through the Business Intelligense Studio, and has a fixed data source defined using ...Show All

• Avinash21191 GUID

  Hello, I'm working on a smart client app that has an offline sql express store and needs to work with several types of central databases (support for multiple products - ms sql, DB2 etc) While trying to put together some offline functionality that needs the user to create records on the offline sql express data store, we've run into the need of being able to uniquely identify records so replicating the data in the offline store back into t ...Show All

• Barry Smith How to pass parameter froon control flow to data flow

  Hi, All, I need to pass a parameter from control flow to data flow. The data flow will use this parameter to get data from a Oracle source. I have an Execute SQL task in control flow to assign value to the Parameter, next step is a data flow which will need take a parameter in the SQL statement to query the Oracle source, The SQL Looks like this: select * from ccst_acctsys_account where to_char(LAST_MODIFIED_DATE, 'YYYYMMDD') &g ...Show All

• spinone_owner Sept 64bit Enterprise CTP Client Tools issue

  When installing the Sept 64bit Enterprise CTP I get an error when it starts installing the Client Tools. The log contains the following: Fatal Exception caught while installing package: "10"         Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.   Source File Name: sqlchaining\sqlprereqpackagemutator.cpp Compiler Timestamp: Tue Aug 30 21:43:50 2005   &n ...Show All

• 3rato Custom Parameter Page with Report Manager

  Dear Everyone, Suffice it to say, almost everyone who seriously uses (relies) reporting services hates the postbacks that the report parameter section does. It literally runs all queries that populates the report parameters. This will just not do. We're thinking of creating a custom web page to either augment or replace the parameter section of the report. Our problem is that we dont know how to connect it to report manager in such a away ...Show All

• the_7thmatrix Shredding recordset object var in ForEach loop (problem)

  I have a package that starts by loading a recordset into an object variable. The recordset is then enumerated with a ForEach loop. The loop sets some string variables. Within the loop container I have a Script task that uses a MsgBox to show the results for testing purposes. The package uses checkpoint restart (if that matters ). The first time I run the package the 1st record is displayed in the MsgBox, then the 2nd, but then the loop is st ...Show All

• MarcoD Cannot connect to a named instance of SQL 2000 or 2005

  Hi, I am struggling connection to a named instance of SQL 2000 (SP4) from another machine but without any success. I get an error message saying that the server does not exist or access is denied .   The security configuration in this named instance is the same as the default instance (also 2000) and the remote machine can connect to it successfully.   I also configured the aliases in Client Network Utility in th ...Show All

• Timbo RDA Pull Error table

  My dev environment: VS2005, SQLServer Mobile, SQLServer 2005 server db, PPC windows app. Having a problem with pull. First pull works fine. I request an error table from the pull. When I need to repull, I drop the table, but if I try to programmatically delete the error table, I get the message that the table has restricted DDL operations allowed. Apparently Drop is not allowed. Sometimes dropping the main table deletes the error table, somet ...Show All

• arif_setiawan Server Registration

  TITLE: Microsoft SQL Server Management Studio Express ------------------------------ An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 41 - Cannot open a Shared Memory connection to a remote SQL server) (Microsoft SQL Server, ...Show All