Answer Questions

• JavaBoy Database Snapshot

  Need some help, i have some database snapshots files provided from an external source. Need to be able to understand how i get them back into a database format if possible. Files for example are table1.bcp, table2.bcp with als a file called scheme.sql which sets up these tables in sql but does not populate them. Nothing else was provided except a .vcd file which i dont know whtat its for. any clues Dan I dont have the original database though, only these files and this link assumes you have the original database / Dan Yes you are correct, this does indeed seem to be a Bulk Copy in Native format, guess i was going down the wrong path. Thanks i now have the data in the correct format, also the extract works ...Show All

• Santosh Ransubhe Forcing Calculated Measure to be calculated at processing

  When is a calculated measure calculated My understanding is that it depends on the aggregation level and can be pre-calculated if the aggregation level is high enough in the aggregation design. I have a calculated measure that is core to all my processing and is the main reason for building a particular cube, Is there anyway I can force a calculated measure to always be calculated as part of the processing So how can I get a pre-calculated measure without having to do all the work in SQL as part of the DSV Can I create a real measure which is calculated via a MeasureExpression or something Only real measures and measures expressions are precomputed during process ...Show All

• nate-d-o-double-g foreign characters are not being imported into the table correctly

  hello everyone, i have few fields that contain foreign characters with diacritic marks which are not getting imported correctly. below is the import format: - File type: ASCII - Row delimiter: carriage return and line feed {CR/LF} - Column delimiter: Tab - Text qualifier: None Please advice. Here is the errors i'm getting: - Executing (Error) Messages Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Country_str_local_long_name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard) Error 0xc020902a: Data Flow Task: The "output column ...Show All

• Krutika [097] Memory leak detected [1260 bytes]

  I have received the following error my SQL Server Agent Log. [097] Memory leak detected [1260 bytes] When this happens jobs will fail with the following error. [000] Unable to retrieve steps for job Backup TLog - 1stComp (Increm) My current work around is to stop and restart the SQL Server Agent services. Has anyone seen this before Is it corrected in the the 2153 hotfix What is the service pack level on SQL & Windows Also the memory leak errors seems to be hardware related too, might invole the Vendor to confirm the health state of hardware. It's SQL Server 2005 SP1 64Bit Enterprise Edition. The server is a Dell poweredge 6850 with 8 Physical CPU's 64 GB of RAM Windows server version 5.2.3790 SP1 build 3790. I sh ...Show All

• Ning Another Mysterious issue in SQL 2005 & SSIS

  Explain this: Package runs successfully from BIDS It runs successfully in SSIS store It runs successfully when I manually execute the Job JOB FAILS EVERY FREAKING NIGHT TheViewMaster wrote: Jamie Thomson wrote: s Have you installed SSIS on the server that SQL Server Agent is running on Yes - SSIS is installed Whereabouts is it installed Because the C:\Program Files\Microsoft SQL Server\90\DTS folder is where it gets installed to by default. -Jamie Change the job step type from "SQL Server Integration Services Package" to "Operating System (CmdExec)".  Just enter the command to run dtexec ("C:\PROGRAM FILES\Microsoft SQL Server\90\DTS\Binn\d ...Show All

• rp666 SQLCMD VS BCP

  Hello, I have the following BCP bcp.exe "SELECT * FROM LAW.dbo.A" queryout "C:\Test\Test.txt" -c -q -C1252 -T -S "SEA2-LawrenceB1" -t "," ResultSet Seattle,Lawrence,1 New York,Jeanette,2 However, my issue is that BCP DOES NOT include Header in ResulSet. Ideal ResultSet (first row is Header) City,Name,Num Seattle,Lawrence,1 New York,Jeanette,2 I would like to use SQLCMD to include Header info. However I am not able to find the correct switches to accomplish this. The current format which I DO NOT desire includes - "..........." on the second time, "<rows> are effected" message is returend. Let me know if any of you could help me with this ideal format in ...Show All

• CJW99 scale greater than precision - not a valid instance of data type real

  Our shop recently upgraded to MS SQL 2005 server from the prior SQL 2000 product. I receive and error during processing related to inserting a value into a field of datatype real. This worked for years under MS SQL 2000 and now this code throws an exception. The exception states: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 15 ("@TEST"): The supplied value is not a valid instance of data type real. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. This error is caused by inserting several values that fall outside of a range that MS SQL 2005 documentation specifies. The firs ...Show All

• Billr17 Unreliable Checkpoint

  With 2005 SP1. Have built a SSIS package that successfully saves a checkpoint file and sometimes successfully restarts. (I've also built some others that are 100% reliable). On the unsuccessful restart it appears as though the failed steps and subsequent steps do not execute. the package appears to "complete" though and the checpoint file is removed as though everything is fine. On a successful restart the failed step reexcutes and everything works fine. The issue appears that when a failed step finishes at the same time as a successful step finishes there is contention in the process that writes the checkpoint file out and the checkpoint file is corrupt. The failing step runs in parallel with a successful step and the execution t ...Show All

• klai SQL Server Assertion ERROR

  We have a browser based application that is doing some updates on the database. This app was earlier built to run on SQL server 2000 and we are in the process of migrating to SQL server 2005. Until now the application was seamlessly working on the new SQL server 2005 database. I got the following error message on the web when an item was clicked on the web that triggered a set of database updated through our app server. This is first time i am seeing anything like this. --------------------------- Windows Internet Explorer --------------------------- Unable to delete the selected items. Warning: Fatal error 3624 occurred at Feb 5 2007 2:34PM. Note the error and time, and contact your system administrator. A severe error occurred on ...Show All

• nialljsmith Disappearing Precedence Constraints

  Has anyone seen precedence constraints disappear in a package after closing and opening again In this case, it's not package-wide. Only constraints inside one Foreach Loop container disappeared. Any idea what causes this to happen p.s: Yes, I did Save All. Most of these contraints were saved in the package for more than a week anyway. I have not seen that. Is your package under any source control software is that the case compare it against previous versions. A similar issue has been reported for many of us; but the problem was inside the Dataflow (when using VSS as source control)though.... M.Glenn wrote: BTW, I'm using VS 2005 Pro--installed after SS05/BIDS. I wonder ...Show All

• bxchan Error: unable to retrieve column information from the data source

  Hi, I am trying to set up a data flow task. The source is "SQL Command" which is a stored procedure. The proc has a few temp tables that it outputs the final resultset from. When I hit preview in the ole db source editor, I see the right output. When I select the "Columns" tab on the right, the "Available External Column List" is empty. Why don't the column names appear What is the work around to get the column mappings to work b/w source and destination in this scenario. In DTS previously, you could "fool" the package by first compiling the stored procedure with hardcoded column names and dummy values, creating and saving the package and finally changing the procedure back to the actual o ...Show All

• Sassie How to list all tables ordered by their size within a SQL Server 2005 database?

  Hi, all, Would please any expert here give me any guidance and advices for how to list all tables sorted by their size within a SQL Server 2005 database Thanks a lot in advance for that. With best regards, Yours sincerely, Hi, Neeraj, Thanks a lot for your very helpful guidance. With best regards, Yours sincerely, Hi, A similar kind of query I've seen on a site. In the example given by the author of the query, he used Dynamic Management Views. You can find the original query from here http://www.extremeexperts.com/SQL/Scripts/FindSizeOfTable.aspx As per your requirement, I have made some changes to the query. Here it is WITH table_space_usage ( schema_name , table_name , ...Show All

• SaimaSalim passing a null value for a multi select parameter

  I have many reports currently written in Crystal Reports that I am porting to RS and these all have several multi-select parameters. Our current implimentation is to pass in a comma delimited list of the values. If we want all of the values, we pass in a null value to the Crystal Report. The stored procs are built to handle this. My RS reports work if I select or pass in valid values, however I get errors if I try to pass in a null value. Why can't I pass in a null value for multi-select parameters, and if I allow blanks, why does VS Studio/Preview and Report Manager force me to select a value anyways to run the report ...Show All

• Alex-MyRpg SQLCMD mode :XML ON not supported

  29 Sep 2006, 8:30 PM UTC DBA_NA Posts 1 "Command Xml is not supported. String was not processed." sqlcmd ":XML ON" Was this post helpful I'm outputting my select statement to a file using sqlcmd ":out" and finding the output truncated at 65K -- the text output limit. Per BOL " sqlcmd Utility ", I found that I should turn on XML -- but both in Express and Enterprise I get " Scripting warning. Command Xml is not supported. String was not processed." Why is this documented option not working Microsoft's answer at http://connect.microsoft.com/S ...Show All

• rs2005itw SSIS Database Login

  Is there a reason why SQL 2005 SSIS always allows selects windows authentication instead of getting the login details from the current connection like SQL 2000 It is not really a problem, but my work demands importing and exporting from SQL Server on a regular bases. The old method was just helpful. eXcalibur.lk wrote: Is there a reason why SQL 2005 SSIS always allows selects windows authentication instead of getting the login details from the current connection like SQL 2000 I guess the thinking is that you won't be running your packages in a produciton environment under the developer's UserID. I think that's a pretty safe assumption to make. Is it a ...Show All