Answer Questions

• Magnus Import conversion error caused by spaces???

  I am trying to import a fixed width file where some of the numeric columns are empty. The columns in question are defined as integer columns (of varying sizes) and I am guessing that "empty" columns come across as multiple spaces on the import. Even though I have "Retain null values from source" checked off, I am still receiving the following error on these empty columns: Error: 0xC02020A1 at Input Data, Flat File Source [1] ...Show All

• Jerryman DataRecordTypeToBufferType not declared

  When I try to use the DataRecordTypeToBufferType and ConvertBufferDataTypeToFitManaged helper functions in my SIS script it tells me they are not defined. According to the doc they are in the Microsoft.SqlServer.Dts.Pipeline namespace, which I have included and the reference is there. It has been a few years since I have worked with visual studio so I am a little rusty, can anyone tell me what I might be missing Thanks! Harry Harry, Thes ...Show All

• Todd Hobdey Connectivity from Non Sql Servers

  How would I configure a DB2, SAP Or Teradata as source in SSIS MS provides a OLE DB driver for DB2.  You can find it on the following page. http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en As far as SAP goes, that depends on the underlying DB.  If it runs on Oracle, then MS offers a OLE DB driver, or you can download ODP.Net fro ...Show All

• Mark Dorey Login failer to my DB using ASP.NET 2.0???

  Using Visual Studio 2005 Pro with the accompanying install of SQL Server Express.  I'm running a Visual C# GUI that reads from SQL Server a DB that I also need to be read from a ASP.NET 2.0 app that I'm running in IIS 5.1 my GUI has a user of 'TUDOR\Windows' and works perfectly but when I try to make a connection in my ASP.NET app I get a debug error (see below).  In the design view I can set the sqldatasource, bind it to a datagr ...Show All

• danprime SQL Sample?

  Hi! This concerns SQL errors showing up unexpectedly and a "Sample" application. I am running Windows XP Pro SP2 on a Dell 8600 Laptop. It is the only computer I own (or want to own) therefore, home networking not an option. A simple, stand alone computer is all I need or want, yet sometime around September or October '05 whenever I booted up, I was getting SQL error messages (e.g., missing SQLsvc file). While trying to find th ...Show All

• Alex202 DTExec is taking all my memory

  I have created a SSIS package that reads 500 text files splits them into 4 raw files then reads them again and writes then to 4 database tables different Tables. The reason form this is that my raw files have multiple types of records in them and it is only 1 Coolum. I split this out into the different types of records and load whole rows into the database. ie input 1 txt file <T6> 1:1000178 3:18148821-00 5:40204043 6:1 17:EX20 ...Show All

• martin_eifert Error Calling SQLCLR UDF

  Running SQL Dev Edition on Win2K3 Enterprise Edition. I get the following error. Msg 6522, Level 16, State 2, Line 2 A .NET Framework error occurred during execution of user defined routine or aggregate 'AddressCorrect': System.DllNotFoundException: Unable to load DLL 'D:\CorrectA.dll': Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008) System.DllNotFoundException: at UserDefinedFuncti ...Show All

• hatem elshenawy Any full-text gurus - Help writing a query

  I'm not sure how I can best phrase this, but I need help writing a query that is inflectional, thesaurus and non word ordered specific. In other words, say a user is looking for a "car wash" but types in "wash auto" or "auto wash" or "vehicle wash" or "cars washed" or "washing cars" or "car and auto wash" or "automobile car wash", etc.  I still want a result produced of the entry in the database "car wash", how can I produce this query ...Show All

• Kevin M. Owen Size Amount

  Can anyone tell me how much space the SQL Server 2005 actually has. And if I can access the server from pretty much any computer SQL Server 2005 Express Edition supports 4GB database size (note: there can be multiple databases of this size on a server). You can access SQL EXpress from other machine's as long as you configure remote connectivity - learn how to do this at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx . Tha ...Show All

• notamused XACT_ABORT

  What is the default value of XACT_ABORT  Assume I set it ON in a stored procedure named A, and other stored procedures has no explicit setting on it, what will happen on a client program that calls A and other stored procedures Here is the official definition: http://msdn.microsoft.com/library/en-us/tsqlref/ts_set-set_0rqs.asp Erland has some good info on this too. So, I suggest you'd want to take ...Show All

• ShunterAlhena parallel execution

  Hi I have 3 sources as Flat files and the destination is a single table. Is it possible for running a package so that it is executed parallelly. I mean , all the 3 files should run at the same time and load it into the destination table. If it is possible, please let me know how to do it Regards M Note that you'll need multiple processors to make this a worthwhile endeavor .  Also, if your files are very ...Show All

• Alex DeJarnatt - MSFT SQL Express and Templates

  In SQL Server Express, whenever I setup a Stored Procedure, a template appears, which is wonderful. Can these templates be modified (for example, additional information added) and if so, where is this documented Regards, Flavelle Mike: Bug reported as requested. thanks, Flavelle Hi Flavelle, Yes, you can modify template as well as delete them and create new ones. This is all ...Show All

• Floele connection strings for "create database" queries

  I'm using connection strings to SQL Server Express that have the form "DataSource= .\SQLEXPRESS;AttachDbFilename="(path to my development directory)\CurrentDevelopmentDB.mdf;Inte grated Security=True;Connect Timeout=30;User Instance=True" I'm assuming this works because the DB is already there, created "manually". How might I build a connection string for a SQLCommand for a "Create DataBase" query I'm confused ...Show All

• R Boyd intallation of "MSSQL 2000 virtual server" on Windows Server2003

  Hello, i am trying to install mssql 2000 virtual server for failover clustering on windows server 2003. i have downloaded the evalution edition for mssql 2000. "the problem i am facing during installation that when i start installation, the virtual server option is disabled for computer name (on what computer mssql server is to install, as i want to install it on virtual ip)." could you someone help in this matter, "h ...Show All

• Santhosh L V KPI - Sales Trend

  Hi, I am trying to create a Sales Trend KPI, where the value expression is last month sales (Identify last month based on current system date) and target expression is last month previous year sales amount times 1.04. Is there a way to accomplish this using MDX in KPI. Thanks, Ravi Thanks Matt. Identifying the lastest month of data is the trickiest part. O ...Show All