We've got running an vb .net service which throws on-demand .DTSX. Now a new feature has been added: it must be able to launch dts 2000/7.0 too. No problem with that. It works fine using the same thread.
Issue comes when we were accostumed to cancel any DTSX execution for sake IDTSEvents interface and OnQueryCancel event. We want to the same but for the old ETL.
My wonder is how do the same but related with DTS???
I attached you this snippet of code which is responsible for launching a dts:
Have my first .NET app deployed to remote host and configured successfully, except for one thing: can't figure out how to export my SSE tables to the SQL server database on the remote server. I tried SQL Server Management Studio Express ... with that, I can access the remote database, but can't access the local database file I produced with VSWDE. What is the appropriate tool to use to export tables from a local SSE database file to a remote SQL Server 2005?
I am trying to get the SUM of the values from a subquery and I just can't wrap my head around the subquery thing! Can anyone please point out the error of my ways?
I have tried 2 slightly different ones:
Select project.[id] "ID", companyname.[name]"Company", project.projectname "ProjName", project.startdate "StartDate" ,SUM(BudgetTotal + AddTotal + StockTotal) "TotalBudget" (SELECT ISNULL(SUM(budget.budget),0) AS BudgetTotal FROM budget WHERE budget.projectID = project.[id]) (SELECT ISNULL(SUM(budget_additionals.budget),0) AS AddTotal FROM budget_additionals WHERE budget_additionals.projectID = project.[id]) (SELECT ISNULL(SUM(project_stock.saleprice),0) AS StockTotal FROM project_stock WHERE project_stock.projectID = project.[id])
From project, companyname
WHERE project.companyid = companyname.[id] AND (project.startdate >= '2006-11-01') AND (project.startdate <= '2007-10-31') AND project.jobtypeid = 1 ORDER BY "Company" This gives me an "Server: Msg 156, Level 15, State 1, Line 10 Incorrect syntax near the keyword 'From'" error...
The next one i tried looked like this: Select project.[id] "ID" ,companyname.[name]"Company" ,project.projectname "ProjName" ,project.startdate "StartDate" ,SUM((SELECT ISNULL(SUM(budget.budget),0)FROM budget WHERE budget.projectID = project.[id]) + (SELECT ISNULL(SUM(budget_additionals.budget),0)FROM budget_additionals WHERE budget_additionals.projectID = project.[id]) + (SELECT ISNULL(SUM(project_stock.saleprice),0)FROM project_stock WHERE project_stock.projectID = project.[id]) ) "Budget"
From project, companyname
WHERE project.companyid = companyname.[id] AND (project.startdate >= '2006-11-01') AND (project.startdate <= '2007-10-31') AND project.jobtypeid = 1 ORDER BY "Company" And I get "Cannot perform an aggregate function on an expression containing an aggregate or a subquery"
Hi there, it's me again. I am having trouble with a view again. I amtrying to do a calculation, but there are some checks that need to betaken into consideration. Maybe a view is not the right way to dealwith this. I don't know.This is the beginning of my query.SELECT coalesce(f.filenumber, i.filenumber) as filenumber,i.InvoiceNumber, i.InvoiceValue, il.lineid, MPF = .21 * (il.UnitCost *il.UnitQty + il.AddMMV - il.MinusMMV - il.MinusNDC + il.ErrorAmt)FROM tblFILE f inner join tblINVOICE i on (f.filenumber =i.filenumber) left outer join tblINVOICE_LINE il on (i.Invoiceid =il.invoiceid)This works just as it should. However, if the Sum of all MPFs perfile total less than 25.00 or more than 485.00 then each MPF has to berecalculated as:Percentage of TotalEnteredValue = (InvoiceValue / (il.UnitCost *il.UnitQty + il.AddMMV - il.MinusMMV - il.MinusNDC + il.ErrorAmt)Percentage of TotalEnteredValue * 25.00 = MPF orPercentage of TotalEnteredValue * 485.00 = MPFCan you do something like this in a View? Or do I need to dosomething like a trigger?I greatly appreciate all help. I am struggling to get a foothold onviews. I am getting there.
I have two tables I need to create in msSQL and I have the .sql files with the information in them, is it possible to insert them through enterprise manager? Or another way? Or are they meant for mySQL?
We are attempting to rollout a name and address system to 10,000 users who will use an application connected to an MSDE database.
We are using transactional replication to distribute data updates to them. Clients are connecting via the On-Idle feature of Synchronization Manager to grab transactions.
Server spec: Network card: 1GB Processors: 2* Xeon 3.2Ghz Server spec: DL380 2Gb memory Concurrent connections set to: 600 Disc: RAID 10 with 6400 controller
We are not using hyper-threading.
So far we have rolled the system out to 3500 subscribers, 500 per day.
Each day a subsciber will receive at least 400 transactions and 5000 commands.
Latency is 6 seconds, delivery rate 180 commands per second at less busy times. Latency is 14 seconds, delivery rate 127 commands a second at busy times.
I have seen it get as slow as 0.04 commands a seconds at busy times.
The server becomes incredibly slow when there are more than 50 concurrent connections.
We are seeing 100 CPU for most of the day as clients connect to the distributor at various times. Lunchtime is particularly busy when people go to lunch, leaving their machines idle. We see lots of "time-outs" and "unable to connect to distributor" messages on the replication monitor during peak times.
What can we do to improve the performance of the distribution server?
Are we being over-ambitious by selection SQL Replication for this scenario?
16 flat files all fixed width. Some over 350 columns.
Open flat file 1
extract id and go see if its in table 1, if true update table 1 with first 30 columns
otherwise insert into table 1 first 30 columns.
goto table 2, lookup id, insert/update next 30 columns...etc..etc..for 10 different tables
So I've got my flat file source, I do a derived column to convert the dates, i've got a lookup for table 1, then 2 ole db commands, 1 for update if lookup successful, 1 for insert if lookup fails.
How can I pass the id as a param into the update command so it updates where x = 'x'
also I need a pointer on doing the next lookup, eg table 2, would I do this as some sort of loop?.
If you can help great, but, please don't just reply with "I'd use this object"...then no explanation of how
