Answer Questions

• Thomas At Work New undocumented property AlwaysUseDefaultCodepage?

  Diffing dtsx versions between June CTP and Release, I found (among other things) a new property in the dtsx in the release version: property id="79" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default"                                  isArray="false" description="Forces the use of the DefaultCodePage p ...Show All

• FrancoJS Suspect Mode (no visual cue in SSMS)

  When a database was in suspect mode in SQL 2000 E.M., the database turned grey and had (suspect) next to it. In SQL 2005 SSMS there is no visual indication as to when a database is in suspect mode. Is there a setting somewhere to emulate the previous behavior ...Show All

• ToxicSoul ON DELETE CASCADE problem for same table column constraint

  Hello,   I  would  like to have table with foreign key referencing to the column of the   same table. And I want to specify ON DELETE CASCADE to this column, e.g.:   create table category (    ID INTEGER IDENTITY(1,1) NOT NULL,    PARENT_ID INTEGER NULL,    NAME VARCHAR(100) NOT NULL,    CONSTRAINT CAT_PK PRIMARY KEY (ID),    CONSTRAINT CAT_FK FOREIGN KEY (PARENT_ID) ...Show All

• Rok Yu Table does not exist in Copy objects task

  I have a SQL2000 database that I need to copy tables from to my SQL2005 database. The table in the 2000 database are owned by a login named tsreader. This login is also in the dbo database role. So, when I access tables I have to prefix tha table name with tsreader. Currently in a SQL2000 database I have DTS packages that pull data over from this database everynight and they work fine. However when I try to do this from SSIS, I get the error &qu ...Show All

• Brett Blatchley Delete Duplicates in SQL2005

  I have a db working well in SQL2005, I import data into the various tables with no problem. In one of the tables, I don't want duplicates based on names in a name column. Where I have more than one instance of the same name, I want to delete the entire row, not just the name itself. Do I have to do the duplicate search and delete after the import   So what do I do once the data is in my table Do I write and execute a script that wi ...Show All

• Bill.Net Database tables etc vanishing?

  Hi I create a database in SQL Express using the Microsoft SQL Server Management Studio Express, with tables etc. I connect to it from my VB Express .NET application. Any changes I make, like adding a new table from VB .NET Express causes all the tables to 'vanish' when viewing the Database in the Microsoft SQL Server Management Studio Express, the database is still listed there. Does anyone know why Also it cannot be edited there again it ...Show All

• Laurentiu Cristofor How to manage different input (Excel files) format

  Hi all, I have created a package which import data from excel file and do some technical & business validation on the data. My package has about 20 control flow items. Now I'm asked to handle a second (and probably more in the future) excel file format (columns name are different, some fields are murged in one single column...). I definitely don't want to create a different package for each excel file format. But I can't find a way in ...Show All

• PRC Table is not visible till the last page!

  Hi, I have two tables on my report. The second table is not visible till on the last page! Help. Thanks. Can you be a bit more descriptive about your report design and what the problem is Perhaps paste in your RDL if it goes against a sample database like Northwind or AdventureWorks. Also let us know which renderer you're viewing the report in. Thanks, Donovan. ...Show All

• ks2006 Multi-column subreports

  We have not found a solution yet. I think it is just the way it works. If you look at a multi-column report in preview, it shows it as a single column, and only when you do a print preview does it show multiple columns. I assume its the same issue with subreports. Only the parent report can specify multiple columns. All page properties come from the parent report. ...Show All

• Oli is cool Access Last Identity Key

  Hi am going around in circles on this and can't figure it out ... I imagine the answer is simple. I have a data flow which results in the addition of a record to a table.This table has an identity key. I now wish to use this identity key to create records in other tables. So I am doing this in another data flow which follows the previous data flow in the control flow. So ... how do I access the new identity key and have that assigned to a column ...Show All

• Paul Hammond Replication to IP addressed server

  we have an outside company that replicates to us and we are known to them via an IP address.   We get an error now...Sql Server 2005 now does not support a server Alias, IP address, or any other alternate name are not supports.  Specify the actual Server Name I tried putting in the hosts file on their server 168.168.110.2       SQL2005 able to connect to our server through Studio Manager...no ...Show All

• HowardH Exec Stored Procedure

  Hi, Hope someone can help me out here - I'm trying to design a data flow in SSIS which relies in part on a stored procedure as a data source - I'm running it through OLE DB. Sure Exec MystoredProc works fine on preview and on parsing, but it refuses to acknowledge any of the columns, when I go to Edit-->Columns everything is blank. Just out of interest - the reason I am using a stored procedure is because I dump the data into a temp ...Show All

• amberlianne Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer

  Hi, I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer. Then when I try to delete it it gives this other error: Cannot remove the specified it ...Show All

• coloradovista DTS in a stored procedure

  Hi, I am kind of a beginer to sql so any input is appreciated. I am trying to create a store procedure that will execute a DTS package, which will use as a parameter the DTS's input source file (always an excel file). Can anyone help me pls. Thank you for your time. Sincerely, Execute a package from T-SQL ( http://www.sqldts.com/default.aspx 210 ) ...Show All

• Nothern XML Result Set expects FOR XML

  I am working on a generally applicable ETL package using SSIS for a large Swedish insurance company. The configuration is driven by XML stored in the database, which means frequently reading XML into variables and doing transformations on those. Although I have it working right now, it is not entirely as I intended. It seems that if I have declared a typed XML column and use the XML Result Set in an Execute SQL Task with the following ...Show All