Answer Questions

• TheCurse Excel problem

  I am trying to import data from sql server to excel. it creates a new worksheet with name 'mytable' and excel file also has 3 sheets (by default as well). when package is executed, Data gets transferred first time. When I try to execute package again it gives me an error - that Table 'mytable' already exists. To solve this I added another task before it creates the table ('mytable' sheet in excel), where I drop this table with the statement " DR ...Show All

• Dave Jeffrey Microsoft OLE DB Provider for DB2

  The Microsoft OLE DB Provider for DB2 can be downloaded as a part of the SQL Server 2005 Feature Pack located at: http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en Thanks - it will be good to hear if anyone has comments on their experience with this provider. Donald OK, let us back up a little bit and follow a step-by-step approach. Please start to create a l ...Show All

• totocasagrandi how to confine a field to be number characters only?

  i have a field which is CHAR(20), and it is allowed to only containe number chars. is there any collation_name can help or how can i set the check clause well, the column is actually a one that is the IDs of customers, so i think it is conventionally to set it to CHAR. unfortunately for me, it is also conventionally that the IDs of customers containt only number characters, so the two convention contradict at this point ! after re ...Show All

• EkiA Problem with managed code simple example "Target string size is too small to represent the XML instance"

  I am trying to understand creating SQL Server projects and managed code. So I created a C# SQL Server Database project and named it " CSharpSqlServerProject1 " and followed the steps in the following "How to: " from the Help files: " How to: Create and Run a CLR SQL Server Stored Procedure " I used the exact code in this "How to: " for creating a SQL Server managed code stored procedure (see belo ...Show All

• Rik Merge Replication deployment model

  In order to deploy the replication implementation along with the software that has been created,how to package the correct set of necessary assemblies along with our client to ensure that the software can function correctly While trying to include the SQL Server assemblies that we are using from the SDK directory, we get some internal security token errors.  Please also suggest what would be the recommended deployment model for stand- ...Show All

• xp104904 Simple Database - What is Best Option?

  Hi, I am writing a simple program which runs on users xp machines and accesses a simple table on an NT Server. In otherwords, the database consists of just a single table with perhaps 4 fields and a maximum of 200 records, with low transaction activity (users periodically update their status or check on other users' statuses). Do I need to use SQL What is my best option for such a simple table / database. Your help would be appr ...Show All

• Charlie545587 for loop container to process all Excel files

     I'm having a problem getting the for loop container to process all excel files in a folder.  I set the collection folder to where my .xls files are, and i set a variable in the for loop container to the FileName.  I then changed my source connection and added expressions for ConnectionString: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=" +  @[User::ExtProperties] ( ...Show All

• Bullfrog LTM help file

  Sorry in advance if this is off topic...please advise In the past, I've used LTM (Local Test Manager) for testing a OLE DB providers conformance and had much success with it. The tool shipped in older versions of the MDAC SDK. I've obtained v 2.70 of LTM.EXE from the MSDN platform SDK but there is no online help (LTM.CHM) Anyone know where I can down load a copy Thanks Suroor, The MDAC SDK down ...Show All

• UB SQL Server 2005

  I have just recently downloaded and installed vs2004/ss2005.  So now I have the version of ss that comes with vs2005 and the developer edition of ss.  I have been able to work with  sqlexpress thru vs2005 but not with the developer edition.  When I engage the configuration manager which is what I guess to perform the same function as the enterprize manager in ss2000, I am unable to find my databases.  What am I miss ...Show All

• whitesqwal85 Dimension as Parameter in Reporting Services

  Hallo everyone: I am using reporting services and I am looking for a way to define a parameter “dimension”. The problem is that in Reporting services are available just the fields resulting from the mdx statement. Using the following statement I can use the fields “ value ” and “ Customer ” Select {[Measures].[ value ]} on 0, {[ Customer ].allmembers} on 1 From [Cube1] I could solve it lik ...Show All

• Ed Goings How to iterate over a recordset?

  Hi All, Many moons ago I wrote a blog entry ( http://blogs.conchango.com/jamiethomson/archive/2005/02/08/960.aspx ) about how to, in a script task, iterate over a recordset that is populated into a variable using the Recordset destination. My method there was to use ADODB.DLL but that's a bit "old school". Is there anything in System.Data to which I can cast the Object variable that will allow me to navigate the recordset stored withi ...Show All

• Carl Beck 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

• Christoffee Report Input Fields as Tree View Selectio (Hierarchy list box)

  Hi, I have the model built on top of the datamart. I have country, state, and city table. Presently I have 3 list box in the report filter, whee use can choose the city/state/country. My question: 1. I have 3 list box namely CountryList, StateList, and CityList. Now By default I populate the CountryList. But i want the StateList to be populated only after country is selected. Similarly the citylist should get populated once i choose the ...Show All

• Don Collins Converting a type into another one

  Hello, I've got two tables. An old one an a new one. Called "tbl_Filme" and "tbl_Filme2". The differents are that the data types are a little bit smaller as in the old one. So I've got a column wich should contains a datetime. Unfortunattley the datatype is just a normal date and not "smalldatetime" (the "tbl_Filme" was created with MS Access 2003). So I get an error message: 1> INSERT INTO tbl ...Show All

• Loic Baumann Table Variables in Stored Procedure

  I am using a table variable inside a stored procedure that I am trying to execute from an OLE Datasource task in IS.  I know there was a problem doing this in DTS, which would result in an Invalid Pointer error.  I am not getting that error, but I am getting an error that says "[OLE DB Source [55]] Error: A rowset based on the SQL command was not returned by the OLE DB provider."  The stored procedure runs fine on it's o ...Show All