Recent content by gdeleon

Thank you Denny for your response. The "delete rows in destination table" option is not enough to me: sometimes the destination table is old and the source one has new or modified attributes. So, in order to be sure I have the same structure, I need to delete and re-create the table. As a...

Hi: Im am using the Import/Export wizard to copy tables from one database to another. When I select the destination table, if it already exists the wizard disables the "create destination table" option. ¿Do you know Why? Thank you, Gustavo de Leon

Hi Mark, The TS is on Windows 2000. I don't understand very well what you mean, I have read that printer redirection is the default behaviour in W2k TS, isn't it? Regards, Gustavo

I am installing TS on a Win2K server and I was told that I have to add any printer driver the remote computers could use. Some of those remote clients are Win XP and Win Me. When I try to add the additional drivers on the TS, I only can choose Win98, 95, NT4, etc, but not XP nor Me. How can I do...

Thanks to all of you. Gustavo

Hi: I have an Excel workbook with several sheets. Sometimes I want to find some text that can be in any of those sheets. Is there a way to find the text in one single operation? Thank you, Gustavo de Leon

Thank you, Max. My native language is Spanish and my English is really poor, so you don't have to worry about. You are right about the rollback and I know when SQL is doing it because of disk activity (I am working on the server and watch the disk led). I realize that a DTS is not responding...

Hi: I have several DTS packages that copy data from Visual Foxpro DBF tables into SQL 7. Each DTS package copy data from several tables into their corresponding tables in SQL. I am executing those packages several times because I am testing an application upgrade. I run those packages one at a...

I finally found the problem: I was importing from Visual Foxpro dbf tables to SQL tables. Visual Foxpro is case sensitive and the sort order I am using in SQL Server is not. So, some keys like "G" and "g" are different for VFP but not for SQL Server. Thank you Gustavo

I am importing data from dbf tables into SQL 7 using the DTS wizard. I import several tables without problem, but with some others I get the error: "Error at destination for row number nnnnn... Violation of primery key contraint.... Cannot insert duplicate key in object..." There is...