Answer Questions

• LanceT Package Configurations not so portable?

  I'm still struggling with finding a sound approach to creating configurations that are truly portable.  For instance if you use XML files to store configuration information, the path to the XML file that stores the configuration is baked into the package.  This would require the same file system structure on all machines that could host the package. Store in SQL server - one key thing that is valuable to configure is Data Sources - bu ...Show All

• JoeKYTse SSIS integration with Cruise Control

  Hi, Has anyone tried continuous integration with SSIS TIN, Anand Thanks Anand, interesting stuff. I haven't got experience of this however have experience of Agile Scrum which is another form of Extreme programming. On the specific subject of automated builds - I believe Visual Studio can assist with this. -Jamie What's continuous integration Jamie, Please visit this site for more information: h ...Show All

• FredKapsFan Writting multiple rows from one input Row

  Hi: I'm trying to write a transformation script to write multiple rows from 1 input row. In SQL Server 2000 DTS I could do this by using DTSTransformStat_SkipFetch and DTSTransformStat_SkipRow. In SQL server 2005 it looks like I need to use EndOfRowset but I do not know how to use it for sure. If this correct can someone show me a code example and if I am incorrect can someone tell me how to do this Thanks No problem. I ap ...Show All

• Andy Lambert Inconsistent package failures

  I'm debugging my first SSIS package and is getting inconsistent results. The package does not always complete successfully. When the package does fail, it fails at different tasks that accquire database connections. Any of the following error message would show up: [Execute SQL Task] Error: Failed to acquire connection "FORGE.FMC". Connection may not be configured correctly or you may not have the right permissions on this connectio ...Show All

• Deleter Enable User Instances in SQL Server

  I'm just starting out and trying to connect to my first database using the following string: Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True I get the following error during debug: " Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances ." I've done this on every database ...Show All

• iwanthtpc Table default value and data inserts using windows forms: It does not insert default value.

  I've created a table with a "Price" field (smallmoney). I set the default value for that field to be '1,99'. Then i create a Visual C# application, and add my table as a datasource, and drag it onto my form as a textbox. The problem is that if I leave the field empty, and Save - the value saved in DB is NULL. I would expect that since no value is given, it would insert the default value, which is 1,99. Are there any easy way t ...Show All

• Matt_Garven Cannot connect to "Reporting Services" using Microsoft Sql Server Management Studio.

  Hi, I installed latest SQL Server 2005 180 days trial version on my windows XP SP2 machine with the named instance "RS2005POC". I opened sql server management studio and selected Server Type = Reporting Services Server Name = localhost\RS2005POC Authentication = Windows Authentication. Connection failed with the following error message. Any help on this is much appreciated. Also I tried with "cjecw-h1708\RS2005POC" where cjecw-h1708(instead ...Show All

• Abhishek Pandey How to Configure DSN with DataReader Source

  Hi I am not able configure DSN in SSIS, I tired with DataReader Source but its given error " Check SQL Command Property" Appriciate to you for Help Hi Jamie I made one DSN which pointing Excel Driver, But when Create Connection Manager for these DSN by using ADO.NET Connection Manager. When i configure this connection manager in DataReader Source its give as error  "check SQL Command property" Here I am ot able to set SQL Commmand p ...Show All

• ts_nika SQL DataReader Mischief ! HELP !

  Why oh, Why is this happening.. Fastest winner gets a gold star ! hehe Just after i check the value of the data reader against the string in the IF statement, the code skips. If there is a record (=) to my varible everything is fine. However the IF ELSE will not work inside the While loop ! If i remove the record from the database and run the below code the IF statement skips (well skips the (Else)) and bombs out. Public Sub ...Show All

• Kanchi Harish Problem Connecting to SQL Express when 2005 Developer Edition installed

  Hi all, I have been writing applications in C# that use sql express databases as their data stores. These programs functioned correctly when they were written. I recently installed SQL Server 2005 Developer edition on the same machine. I had to uninstall the express edition before the installation would complete, and reinstall it afterwards. I can connect to and manage sql express with the management studio, but my applications cannot ...Show All

• DaveM61 SQL Server 2005 Conflict with Outlook BCM

  Hi, I just installed the SQL Server 2005 eval version on my laptop to try it out and now Outlook crashes. There appears to be a conflict with Outlook Business Contact Manager, which might be running its own database under the covers. When I try to start Outlook I get the error message "Business Contact Manager has encountered a problem and needs to close. We are sorry for the inconvenience". The button choices are Debug, Send Rep ...Show All

• Big Rob Configuration Manager - which configuration type to chose ?

  It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package. Is this the preferable way of doing it I would like to hear some positive/negative comment of why chosing a configuration type instead of another. It seems to me that putting all of the configuration in the Environment variab ...Show All

• SHMD Foreach Loop, Data Flow task buffer failed

  I have a package that runs fine by itself. But when I run it inside a Foreach Loop container on a parent package, I got a buffer error after a few loops. Here are a couple of the error lines: A buffer failed while allocating 49085616 bytes . The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E . I already played around with the Data Flow task’s DefaultBufferMaxRows and Defau ...Show All

• Keith Spitz How can I make a Matrix Transposition in SQL ?

  Can we do matrix transpose (rows become columns and columns become rows) in standard SQL 1 2 3 4 5 6 7 8 9 changes to 1 4 7 2 5 8 3 6 9 how about the situation when no of rows <> no of column let's consider the no of rows it's fixed and known before running the SQL statement. thanks. I kind of doubt that it would be that much simpler, and I don't even know about better performance (though that ...Show All

• needforhint Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless conn ...Show All