Answer Questions

• anwar100s Dynamic loading of a file

  I've been told by Kirk that it is possible to load a file whose metadata is unknown at design-time by using bulk insert along with a file (not a flat file) connection. He didn't elaborate though. Can anyone explain -Jamie How many different tables to you have Are you doing any transformation on the tables as you export them K "I don't know how one could load to a table with completely unknown metadata" Well that's exactly w ...Show All

• Fred.Thorel TraceLog warning

  I have an application which makes massively reportserver requests to get a pdf. in the trace log the following entry appears: [6080] w3wp!runningjobs!5!28.02.2006-11:23:57:: w WARN: Thread pool pressure. Using current thread for a work item. What exactly does it mean does it mean that there are too much requests at one time for the reportserver regards patrick We too are receiving t ...Show All

• Brandon Williams Format Date!!!

  I have the Date field in the report. How can I format that field to "dd-mmm-yy" (Ex: 01-12-05 will display 01-Dec-05 in the report) Where can I find the custom code pattern of field format Thks, Hi, try something like this =Day(Today) & "-" & MonthName(Month(Today),true) & "-" & Year(Today) if your format differs from any other standard date format. if n ...Show All

• romano My Client is in need of help!!!

  Hi!! I need urgent help for the scenario given below: "We need this code in order to automate migration of reports from one server to the other in our Flowfinity Actions product (e.g. from a developer's system over to a customer's system). We tried to write this code ourselves but we faced the following challenges: - we did not find a way to deloy a report based on a semantic model after moving this model over to the destination server. There s ...Show All

• tschuler77 Type 1 Dimension Insert/Update

  Hi I'm trying to put together a integration package that loads in type 1 dimensional data. If the item is new then the data is inserted if it already exists then it is overwritten. My approach has been to use the lookup operator to match the source values against a generic mappings table. The data that is matched goes off into the error flow and is inserted as new rows in the dimension table. The matched lookup rows are sent through into an u ...Show All

• -JW Error message setting up System DSN: Setup routines not found. Please reinstall driver.

  Hi, I'm running W2K3 SP1. The MDAC Configuration Checker reports MDAC 2.8 SP2. The only discrepancy is MSADCO.DLL, where the expected version is 2.82.1830.0 and my actual version is 2.82.2651.0 (svr03_sp1_gdr.060301-1546). The error message I'm getting when I use the ODBC Administrator dialog to set up a new entry is: "The setup routines for the SQL Server ODBC driver could not be found. Please reinstall the driver." This is f ...Show All

• Jennifer Huang DTS package failing with Object required WScript

  I have the following error when I try to execute a DTS package. All the package is doing, is a bit of WScript to map a drive (need it for other packages), so: [code] Function Main() Dim WshNetwork Set WshNetwork = WScript.CreateObject("WScript.Network") WshNetwork.RemoveNetworkDrive "S:" WshNetwork.MapNetworkDrive "S:", "\\myserver\folder1\folder2\folder3\folder4" Main = DTSTaskExecResult_S ...Show All

• Edward V. Wright read an xls file from a script task

  I'm trying to read an xcel file from within the script task of SSIS. I've seen posts that kind of steer me in the right direction, but none to do exactly what I'm looking for. I am loading data from flat files into a database where the source file has text longer than the target column. In order to get the text to "fit" i would like to apply a series of standard abbreviations, for example replace "DOCTOR" with "DR". ...Show All

• sfbolder Failed to generate a user instance of SQL Server

  Hi, I have visual basic team 2005 beta that come with sql server express, and i am trying to connect to a database on my local computer. And i get this message "Failed to generate a user instance of SQL Server due to a failure instarting the process for the user instance. The connection will be closed". If u ever heard of the Northwind database it is the one i am trying to use I don't know much about how to configure server, but i ...Show All

• imccaul Problem calling ws from sqlclr

  Hi all, I've got a stored procedure that calls a webservice, however when executed I keep getting the following error: A .NET Framework error occurred during execution of user defined routine or aggregate 'xxxxx': System.IO.FileNotFoundException: Could not load file or assembly 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Systemet finner ikke angitt fil. System.IO.FileNotFoundExcept ...Show All

• Bamboo WISH: Allow @vars as arguments to .nodes, .query, .value, etc.

  ... maybe this is already in the works Right now these functions only accept string literals. -- Chris SQL Server development team has received multiple requests for this feature and is considering implementing it for next versions of SQL Server (after 2005). Best regards, Eugene ...Show All

• Kokyu RDL and XML

  Reporting Services report definition language or rdl looks like XML. What are the differecnes Can RDL be used with Office 2003 i.e Word or Excel Regards J RDL is XML. XML is a standard and RDL files are specific XML files for Reporting Services. Word 2003 can read XML file in this own format so Word 2003 does not recongnize .RDL files. Please open the RDL file with NOTEPAD.EXE and open ...Show All

• cchan auto new line in same table

  Hi I have Table Like this In SQL server Code Name 1001 Bank 1002 Cash I need a   TRIGGER FOR INSERT , UPDATE , DELETE that ADD a new Row's in the same table  like this: Code Name 8001 Bank 9001 Bank 8002 Cash 8002 Cash In other mean for any row add to table by user that code start with 1xxx the trigger must inset to other row to that table whit code 8xxx & ...Show All

• Divac complex SQL (for me)

  Hello, Lets look at this table : CREATE TABLE [dbo].[TableHisto]( [Id] [int] NOT NULL, [Week] [nvarchar](50) COLLATE French_CI_AS NULL, [Project] [int] NOT NULL ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Identifiant d''enregistrement' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'TableHisto', @level2type=N'COLUMN', @level2name=N'Id' GO EXEC sys.sp_addextendedp ...Show All

• Slim 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