I am installtion MSDE on a Windows XP Pro. The install gets through to 5 seconds and freezes. THis sits for about an hour and nothing happens. The Microsoft SQL Server folder is created, but the services are not created. We tried to reinstall many times and removed the registry key before each reinstall (after uninstalling and rebooting). Any ideas about what could be wrong?
View 9 RepliesPlease help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?
View 1 Replies View RelatedHi
I am trying to install the MSDE.
I followed the steps on this page http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
on running the setup I get a message showing that the following instance is not valid and it doesn't install the MSDE.
Could somebody help me.
Akshat
Hi!
I have a big problem installing msde on an XP Pro. When I try to install (run setup), the process starts and when its nearly finished the progess bar goes quickly down.
There is no error msg or something like that. The event no is 11708 (msi information).
I tried setup with many differnt parameters SAPWD=.... Always the same: When quite finished installing, it ends.
I looked now for many hours in the forum and did not find any help.
Does anyone have a good solution ?
thx
pls help!!!I've tried to insatll the msde fr the webmatrix program,and have followed the instructions as said in the website.I aslo get all the screen shots showed on the site,but after 2,3 seconds there is a pop up error message saying,"The instance name specified is invalid".this is a software that I got through the book Sams teach yorself asp.net in 24hours(the accopmpaning cd has the webmatrix msde n some other software),they have said if we have questions about installing to ask this website.Need advice as soon as possible!!shelomi-colombo,sri lanaka.
View 2 Replies View RelatedPlease help,...
If I am going to install MSDE 2000, do i need to install sql server..??? I'm newbie in installing msde, After my installation what should I expect from my desktop to determine that MSDE already installed? Is it somewhat the same with sql server with Enterprise manger?? Im familiar in using Sql server but not in MSDE. Do I can make table and manage it accordingly using MSDE alone??? Or in order for me to create table I need to installed SQL Server..???Any information is highly appreciated.
while i am trying to install msde i am getting error that server setup can not completed for more information check server log
how should i solve this problemplease help me
Hi All
I am having a little trouble setting up MSDE.
I downloaded the most recent version of MSDE (sql2ksp3.exe) from the Microsoft site to my desktop.
I double clcked on the files to extract them, it created a sql2ksp3 dir on c drive.
I went to command prompt and entered the following in the c:/sql2ksp3/msde directory:
setup.exe DISABLENETWORKPROTOCOLS=1 SAPWD=**REMOVED** then enter.
The setup wizard started then finished after about 30 seconds.
I can't find MSDE anywhere as program just a folder with the original setup programs.
I know this is a total gummy question, can anyone point me in the right direction.
I didn't have MSDE or SQL Server prevoiusly on the system.
Thanks in advance
P
hi
i have downloaded the free MSDERelA from the official website but when i wanna run the installation, it says
"A strong SA password is needed for security reasons.Please use the SAPWD switch to supply the same"
i read the readme doc but i still cant understand how to install n where to find the SAPWD switch ??
Please guide me
Thank you very much
when i try to install the sql server desktop engine i get an instance name specified is invalid error...plz advice on this
View 3 Replies View RelatedHi all, I'm trying to install MSDE in silent mode and without using a .ini file (on a machine with windows 2000 server and SQL 2000 already insatalled).
At the end of the installation, the machine reboot automatically, but I need to stop this reboot.
Someone can help me?
Thanks all
Hi Folks,
I've jumped over from the sister site xtremevbtalk.com to ask the question:
Has anyone ever seen an issue where when installing MSDE, during the installation the pc reboots of its own accord?
After the MDAC is installed as part of the installation the pc reboots and upon boot up, MSDE is not in the program files directory. Instead it's sitting in the C: root. This occurs for a straight MSDE install or with an Instancename install.
There does exist a Microsoft SQL Server folder in the Program Files but it is incomplete. It's missing the Binn folder. Also, there is no reference to MSDE in the Add/Remove programs tool but ther MSDE service does show up in the Services. However I cannot start these as they are pointing to the correct location.
To date, I have tried removing the instance and installation from the registry. I have turned off all AntiVirus software. I have ensured I am using an Admin user profile. I have tried a blank sa passowrd for the installation. all of this is to no avail.
I am seriously stuck with this now and I am in dire need of a resolution so if anybody has any ideas or has seen this one before, I love some help.
Thanks,
Gb :)
Hi
I'm trying to install MSDE 2000 on my WIN XP machine using the setup.exe, but it always gives me error saying "set strong sa password" after the message " Please Wait while windows configures Microsoft SQL Server Desktop Engine"
I also tried installing it by command line command below, it shows that its configuring and installing software, but disappears in the middle. I see the SqlServer agent installed and also folders inside C:Program FilesMicrosoft Sql Server folder, but SQL is still not listed in the installed programs
msiexec /i sql2000.msi /log exception.log instancename="imalla
" securitymode=sql sapwd="sapassword"
Your help would be greatly appreciated
Thanks
Hi,
I've a problem with connecting to my local MSDE installation. I'm using Windows XP Pro SP1 and logged in as administrator.
I've installed MSDE without further options (=setup SAPWD="password"). After that I installed some examples from Microsofts '101 Visual Basic.NET applications' using 'setup SAPWD="password" INSTANCENAME="NetSDK"'. Now I have 2 services running, 'MSSQLServer' and 'MSSQL$NetSDK'.
Then I followed the examples from a german book and created a Dataset etc. to access data from the Northwind database. The following line is created as SQLConnection1:
Me.SqlConnection1.ConnectionString = "workstation id=""COMPUTERNAME"";packet size=4096;integrated security=SSPI;data source=" & _
"""(local)NetSDK"";persist security info=False;initial catalog=Northwind"
CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).EndInit( )
When I right-click on the SQLDataAdapter1 and select 'Preview Data' everything works fine and I could see 9 Employee records. But when I then start the application it could not connect to the server. The error appears already in the first line, a simple connection call:
Me.SqlConnection1.Open()
Please could someone help me solve this issue? I already read several postings, here, on other sides, and on MSDN. I found information about a user account 'APSNET' which I am not allowed to implement due to security reasons. I also found the information about named pipes and TCP/IP, and so I added 'Network Library =dbmssocn' to the end of the SQLConnection-string, but with no success :-(
Many Thanks in advance for your support!
Hi all, I know read all the posts already up on this subject... Hear me out.
Can anyone give an easy to understand, and I mean easy method for installing MSDE and configuring it so that I can connect to my server using Visual Studio.NET C#. I am having no end of troubles and I don't really understand why. I can log into osql using
osql -S BIGJ -E
that gets me to
1>
No problems so far
but when I try to connect using
SqlConnection("Server=BIGJ;DataBase=registeredUsers;Integrated Security=SSPI");
I am having no luck and I don't really understand why
Here is the stack trace
[SqlException: Login failed for user 'BIGJASPNET'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) System.Data.SqlClient.SqlConnection.Open() ADOAccess.WebForm1.Button1_Click(Object sender, EventArgs e) in c:inetpubwwwrootadoaccesswebform1.aspx.cs:52 System.Web.UI.WebControls.Button.OnClick(EventArgs e) System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain()
I think I am not understanding the fundamentals of SQL server or something so if anyone can help or point me to a good tutorial that will help me not only solve my problem but also understand what is going onas well.
Thanks everyone
I am trying to install msde release A on a Windows 2000 Pro, I specified a strong password but the installation failed. I also verified that the service SERVER is started. I'am attaching the log file.
Thanks for any help
the service is already automatic, but when starting Windows XP MSDE "asks" to be installed correctly, run setup again and as you can imagine i did so. I can't find the answer
please help me
Castrogeneris
Hi,
I tried installing MSDE SP4 on a windows 2000 Server.
Unable to deploy..getting error "The instance name specified is invalid"
Then tried installing with the following;
setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*v C:MSDELog.log
The log files indicates;
1] SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}
Loading extended custom action library C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}sqlcax.dll
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Attempting to change the service (MSSQLSERVER) path to : C:mssql7Binnsqlservr.exe -sMSSQLSERVER
MSI (s) (F8:30) [14:32:27:328]: Executing op: ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (F8:30) [14:32:27:328]: Executing op: CustomActionSchedule(Action=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Source=BinaryData,Target=InstallPerfMon,)
MSI (s) (F8:D4) [14:32:27:328]: Invoking remote custom action. DLL: C:WINNTInstallerMSI313.tmp, Entrypoint: InstallPerfMon
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}
Loading extended custom action library C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}sqlcax.dll
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 267
Action ended 14:32:27: InstallFinalize. Return value 3.
2] MSI (s) (F8:30) [14:32:38:656]: Executing op: ActionStart(Name=RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (F8:30) [14:32:38:656]: Executing op: CustomActionRollback(Action=RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (F8:68) [14:32:38:656]: Invoking remote custom action. DLL: C:WINNTInstallerMSI316.tmp, Entrypoint: DeferProperties
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (F8:30) [14:32:38:796]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (F8:30) [14:32:38:796]: Error in rollback skipped.Return: 5
MSI (s) (F8:30) [14:32:38:796]: Unlocking Server
MSI (s) (F8:30) [14:32:38:812]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 14:32:38: INSTALL. Return value 3.
3] Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
Property(S): SOURCEDIR = C:Documents and Settings hp-mgbDesktopMSDE Patchpatch filesMSDESetup
Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
MSI (s) (F8:30) [14:32:38:984]: MainEngineThread is returning 1603
MSI (s) (F8:2C) [14:32:39:000]: Destroying RemoteAPI object.
MSI (s) (F8:68) [14:32:39:000]: Custom Action Manager thread ending.
MSI (c) (24:FC) [14:32:39:046]: Back from server. Return value: 1603
MSI (c) (24:FC) [14:32:39:046]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 14:32:39: INSTALL. Return value 3.
and finally
MSI (c) (24:FC) [14:32:39:078]: Note: 1: 1729
MSI (c) (24:FC) [14:32:39:078]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
MSI (c) (24:FC) [14:32:39:078]: Grabbed execution mutex.
MSI (c) (24:FC) [14:32:39:078]: Cleaning up uninstalled install packages, if any exist
MSI (c) (24:FC) [14:32:39:078]: MainEngineThread is returning 1603
Please suggest me whats wrong with the installation.
Regards,
Parveen
Hi,I am trying to install MSDE from a CD. At the beginning I cunpack all files at C:sql2ksp3. Then in in Command promptI enter C:sql2ksp3MSDE> Setup SAPWD=Hello SecurityMode=SQL The problem is that nothing happens after that. When I press enter another line appears C:sql2ksp3MSDE>but that's about it.The installation does not continue. Does anybody know how to "push" it a bit so it will continue?Thanks
View 1 Replies View RelatedI have been trying to install MSDE for a week. An appraisal program I need to set up uses it. I have been running changes and believe that I am close.
Section of setup log where it fails:
MSI (s) (28!C0) [13:16:30:812]: PROPERTY CHANGE: Adding SqlUpgradeProduct property. Its value is '{E09B48B5-E141-427A-AB0C-D3605127224A}'.
Failed to find available component set
MSI (s) (28!C0) [13:16:30:828]: PROPERTY CHANGE: Modifying SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B property. Its current value is '1603'. Its new value: '60007'.
Action ended 13:16:30: PickInstanceComponentSet.2D02443E_7002_4C0B_ABC9_E AB2C064397B. Return value 3.
I did not find anything different in a setup on a laptop that works. I'm unsure where to look.
will appreciate any help.
Thanks,
Jim
I try to install MSDE as a new instance (SQL2) on my computer with Windows 2000 Professional, but a problem occurs and instalaltion does not complete successfully. I am an administrator of the computer. The application log contains the following errors descriptions:
"The SYSTEMCurrentControlSetServicesMSSQL$SQL2Perfo rmance key could not be opened or accessed in order to install counter strings.The Win32 status returned by the call is in the Record Data as DWORD 0. " and
"Installing the performance counter strings for MSSQL$SQL2 failed. The Error code is DWORD 0 of the Record Data. "
Have someone experienced a similar problem?
Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).
The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?
Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?
Thanks in advance.
Ok,
My SQL Server production DB freezes for 20 minute periods about 3 times a day, during
this time no-one can do anything. I checked the perf. monitor counters (all
the ones there at default), the scary part is that they ALL fall to 0 during
the freeze, then rise to normal. Yes, that's zero %!
I checked the ID's connecting, there are no common ones that connect just
before a freeze, and there are no hardware issues. It's only a 400Mb DB,
with a trans log of 120Mb. Between 200-400 users are connected during
business hours, both from the LAN and off. Some users are running some
fairly heavy reports, but there's no correlation between these and the
freezes. The biggest table only has 1.5 million rows, and the average query
time is 232 milliseconds.
This whole mess has been going on since the 15th of Jan, we searched high
and low for any alterations made, but the client swears blind that no
changes were made. Any ideas anyone?
Thanks in advance all,
Jaishel.
Hi,
the SQL DB freezes and no one can access the DB for 5 or 10 minutes. Even select queries don t execute, nothing is displayed.
Until we kill the process id that s blocking in the sql activity monitor, only then the DB is released and people can work again.
What does it mean that no query executes until we kill the processes ID? what could it be?
Also, recently we created indexes and ran tuning adviser, is it possible that the creation of indexes cause the freeze of a DB? is that possible?
Thanks a lot for your help
Hi all !
Hi have a package with 3 steps :
1 - import data from flat file into a temp table
2 - copy selected data from the temp table to permanent tables
3 - truncate temp table
The task #2 is a SQL statement
INSERT INTO MODELS (MODEL_ID)
SELECT DISTINCT MATNR
FROM STANDARD
WHERE MATNR NOT IN (SELECT MODEL_ID FROM MODELS)
where STANDARD is the temp table and MODELS a permanent one. My problem is this simple task freezes all the time. It stalls on 'Starting' and stays in this state forever when I execute the package.
Any idea why ?
We're running the Microsoft product SMS 2003 SP1 for software deployment, patching, hardware inventory, etc. The back-end is SQL 2000 Enterprise SP4 which is installed on the same box as the SMS 2003 SP1 product, and the DB is 145GB's.
We started noticing that the server would freeze every minute or so for 30 seconds. We started logging stats via perfmon and saw that the average disk queue length for the physical drive of F: would skyrocket between 400 - 500 for 30 seconds at the same time the freezing occurred. I have determined that this is occurring during the checkpoint. The recovery interval option is set to the default of 0 on SQL, when I changed the setting to every 5 minutes, the average disk queue length for the physical drive of F: would skyrocket between 400 - 500 every 5 minutes and would subside after 2 minutes. I understand the need for the checkpoint / recovery interval option, but don't believe this high average disk queue length should be occurring.
Does anyone know why this is happening and how to fix this ? The freezing of the box while checkpointing is killing me.
Thanks
Hi all
I have a master table, with ID Column int, and Description column Varchar
And another details table, with MasterID Int, and Detail id INT
If i use this query:
SELECT * FROM table1 a INNER JOIN table2 b ON a.id_col=b.id_col
Never returns data, and get freeze, and i have to kill process on Managment
But if i use this:
SELECT * FROM table1 a INNER JOIN table2 b ON a.id_col=b.id_col+0
It returns data i Want, is this a Bug? Or i have an error?
The 2 columns is the same data.
But if I run this,
SELECT * FROM table1 a INNER JOIN table2 b ON a.id_col+0=b.id_col
Nothing happens,
What could it be?
SQL server freezes my machine.l'm running sql2000 and sp2.Every now and then it freezes my machine as if its running a process in the background. How can l sort this out its slowing my machine down.
l've got 512mb of ram and l don't see why l should have problems with memory .Please help
Hi
We are repeatedly having the trouble of our publisher database becoming unresponsive during network problems.
We have publisher in carribean, distribution agent in canada and subscribers all over. The problem comes when publisher cant deliver to distributor due to network outages.
We are planning on moving the distributor to the carribean ultimately but that will take a while, and our application repeatedly needs to be restarted due to these freezes.
Does anyone know of this problem & possible ways to fix it in the short term (short of changing our replication topology).
is this a bug in replication?
ps.database is merge & transactional pubs. (some tables merge/some trans)
help much apprec,
des
Hi, I'm using SQL2005 v9.00.3042.00 (SP2) on Windows 2003. I have a situation, when I turn on and begin to trace a database using the "SQL server Profiler", that particular VB application that uses the databases freezes (hourglass) when user click on anywhere that require a data query (download list, etc.) until I either pause or stop the trace, what gives? Thanks in advance.
View 2 Replies View RelatedSet up - windows server 2003 - SQL server 2000 + tools installed
Not sure why its happening but recently when running some scripts onto one of the databases held on the server windows crashes.
I say crashes - it is non responsive but the mouse cursor can be moved.
these scripts are not being run from the server but from one of many machines on our companies network.
Any suggestions would be great
We have SQL 2000 running on Server 2003. The server has 4 GB RAM, RAID 1 and has the /3GB switch in Boot.ini. We have 6 databases, the largest is about 14 GB. Until recently I could use Enterprise Manager to perform database backups to a folder on the same server but now the operation fails. After selecting the location for the backup and clicking OK, the hard drive light comes on but goes out after 15 - 30 seconds. The progress bar does not move. I've waited and waited but nothing further happens and the server doesn't respond. The only solution is to push the power button and let the server re-boot. Very occasionally the backup will run for a minute or two and the progress bar might get to about one third of the way across, (in which case the destination file will show up with more than 0 bytes), but it never completes. I can find nothing in the event log relating to this problem. As far as I am aware, nothing has changed since the last successful backup. Backups to tape using Retrospect appear to work fine but I haven't done a test restore. Does anyone have any ideas as to what I can try to get the backups working again?
View 14 Replies View RelatedI am trying to move data from a transactional database to a data warehouse using a slowly changing dimension. The transactional data comes from a view in SQL server that takes <60 seconds to run and returns about 60k rows. The warehouse table is currently 80k rows long (and growing), and contains 7 historical (type 2) dimensions. When I execute the package in BIDS the DataFlow Task begins to execute, and shows that between 20k and 30k rows have been pulled from the data source into the SCD Transform in the first hour before it simply stops doing anything. This is not to say execution stops; it continues. There is no error thrown. No warning given. System resources are 98% free. The database is not being hit at all. And yet, I have let the package sit 'still' as it were for over 8 hours, and nothing ever happens.
Here is a copy of one log:
starttime endtime message
4/8/2008 9:36 4/8/2008 9:36 Execute phase is beginning.
4/8/2008 9:36 4/8/2008 9:36 PrimeOutput will be called on a component. : 1715 : Union All
4/8/2008 9:36 4/8/2008 9:36 A component has returned from its PrimeOutput call. : 1715 : Union All
4/8/2008 9:36 4/8/2008 9:36 PrimeOutput will be called on a component. : 2912 : Staged Queues
4/8/2008 9:36 4/8/2008 9:36 Rows were provided to a data flow component as input. : : 2970 : DataReader Output : 70 : Slowly Changing Dimension : 81 : Slowly Changing Dimension Input : 9947
4/8/2008 9:37 4/8/2008 9:37 A component has returned from its PrimeOutput call. : 2912 : Staged Queues
4/8/2008 9:37 4/8/2008 9:37 A component has returned from its PrimeOutput call. : 2912 : Staged Queues
4/8/2008 9:59 4/8/2008 9:59 Rows were provided to a data flow component as input. : : 1718 : New Output : 1715 : Union All : 1716 : Union All Input 1 : 3825
4/8/2008 9:59 4/8/2008 9:59 Rows were provided to a data flow component as input. : : 1688 : Historical Attribute Inserts Output : 1682 : Get End Date : 1683 : Derived Column Input : 645
4/8/2008 9:59 4/8/2008 9:59 Rows were provided to a data flow component as input. : : 1702 : Derived Column Output : 1692 : Update End Date : 1697 : OLE DB Command Input : 645
4/8/2008 10:01 4/8/2008 10:01 Rows were provided to a data flow component as input. : : 1759 : OLE DB Command Output : 1715 : Union All : 1758 : Union All Input 2 : 645
4/8/2008 10:01 4/8/2008 10:01 Rows were provided to a data flow component as input. : : 2970 : DataReader Output : 70 : Slowly Changing Dimension : 81 : Slowly Changing Dimension Input : 9947
4/8/2008 10:24 4/8/2008 10:24 Rows were provided to a data flow component as input. : : 1718 : New Output : 1715 : Union All : 1716 : Union All Input 1 : 3859
4/8/2008 10:24 4/8/2008 10:24 Rows were provided to a data flow component as input. : : 1688 : Historical Attribute Inserts Output : 1682 : Get End Date : 1683 : Derived Column Input : 641
4/8/2008 10:24 4/8/2008 10:24 Rows were provided to a data flow component as input. : : 1702 : Derived Column Output : 1692 : Update End Date : 1697 : OLE DB Command Input : 641
4/8/2008 10:26 4/8/2008 10:26 Rows were provided to a data flow component as input. : : 1759 : OLE DB Command Output : 1715 : Union All : 1758 : Union All Input 2 : 641
4/8/2008 10:26 4/8/2008 10:26 Rows were provided to a data flow component as input. : : 2970 : DataReader Output : 70 : Slowly Changing Dimension : 81 : Slowly Changing Dimension Input : 9947
4/8/2008 10:49 4/8/2008 10:49 Rows were provided to a data flow component as input. : : 1718 : New Output : 1715 : Union All : 1716 : Union All Input 1 : 3969
4/8/2008 10:49 4/8/2008 10:49 Rows were provided to a data flow component as input. : : 1688 : Historical Attribute Inserts Output : 1682 : Get End Date : 1683 : Derived Column Input : 662
4/8/2008 10:49 4/8/2008 10:49 Rows were provided to a data flow component as input. : : 1702 : Derived Column Output : 1692 : Update End Date : 1697 : OLE DB Command Input : 662
4/8/2008 10:49 4/8/2008 10:49 Rows were provided to a data flow component as input. : : 1793 : Union All Output 1 : 1787 : Get Start Date : 1788 : Derived Column Input : 9947
4/8/2008 10:49 4/8/2008 10:49 Rows were provided to a data flow component as input. : : 1814 : Derived Column Output : 1797 : Insert Destination : 1810 : OLE DB Destination Input : 9947
4/8/2008 15:34 4/8/2008 15:34 The pipeline received a request to cancel and is shutting down.
4/8/2008 15:34 4/8/2008 15:34 Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown or an error in another thread is causing the pipeline to shutdown.
4/8/2008 15:34 4/8/2008 15:34 Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown or an error in another thread is causing the pipeline to shutdown.
4/8/2008 15:34 4/8/2008 15:34 The pipeline received a request to cancel and is shutting down.
4/8/2008 15:34 4/8/2008 15:34 Thread "WorkThread1" has exited with error code 0xC0047039.
4/8/2008 15:34 4/8/2008 15:34 Thread "WorkThread1" has exited with error code 0xC0047039.
Notice the time difference between the last OnPipelineRowsSent event and the first OnError event (when I clicked the stop button): 5 hours! In all that time, SSIS did not log a single event, or use more than 2% of my processor or exceed 1GB page file or hit the database even once! I am assuming this means it is simply not doing anything. It is not failing, nor is it executing, it is just sitting there.
Has anyone experienced a similar problem? Does anyone know how I might troubleshoot this? Thanks in advance for any help, and let me know if I need to clarify. Also, I am new to SSIS, so if I am missing something obvious, go easy on me! Thanks.
Mitch Connors