Answer Questions

• Sam_res03 import flat file

  I am trying to import a flat file using SQL Server Management Studio and am receiveing the error: Error 0xc0202055: Data Flow Task: The column delimiter for column "Column 19" was not found. (SQL Server Import and Export Wizard) I would like to capture the rows that are causing the error and have the import continue. Am I able to edit the behavior somehow Thanks. When you double click on the flat file source, there is a button, "error output" or something like that. Well, I read that you can 'use the Error Output Page of the Flat File Source Editor dialog box to select error-handling options'. How do I do this Thanks. Thanks Phil. I was ...Show All

• nick865 ODBC Driver for SQLServer Everywhere/Compact from Access

  So far I've been unable to connect to a test SQLServer Everywhere/Compact database with MS Access. I installed the new SQLServer 2005 Native Client to no avail. Has anyone done this If you read the last post I made, it's pretty clear that I have Compact Edition 3.1 RC1 Beta. I haven't ever installed the Mobile Edition. After installing CE, most references (like the installation directory) reflect the previous name (Everywhere). I really want to link to a Compact Edition database through ODBC (as it happens, in Access). I can connect to it fine in VS 2005 VB.NET, so I don't think it's a lack of understanding. Thanks, any help will be appreciated. You can only c ...Show All

• mfdiqwer Saved SQL Queries

  Can someone help me. In SQL Server 2005, when I save a query, and re-open it later, it always opens in the .master database. We do not use this database regularly, and I have to switch the database to the one that we use 95% of the time. Is there anyway to change the default database that opens, when I open these saved files for a given connection Thanks in advance for your help, Wayne Thanks for the answer. You will have to include a USE statement within your database script to make the change. EVen the user defaultdb will not affect the connect to the master database. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• AIMDBA Issues with removing replication

  SQL Server 2005 Standard replicating to an identical server. My issue: When we go into the database to remove a large number of rows, it says we are unable to delete since the database is in replication. Is there a way to pause, or stop replication temporarily I stopped the log reader but it still gave me the same error. The only way I have found around this is to delete the publication and re-create it when I'm ready. Now though, I'm unable to delete the publication. SQL Server Management Studio will freeze if I either try to delete something from the UI or command line. This happens with objects in SQL Server as well as rows and such. It will just freeze and I have to kill the process. Please Help! ...Show All

• comwizz2 Package not picking up latest Config File changes

  Hi, I've created a solution with 5 packages in. I've scripted a config file for each package where I would be able to change the source file connection and the database servers (source and destination). On the first package, I am able to change the config attributes and the affects are picked up, but the rest of the packages do no pick up the changes. For example, if the source file is "C:\Files\source.txt" and this is changed to "C:\Files\source123.txt" (Just to make sure it fails) it wont pick up the new changes and still uses "C:\Files\source.txt". Also, I tried changing the name of config file itself and the package still ran as if nothing had changed. It's as if it's not recognising the config fi ...Show All

• Polity4h Newbie - sa password error after ACT! install - Need pro's help!!!

  Hello, I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated! If SS2 ...Show All

• Terry Smith SQL Server Caching

  In a test app, I've noticed (by logging the times to execute) that it appears SQL Server 2005 is caching the results of queries (no client-side caching is being used). Some questions if I may... Is it possible to know how long/how many queries will be cached Is setting such caching a database setting Can longer-term caching priorities be set by configuration Is it possible send a command to the database (on startup) to preload the cache with certain data Thanks! Just to remember. On sql server 2005, DBCC PINTABLE doesn’t work. It’s only there for compatiblity... it’s some sort of placebo, it’s there but doesn’t works ;) best regards. Andy, What you are observing ...Show All

• Beetle54 round up

  X is a float and I need to perform x/10 and round the result up to the integer. So if result is 0.4 -> 1, if 1.1 -> 2. How can I do this with SQL Not really, OP wanted 2 for 1.1 round gives 1 Denis the SQL Menace http://sqlservercode.blogspot.com/ Use the CIELING function:   SELECT CIELING(x/10) FROM YourTable   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < JIM.H.@discussions.microsoft.com > wrote in message news:4165a8e6-3d64-4db1-9c4b-1cec7040f35a@discussions.microsoft.com ... X is a float and I need to perf ...Show All

• Marcus J Nesting stored procedure, how to ?

  Hello, I'm trying to use nested stored procedure but can't get it to work. I've created a stored procedure named 'sousmenu1_parents' which does a simple select, no parameter. here's what I'm trying to achieve now : CREATE PROCEDURE SelectAllDroitSpe -- Add the parameters for the stored procedure here @UserId int AS EXEC sousmenu1_parents ; BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert statements for procedure here SELECT sousmenu1_parents . menu_id1 AS sousmenu1_id FROM authorisations_speciales LEFT JOIN sousmenu1_parents ON authorisations_speciales . page_id = sousmenu1_parent ...Show All

• THNQDigital Bug?

  When I have two connection managers in the DFT and OLEDB source and destination component. Associating the different conneciton managers to source and destination seem to go through fine with the code below, but the package generated does not have the connection manager associated with the destination. I get this error on the destionation on opening up the package in the designer. <Error> A connection Manager has not been assigned to the runtime connection (24) </Error> SourceOrDestinationComponent.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert .ToConnectionManager90(pkg.Connections[ConnMgrName]); However when I assign the ID using the code below it seem to work fine. The documentation do ...Show All

• AlexBB The OLE DB provider "MSDASQL" has not been registered.

  I'm trying to set up replication on SQL Server 2005 (64-bit) and I am getting this error message when the replication kicks off. 'The OLE DB provider "MSDASQL" has not been registered.' When I try and register the MSDASQL I get the folloing error message. 'LoadLibrary("c:\program files\Common Files\System\ole db\MSDASQL.dll") failed - the specified module could not be found. Hi, Currently there's no 64-bit version of the MSDASQL Provider, only 32-bit. The 32-bit version of MSDASQL.DLL ships with the 64-bit OS, but is in the "x86" program files folder. It can be used when defining 32-bit DSNs with the 32-bit ODBC in WOW-based applications. More deta ...Show All

• Asura Installing SQL Server 2005 on Windows VISTA ULTIMATE

  Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Please help. I had IIS 7 installed. The first time was a clean install of vista with iis 7. I tried IIS running without IIS 6 compatibility and with it. During the setup of db services it fails to find the user. I am using the local system account option to install. I confirmed IIS wa ...Show All

• ximadyn MDAC Roadmap and .mdb files

  I know this isn't SQL server related but this seemed to be the only appropriate forum. I would like to work with Access databases (.mdb files) via (non-managed) C++. At the moment I'm using the ODBC provider for OleDB. However I see from the MDAC " Data Access Technologies Road Map " that this provider is deprecated. The OleDB/ADO alternatives seem to be focussing on SQL server only; I just want a 'local', non-networked desktop system. What technology should I use that isn't deprecated Yours, Peter If you are using C++ and either OLE DB or ODBC then you might want to consider SQL Server 2005 Express Edition ( http://msdn.microsoft.com/sql/express/ ). I'd also recommend looking at C+ ...Show All

• tecnocrata SSIS: Roll Backed Data transfer task

  Hello, I'm Designing sql server 2005 SSIS Packages. According to my requirment i have a sequence container. It has few data flow task, on success of one next one is running. If any one of them get failed then it should roll backed all the transaction. Each Data flow task transfering a data from one server to another server in similar table. Thanks. Thanks for guiding me. Transactions are covered quite well in Books Online, and here are some other links to articles on transactions. Native Transactions ( http://wiki.sqlis.com/default.aspx/SQLISWiki/NativeTransactions.html ) Transactions in SQL Server 2005 Integration Services ( http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservic ...Show All

• Grace SQL Using a Variable in SSIS - Error - "Command text was not set for the command object.".

  Hi All, i am using a OLE DB Source in my dataflow component and want to select rows from the source based on the Name I enter during execution time. I have created two variables, enterName - String packageLevel (will store the name I enter) myVar - String packageLevel. (to store the query) I am assigning this query to the myVar variable, "Select * from db.Users where (UsrName = " + @[User::enterName] + " )" Now in the OLE Db source, I have selected as Sql Command from Variable, and I am getting the variable, enterName,. I select that and when I click on OK am getting this error. Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E0C. An OLE DB record is avail ...Show All