This is probably not productive, but I've just encountered one strange problem after the other with Integration services, to the point that I'm afraid struggling any more with it is going to hurt my productivity.
It is now 2:00 . I've been trying to build a simple package since 10:00 AM
It really is a shame because it seems to have alot of promise.
I'm using execute SQL task to call stored procedures ins a sequence. I like to drag the boxes in such a way around so that the pakage is more readable. Crash! Work gone.
So I restart VS Develop. Try it again. I'm calling a stored procedure and the taks fails. Apparently has to do with truncating from a table linked by a foreign key. So I change the stored proc to handle the problem. Run it. runs fine. Go back to Inegration services. Run the corresponding task. Fails. Same message.Go back to stored procedure. Notice changes I mad diodn't get saved. Funny how did that happen?. I make the changes again. Run the procedure. Runs fine. Go back to IS run task. same message. What the??
I look at the strored procedure again. my changes are gone again. Light bulb goes on. Hey, Integration services has taking it upon itself to reverse all the changes I made to stored procedures it references. 2 hours gone.
And its still reversing my changes after a reboot. So I drop the package figuring its corrupt and start all over again, meticulously rearranging all the boxes to the way I had them before, keeping my fingers crossed all the while, that it really can't be that everythime I make a change to a stored procedure referenced by an execute SQL Task, I have to drop the package and build it again.
And I'm working under a tight deadline.
Just wanted to give you guys some insight into customer experience with the tool. I don't mean to sound irritable, buts its just I've run into 1 too many ropdadblocks with this thing and I am really missing DTS.
Been learning web dev for five months in c#. The problem I have is that some weeks ago I moved my application to a new folder in my hard drive. All seemed ok but now my connection strings to insert data no longer work and throw exception saying...Object referance not set to an instance of an object. I dug into the new folder and it has created a new sql server ( I think) in app .data how do I connect to this new server and how do I find its connection strings.
Hi AllI am posting this in the hopes someone has come across the same issue and found a solution. The other day i uninstalled Microsoft ISA server 2000 from my SQL / Web server. Since then i have not been able to connect to the sql server via php. I changed the php config file and pointed it at another sql server i have up for development purposes that has a recent copy of the same db and everything works properly.The errors php is throwing at me show that it is not even able to find the server at all. I have changed it several times from both the netBios name as well as the actual ip and nothing seems to work.I should also note that other than the php access issue sql seems to be working perfectly for all other users in the office that are accessing it through the accounting system.System:Ms SQL 2000Windows Server 2003php 5 on IIS 6Any ideas?ThankspT
Hello, I have changed the account in which the Sql Server process run and not I cannot log into the server with any other user account (even if they are System Admin, DBO and Domain admin...) than the one which run the SQL process.
What can I do to gain back access (with the user accounts) ?
We change from SQL Server CE 2.0 to SQL Server CE 3.0, and we got our customer complaining about the performance lost in the process that makes 50 updates in the Pocket PC with windows mobile 5.0.
Our customer says that when they used the SQL Server CE 2.0 the process was quicker.
Process:
We need to do an update to 50 rows every time we lose the focus. Those 50 update are creating a deterioration of performance.
There is any Patch to add to SQL Server CE 3.0? There is any problem updating 50 times on a row losing performance?
I am no longer able to manage SQL Server at the server explorer in Visual studio. i.e. create, modify and delete for Diagrams, Tables, Views, Stored Procs & Functions. Further more, it missing Diagram and function folder. I can only view or read data.
I know this sounds bizarre, but hey... this is DTS, right?
For ALL of my local packages on a particular server, when I open them with DTS designer on my workstation, everything is fine - I can even execute them. When I log onto the server locally, and open them, the workspace is empty!!!
They are stored as local packages. As I said, I can execute them within designer on my workstation, but if I try to run them via dtsrun, I get an error saying "No Steps have been defined for the transformation Package." And when I look at them on the server, that appears to be true.
One last thing (I know you've heard this before)... Everything was working fine last week - that darn Santa.
I've run int o a perplexing problem. I have a SSRS setup on my local box. Everything has been working fine for weeks, up until now.
Recently, I had to change my password in our domain - which chouldn't be a big deal. But now when trying to connect to the report server, I get the following:
The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) What's odd is the fact that I'm able to connect to the database just fine via Management Studio and run queries. I haven't changed ANY settings in SSRS or IIS. And everything is set up to use Windows Integrated authorization...
Hi all I am trying to install SQL server 2000a I install per the instructions but when I go to plesk to create a SQL database I get the following error message: Unable to create database: Unable to create database-dependent object:Database Microsoft SQL server is not running. I am running a Windows 2003 duel processor server. I would also like to know if I can upgrade to service pack 3a from 2000a or do I need to install service pack 2 first. Also should I install service pack 4? Thanks Cruiser859
I have a test server where I was experiencing security/rights anomalies. I tried disabling the BUILTINAdministrators account, closed SEM, and when I reopened it, I could not access my Server (all databases,etc.are on local machine). I thought I could just use the SQL accounts (sa, etc.) to connect, but they all fail?? I tried creating a new registration, and that didn't work either. Since I deleted the old registration, and I cannot reconnect, what are my options(short of restoring image)? If I re-install SQL will all my databases still be there? Is there another way to get access back?? Any help would be appreciated.
I updated my SQL Server 2005 db server with Windows 2003 SP2 and other windows updates and now other applications are loosing their connections to the SQL server after a period of inactivity.
The ERP software and MSSS Managment Studio loose their connections if the connection sits idle for a couple of hours. When in Management Studio I get the following error: Msg 10054, Level 20, State 0, Line 0 A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)....
Has anyone seen this? Do I need to add SP1 for MS SQL 2005?
Hi there, I just upgraded from SQL2000 to 2005 and noticed that any DB engines you register do not get re-registerd when you restart the Management Studio, you have to reconnect every time you start Management Studio! SQL2000 used to keep your server connections. Am i missing something or is this just how it works now!? Thanks Ben
More and more often, I am seeing this error message in RS subscriptions. I would assume it means the IIS server can't connect to the corporate exchange server. However I was wondering if there is some timeout setting/configuration in RS or the IIS server (or any other kind of setting) I can change to help alleviate this problem.
Has anyone else experienced this? Or know how to fix it?
Thanks,
Jeff
UPDATE: After looking closer at the subscriptions, I have noticed that subscriptions set up by a RS Admin (who is also a server admin) seem to be working fine. It is the subscriptions that are set up by ordinary users that are failing...
I am having following problem in our SQL Server 2000 database €“
Somehow/body accidentally backup (complete) our database back to an old back up from 17th March 2008. So the data from 17th March to 20th May is lost.
And that was the most recent backup that we had for the database because Maintenance Plan was not working from the last march due to some kind of failure and nobody knows about it. L
Using Redgate€™s Log Rescue and Apex Log Rescue tool but we could not find any entry from 17th March to 20th May. Most probably because of the complete back up.
Can any one help me out in this situation? Is there any way possible to retrieve the data? It€™s really important for me.
Thanks in advance. I will be looking forward to you guys reply.
I have Full database backup upto previous day and transaction logfile of Today transaction. my database has crashed. I have restored previous day's Full backup. I have faced difficulty to restore today's transaction from today's transaction log. What are the steps to restore full database back and one day's transaction log file. Note: there is no differential database backup and transaction backup.
After I run a SSIS package which is a "Trasfer SQL Server Objects Task", the database users has lost all mapping to SQL server login. I've tried various options inside the package, however, to my surprise, sometimes the user settings at SOURCE database is lost! I won't suppose to change anything in the SOURCE database after running a data transfer... Anyone knows what's wrong? Thanks in advance!
In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express.
The Northwind Database in my SSMSE got lost very often, but I was not aware of it. How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects? Please help and advise.
Hi all......well ill try and explain what I dont understand :-(
I am completely new to SQL. I have downloaded SQL Server Express 2005. I guess I need to download another program now like SQL Query Analyaer so that I can query a database - can anyone recommend a free download that will do the job?? I had a play around with one that I downloaded but to be honest, I have no idea on how to get the two programs talking.
Is someone able to guide me through how to initially set up SQl Server and how to get evrything working??
I get multiples of one record. i dont want multiples. but i need to have all the records that are the latest and i dont know how. can you help me. thanks
SELECT TOP 1 [sn].[WrkstaId] ,[sn].[Computer Model] ,[sn].[Serial Number] ,[sn].[Asset Tag] ,[sn].[Computer Type] ,[id].[Name] ,[id].[Domain] ,[id].[OS Name] ,[id].[OS Type] ,[id].[Last Logon User] ,[id].[Last Logon Domain] ,[id].[Client Date] ,[pu].[_id] ,[pu].[Month] ,[pu].[User] FROM [Altiris].[dbo].[AeXInv_AeX_HW_Serial_Number] sn INNER JOIN [Altiris].[dbo].[AeXInv_AeX_AC_Identification] id ON [sn].[WrkstaId]=[id].[WrkstaId] INNER JOIN [Altiris].[dbo].[AeXInv_AeX_AC_Primary_User] pu ON [sn].[WrkstaId]=[pu].[WrkstaId] WHERE [sn].[WrkstaId]=(SELECT MAX([WrkstaId]) FROM [Altiris].[dbo].[AeXInv_AeX_HW_Serial_Number] WHERE [Serial Number]='68659') ORDER BY [pu].[_id] DESC
68659Latitude D62028LGGD1Data not accessiblePortableWL-28LGGD1AZCORPMicrosoft Windows 2000Professionaluswclh04AZCORP2008-01-16 17:20:37.000864649Januaryuswclh04
68659Latitude D62028LGGD1Data not accessiblePortableWL-28LGGD1AZCORPMicrosoft Windows 2000Professionaluswclh04AZCORP2008-01-16 17:20:37.000864648Decemberuswclh04
After much hard work and effort I finally got SQL Server downloaded and opened. I am at a lost since the "Dummies" books, SQL & SQL Servier 2005 Reporting Services, I have don't (I can't find or understand) explain what I am trying to do. I have been able to create a couple of table, but can't see them. I can see the queries but not the actual table unless I run a query. How can I open the table it self?
Would to import an Access table in the SQLEXPRESS but can't figure out how. Can I get some guidence?
Any help I can get would be helpful. Thank you in advance.
Hello,I am using visual studio express edition. I making a nice website that uses the ASPNETDB.MDF for all those cool asp 2.0 membership and roles stuff.. This uses a SQL express database. OK so far. I have tried and tried to get my website live so I can further test it, but I can't People have been helpful, escpecially Bruce from this forum. I need more than help I guess. I really need to get this website up. Can someone please tell me where I can go to hire someone who will talk me through this process. I am not a programmer, I am a hobbyist. I understand SQL to select and update my database, but I can't do the stuff I read in FAQ's. It seems to be written for professionals. I have tried 3 different hosting services none seem to work. Please someone send me a private msg. we can work out terms. I am sure with someone over the phone that knows sql express and visual web developer expres will have me up and running in a jiffy. I can send payment via paypal.Jason
This procedure is missing one importent piece is I need to have a customerID added to the invoice table. The CustomerID comes from another table called Customer_Invoice_cart. I don't know how to convert Customer_Invoice_Cart.CustomerID to a @CustomerID to add to the table. If there is anyone out there who is good at stored procedures (unlike me who is learning) could help me out. FYI I realy cannot get the CustomerID for the .aspx page, it is not called any where.
procedure [dbo].[InvoiceAdd]( @EmployeeID int, @CartID nvarchar(50), @OrderDate datetime, @OrderID int OUTPUT)AS BEGIN TRAN AddInvoice /* Create the Order header */ INSERT INTO invoice( employee_number, invoice_date)VALUES( @EmployeeID, @OrderDate) SELECT @OrderID = @@Identity /* Copy items from given shopping cart to OrdersDetail table for given OrderID*/ INSERT INTO invoice_books( invoiceID, ProductID, TaxID, Quanatity, UnitCost, UnitPrice ) SELECT @OrderID, Inventory_Invoice_Cart.InventoryID, Inventory_Invoice_Cart.TaxID, Inventory_Invoice_Cart.Quanity, products.UnitCost, products.UnitPrice FROM Inventory_Invoice_Cart INNER JOIN products ON Inventory_Invoice_Cart.InventoryID = products.ProductID WHERE Invoice_CartID = @CartID INSERT INTO invoice_books( invoiceID, ServiceID, Service_TaxID, Service_Quanatity, ServiceCost) SELECT @OrderID, Service_Invoice_Cart.ServiceID, Service_Invoice_Cart.TaxID, Service_Invoice_Cart.Quanity, services.price_leval1FROM Service_Invoice_Cart INNER JOIN services ON Service_Invoice_Cart.ServiceID = services.serviceID WHERE Invoice_CartID = @CartID /* Removal of items from user's shopping cart will happen on the business layer*/EXEC Customer_Invoice_Cart_Empty @CartIDEXEC Inventory_Invoice_Cart_Empty @CartIDEXEC Service_Invoice_Cart_Empty @CartID COMMIT TRAN AddInvoice
I used sql 2000 create a data base at home call 'Mysite' several months ago, there are about eight tables and 30 stored procedures. When I run my asp.net program at home yesterday, and found can't connect to database. The error as follow: "Cannot open database requested in login 'Mysite'. Login fails. Login failed for user 'MINGYANG-MSONXHASPNET'. "
When I open the database, very surpriced to found that my database was suspect and not any item inside it. The suspect database include CommunityStarterKit. But Northwind and pubs database still there?
What happen? Last week I just download new Norton antivirus software, does have any relationship with it? Does data really gone? How to solve this problem?
What is the quivalent of EM for SQLExpress2005? With the old SQL 2000 I used EM to manage tables, SPs and such. Now, I cannot even find the databases - I installed the Club Starter Kit and I want to view and modify some tables. How do I do that?
Hello all let me first start out by saying I suck at SQL. I can do quite a bit with ASP.NET but SQL Server is on area that has haunted me and I have finally decided to bite the bullet and figure this behamouth out.Well here is my first problem, which is the biggest reason I can't seem to understand SQL Server or dataases in general.To have a realtional database you set up tables with foriegn keys and primary keys referenceing the id's like product table has a product name and one of the columns is a user_id displaying the id number of the user in the user table. From what I can tell you are supposed to set up the user_id in the products table a foriegn key to the Primary Key in the user table. I may be totally wrong on this though.Now my biggest question is how do you retrive this information the proper way to get it ready to be displayed in a gridveiw or a datalist? I have been reading SQL Server 2005 for developers and reading online tutorials and it seems like they say you need to set up a relationship and because of the realtionship you don't need to do a join, but I never hear how to use the relationship at all.Please someone help I am so totally lost that i feel like i will never understand. I have spent the last week trying to figure this out and I guess I am just googleing this wrong completely or i am incompentent one of the two.Thank you.
My company took over a project that another company was building. The other company switched all the passwords for the system and the database right before they left. No one has the passwords to the system or the database. Is there a way I can dump the data, or re-mount the drives into a different machine and get the data? Or am I just screwed? I have physical access to the machine and I can do anything needed I just need this data asap!!
Hi, maybe someone has some clues to the following situation. Suppose from a SQL 7 database, only the log .ldf files are lost. All datafiles are present. Suppose there is no backup of this database. SQL Server will put the database in the SUSPECT status. The following question is very interesting to me: Can one recover from this situation??? I ask this, because when datafiles are lost, it's obvious that you have lost data, but since the transaction log files are a "bit special", I just wonder how one can survive such a situation. I know that IF a database has only ONE log file associated with it, and this one log file gets lost, SQL Server will create on startup a new log file. But with multiple log files, it does not behave in this sympathic manner. Is there perhaps any way to recover (for example, an undocumented dbcc command or so) ? I surely will appreciate any tip or suggestion !! Thanks!!!
We lost all the data we had in a table. We restored the db and the transaction log up to a point in time, but could still not recover the table. We eventually only do db restore without the transaction log. We recovered the data in the table in question, but lost all the data entered that particular day. Does any body have a solution or suggestion that can help? I will be greatly appreciated.
Hi, I face a different behaviour between SQL Server 6.5 and 7.0 regarding the global variable @@identity. I insert a row into a table with an identity column. This table has an insert trigger attached which performs another insert into a second table. Now I seem to lose the identity value (@@identity is NULL).
Example: Take the following 2 tables:
create table a (aaintnot nullidentity, bbintnot null )
create table b (bintnot null ) go
Table a has a trigger attached:
create trigger a_trigger on a for insert as insert b select aa from inserted go
After this I execute the following SQL statement:
insert a (bb) values (1) select @@identity
On 6.5 I get the result: ------------------------------------------ 1
On 7.0 I get: ------------------------------------------ (null)
Which means that outside the trigger I have lost my identity value. This feature of Version 6.5 I usually use to maintain event logs. Using a trigger hides this maintenance nicely from the application. My question is now, is this a new feature of Version 7.0 or is it a bug? BTW: The books online describe this behaviour in the case when the trigger inserts value into a table with an identity property, which is not the case in my example.
Regards Marco
Marco Ruggli ruggli_m@simultan.ch Simultan P&I Kantonsstrasse 1 6246 Altishofen, Switzerland
