Hello all,
Server setup: NT4 Sp4; SQL Server 7.0 + Sp1.
Client setup: Win95; SQL 7.0 MMC, the latest Dr Sol's/Mcafee virus s/w.
Some clients have experienced various problems with the MMC.
At times when the MMC is run from the START menu nothing happens. It does not load. Other times the MMC will load but after a period of time it will freeze and hence freeze the machine.
Has anyone else experienced these events?
Thanks,
Nev.
All -
I'm seeking information on why this control is so unstable.
Example: I have an application that loads a specific flat file into a staging table. This kicks off our whole price update application. It is very simple really. A flat file connection is used to pipe the file contents to a data transformation control.
Said control converts the input into unicode strings suitable for loading the staging table. The ole db destination objects is set up using the sa password to gain access to the database in which the staging table resides. When I first create the control it works fine for about the first 3 to 4 times.
Then, invariably it will eventually fail, the failure occurs on the column mappings, the control 'insists' on forgetting the column mappings.
I've done everything I can think of to validate that I'm doing something incorrect in setting up the data flow or this control in particular - and I cannot see anything. My thinking is that if I had done something wrong, it should fail immediately; not after 3 or 4 successful passes.
This is the only thing that I am having problems with, but since it involves being able to load data into the database in the first place, it is kind of an important thing; and it is very disappointing to constantly have this trouble. Am I experiencing something unique here, or is this control problematic and unstable at the moment?
TiA
Randy