Sassie's Q&A profile

• SQL Server Import errors from Excel to SQL 2005 DB Table

  How frustrating is this, all I want to peform is a one column to one column Import here! Why am I getting this error when simply trying to import from my excel workbook to my table  I know excel has a 255 char cell, but I specified to only account for 100 characters during the SSIS Import wizard in Management Studio.  This is using SQL 2005. See the setup here http: / / www. webfound. net/ excel_ import. jpg Then I get this error during the import:  Validating (Error) Messages Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "F1" with a length of 255 to database column "Name" with a length of 100.  (SQL Server Import and Export Wizard)   Warning 0x8004707 ...Show All

• Visual Studio Express Editions renclock

  Hi renee I dont know if you are interested in this but I have imported renclock into vb2005.....there are lots of errors which I am not qualified to fix but i,m sure you could do it.... is this of interest to you cheyenne   cheyenne, I suggest you to read a book called Upgrading Microsoft Visual Basic 6.0 to Microsoft Visual Basic .NET. The book is written by Ed Robinson, Michael Bond and Robert lan Oliver and pressed by Microsoft. I am reading this book recently and I believe it will bring you enough knowledge when upgrading VB6 to VB.NET :-) ...Show All

• Visual C# What string do I use in System.Diagnostics.Process.Start()?

  I found this method -- System.Diagnostics. Process .Start -- to log into a user's computer and in my case in order to download a file. In a command window you can say something like: net user z:\\IPaddress\SharedFolder password /user:computerName\userName I tried doing this using the System.Diagnostics.Process.Start but I get this error: Error message: System.ComponentModel.Win32Exception: The system cannot find the file specified at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo) at System.Diagnostics.Process.Start() at System.Diagnostics.Process.Start(ProcessStartInfo startInfo) at System.Diagnostics.Process.Start(String fileName) at FTPProgramWinApp2.Form1.ListFilesOnServer(String locationOfFol ...Show All

• SQL Server Replication Error 28559

  We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication). We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition. I had a chat with one of the Micro ...Show All

• .NET Development Synchronising Serial Communication

  I have a questiong regarding Serial Communication. Im trying to set up a communication between a computer and a machine. Sending data is not a problem because the machine has already an algorithm to check and validate the data received. But on my side, I have to develop this algorithm to be sure that I get sensefull information. I receive a byte that tells me an id of the type of operation, then a byte which tells me the number of following bytes of data to receive and two bytes for a special type of checksum. If for some reason I miss one character, my computer can think that one of the data bytes is the size of the data. Then I will read extra bytes as data, that will include operations IDs and size of data from other data packets. ...Show All

• SQL Server SQL Server Modeling Tool

  To All: I am in need of a tool that will allow me to reverse engineer a SQL Database and show me dependencies between Tables and Views, and dependencies that exist between Views and Stored Procedures. Any body know of a tool that does that Thanks, r use the sysdepends stored in every database http://weblogs.sqlteam.com/brettk/archive/2005/04/28/4830.aspx ...Show All

• SQL Server ODBC Data Source

  I'm trying to import tables from COBOL thru Relativity client. With SQL Server 2000, I used Other (ODBC Data Source) to do this. I cannot find a comparible data source in SQL Server 2005. What do I do Thanks, The Import wizard is not supported in SQL Express so this isn't the best place to get information about it. I'm going to move this thread into a forum where the folks who should be able to answer this question hang out. Mike ...Show All

• Visual C# best way to read pipe delimited text file?

  I am trying to read in a pipe delimited file and do certain processing for each field. I was just wondering what the best way to strip out each field is - is there anything built in .Net that will easily allow me to do this Or do I just loop through and remove each field myself Also, would it be best to strip each field out into a dataset first, and then do the processing Or, do the processing while I am separating each field Or does it not matter Thanks! Saeed it really depends. You can split the entire lines read into a string[] array if you like: string[] theLines; StreamReader theReader = new StreamReader("file.txt"); theLines = theReader.ReadToEnd().Split(new char[] { '|' }, Strin ...Show All

• Visual Studio 2008 (Pre-release) Is it possible to make batch changes to a layout?

  I want to move a whole lot of elements (up to thousands) on a canvas, and I would like them all to move simultaneously. Is there a way I can batch up changes to the Cavas.SetTop and Canvas.SetLeft calls so that they all take effect at once I thought BeginInit and EndInit would do the job, but it appeared to have no effect. I've tried adding all the changes I want to an animation storyboard, then running that, which initially appears to do the job, but I can't find a way of making the final values actually be set. The only choices I can find with animation are to revert to the initial value, or to maintain an overriding value over the set value, which remains at its initial value. That is not much use, as if I then change the canvas positi ...Show All

• SQL Server Using object variable as data source?

  Hi! These problem does't look like a problem, but i am not able to solve it... I have a stored procedure (in an Execute SQL-Task) what returns a few rows. These rows a written in an object variable. No problem. Now i want to use these result set in a dataflow as source. How can i manage these 1. Use a script task what returns the whole result set from the object variable How 2. Is there any other possibility to use the results of a stored procedure in the data flow All ideas are urgently welcome... Torsten Thanks, that seems to be a solution. But - i've tried to use it (i also tried his sample package), and i got the error (sorry, german): Fehler 2 Uberprufungsfehler Datenflusst ...Show All

• SQL Server How to take off the time part of the parameter

  Hello, How can I display data that only compare the date part (ignoring the time part) between the value of the date parameter and the database . It displays data only if I pass the whole date (date and time) I tried with the following query in the report services 2000, but it even didn't pass the query parse SELECT * FROM table WHERE (CONVERT(CHAR(8), table.PRODUCTION_DATE, 112) = CONVERT(CHAR(8), @parameterDate, 112)) Any ideas will be appreciated. Thanks, Marco What are the data types of the column and the parameter, and what error do you get when you say it doesn't get past the parse step ...Show All

• Software Development for Windows Vista July CTP Cardspace problems - Cannot run samples

  I have installed the July CTP on a fresh new machine: 1) The .NET 3.0 Runtime components 2) The Windows SDK for .NET 3.0 3) WF Extensions AFAIK, there is no corresponding Orcas tool to go along with the July CTP. All install well. However, I cannot run any of the Infocard samples. Running the setup.bat gives this errors: The service name is invalid. Apparently, there is no such service "Microsoft Digital Identity Service" installed. What am I missing Keith, Another thing you may want to take note of is that, while the claims uris have not changed, the way claims are presented on a html page has. It is now space-delimited and not comma-delimited as it was before. <object type="applicati ...Show All

• Software Development for Windows Vista Is there automatic reloading and executing when recovering from a crash?

  Hi This may be a stupid question but I really need to know what to do in this case. I'm developing a state machine workflow, I have an EventDrivenActivity with a TransactionScopeAcitivty in which I have activities to save to my data model. If something goes horribly wrong after the persistence point on the close of the TransactionScopeActivity before the persistence on idle (I have this set). Can I expect that when the outside factors are resolved the runtime will take care of reloading this partially complete EventDrivenActivity automatically and finish exection from after the TransactionScopeActivty. Or... am I going to need to somehow check for this situation and load the workflow instance to have it continue exection Any help wo ...Show All

• Visual C++ Help with c++ program as CLR....!...

  Hello. I'm just messing around with c++ making my own program just on my own just to learn...It's a Visual C++ CLR ..Windows Form App .......It seems to work just fine but at one part it's not..here's the code... #pragma once namespace question { using namespace System; using namespace System::ComponentModel; using namespace System::Collections; using namespace System::Windows::Forms; using namespace System::Data; using namespace System::Drawing; /// <summary> /// Summary for Form1 /// /// WARNING: If you change the name of this class, you will need to change the /// 'Resource File Name' property for the managed resource compiler tool /// associated with all .resx files this class depends on. Otherwise, /// t ...Show All

• SQL Server Schedule SQL Express BAckup using SQL DMO

  Is it possible to schedule SQL Express BAckup using SQL DMO do I need to use WScript.Shell,SQLDMO.SQLServer,SQLDMO.Category,SQLDMO.Job, SQLDMO.JobStep,SQLDMO.JobSchedule Because SQL Express doesn't include the SQL Server Agent the jobs you are creating can't be executed. You'd be best served to use Windows Scheduler to run the programs performing your backups. ...Show All