DTS Package problem?

SQL Server Tools General

Index ‹ SQL Server

- Previous
  - 1
    - SQL EXPRESS TIMEOUT Hi, Are you attaching your database from QA / Query Window if yes check Tools->Options->Connection to set the time out option Or run this from query windows and refer this from BOL. USE master EXEC sp_configure 'show advanced option', '1' go exec sp_configure Hemantgiri S. Goswami Tag: DTS Package problem?
  - 2
    - Cloud of Confusion: Running SSIS packages on 64 Bit SQL Server You may have a problem with your installation. Connecting to SQL Server via OLE DB should work fine in either 32 or 64 bit. For Excel, you right, it only works in 32 bit mode as there is not 64 bit driver available. Tag: DTS Package problem?
  - 3
    - Does the actual update statement of a table affect Merge Replication? Firstly, if you are using row level tracking, updates to different columns at 2 sites will result in a conflict. Now, is this a user stored procedure that will do the updates to all columns If so, then yes, it will affect the conflict detection. From merge replication perspective, all columns are changed and it will flag it as a conflict. Why do you need to update all the columns Tag: DTS Package problem?
  - 4
    - Constant CPU usage on server when using SQL Server 2005 Management Studio I have a very similar problem as well though my details are a bit different. I have a development PC that is running Vista and has SQL Server 2005 Developer w/SP2 installed and running. When I run SQL Management Studio locally on that pc, then services.exe starts to peg my cpu. I have a dual-core CPU and it seems that this process gets about 33% of my cycles over time (have left it running for 24 hours idle and it got about 8 hrs of cpu time). However, the interesting thing is that I can run SQL Management Studio on a remote machine and I never see any hit to the CPU unless I'm really doing something that requires it. Monitoring mine, it seems the CPU (dual-core) is kept at 50% utilized (1 core 100% or split across cores) for about a 3-4 second period and then there's a 1-2 second period where it drops off and it seems to repeat this cycle until I close SQL Management Studio. This happens when I do nothing other than open SQL Management Studio - with nothing open aside from my Summary tab, an empty Object Explorer, and my Registerd Servers window (which does have the local server in a list there). I have tried changing whether or not SQL Management Studio has open connections to the local database server (same with the remote SQL Mgmt Studios) and no matter what I change, it seems to not affect the end result of simply having SQL Management Studio open on the server machine pegs the CPU. -Shane Tag: DTS Package problem?
  - 5
    - SP_Change_Users_Login You will have to do that per database. Check policy can ve turned of using: Code Snippet ALTER LOGIN SomeLogin WITH CHECK_POLICY = OFF Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: DTS Package problem?
  - 6
    - Partitioned View Problem Hello, I am assuming you are using SQL 2000. In SQL 2000, the partitions you have created are actually physical tables. You must be creating a view using these physical tables. In a SQL query you cannot use more than 256 tables. The link below might help.... http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx If you are using SQL 2005, then it would make your life easy. SQL 2005 allows 1000 partitions in a table. Hope this helped... Regards.... Tag: DTS Package problem?
  - 7
    - how to get all data from database on sql server 2005 What do you mean Like scripts that insert data Or just to duplicate a database You can duplicate a database easily using backup and restore. You can compare the data in two databases using Red Gate's Data Compare Tool http://www.red-gate.com/products/SQL_Data_Compare/index.htm . Tag: DTS Package problem?
  - 8
    - Linked server memory consumption No. A linked server, not in use, has no affect on the server at all. Tag: DTS Package problem?
  - 9
    - Querying 1 member from 2 hierarchies in same dimension? select { ([Date].[Fiscal].[Fiscal Year].&[2004], [Date].[Calendar].[Calendar Year].[All Periods]), ([Date].[Fiscal].[Fiscal Year].[All Periods], [Date].[Calendar].[Calendar Year].&[2004]) } on 0 from [Adventure Works] Just to reiterate the MDX concepts behind that. An axis (as in, "on 0") is a set. Sets are denoted with curly brackets. A set is made up of tuples. Tuples are denoted with parens: Select { (tuple), (tuple) } on 0 from [Adventure Works] Tag: DTS Package problem?
  - 10
    - Visual Studio closes when data source has changed This sounds like an error with Visual Studio and/or the package. Can you roll back to an earlier version of the package file and see if you can reproduce the error Also, do you have this problem with any other packages Are there any related events in the Event Log Tag: DTS Package problem?
  - 11
    - OLTP Database Design help for bank's customer table If you cannot restrict the number of adresses possible you should use the parent - child approach. Data retrieval should be lateron no problem if the index strategy is designed well. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: DTS Package problem?
  - 12
    - Need drillthrough for just one month--but cube goes back two years >>First, let me ask if I am correct in understanding that while fact tables can be partitioned, a drillthrough dimension cannot Thus, a drillthrough dimension must span the entire fact table That is correct. Drillthough is often implemented by creating fact dimension and you cannot partition fact dimensions. The solution is to define a view that spawns all the partitions in your cube and define fact dimenion off that view. This way you are going to get data for the entire range of data. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers no rights. Tag: DTS Package problem?
  - 13
    - Data Mining Client for Excel We can't play data mining with Office 2007 without a connection to Analysis Service Server. By Start -> Programs -> Microsoft SQL Server 2005 DM Add-ins -> Server Configuration Utility you have to choose a server that contain a data mining database. Tag: DTS Package problem?
  - 14
    - microsoft decision tree algorithm There are links to the appropriate research papers at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/986.aspx Thanks -Jamie Tag: DTS Package problem?
  - 15
    - DBCC SQLPERF WaitStates / OLEDB You may want to check the suggestions and information on OLEDB wait types at: http://www.sqldev.net/articles/WaitTypes.htm -Sue Tag: DTS Package problem?
  - 16
    - Sql 2005 Management Studio Scripting only keys feature is not provided in either EM or SSMO. But there are script available in net which do that. There is already request posted in Microsoft Connect i believe. And also u can do it using DMO/SMO check this thread http://www.sqlteam.com/forums/topic.asp TOPIC_ID=41896 Madhu Tag: DTS Package problem?
- Next
  - 1
    - SQL mail using external mail server Check if your SQL Server service running in the security context of a user account with administrative previleges or system account. Make sure you have logged on to the server as the service account user and created a messaging profile for outlook. After applying the service account settings, restart the SQL Server Service. http://support.microsoft.com/kb/312839 send email without using SQLMail. Tag: DTS Package problem?
  - 2
    - Synchronization fails I've been having this problem continually as well. Its been driving me nuts. Tag: DTS Package problem?
  - 3
    - Help on global variable for insert statement This sentence is confusing: "I have multiple textboxes that needs to be filled and then inserted, none of them exept Nulls." Do you mean that the table fields do not accept NULL values If I recall correctly, a textbox cannot contain a NULL value. At the minimum, it contains an 'empty string'. In your code sniplet, you are inserting the value '1rowst' in the field [Test1], etc. There is no ambiguity about NULL values. Perhaps I am missing something. Could you please expand upon your request so in order to clear up the confusion Tag: DTS Package problem?
  - 4
    - Network share/Multi user deployment Ah, no. While you can place a .SDF on a file share, the first process that opens the file locks it for all other users. This is discussed in my new EBook. See www.hitchhikerguides.net . Tag: DTS Package problem?
  - 5
    - Cannot connect to SQL Server DB Engine...Instance Contains SQL Express in Name Hello, SQL Server 2005 Express Edition is installed with Visual Studio 2005 by default. Of course, if you select that choice when you setup Visual Studio. So it's quite normal SQL Server Express Edition is installed in your environment too. If you want to install another edition of SQL Server, then I suggest you to obtain an evaluation copy from: http://www.microsoft.com/sql/downloads/trial-software.mspx Regarding to the problem, first ensure that your SQL Server service is running. You can run services.msc or SQL Server Configuration Manager to see that. If it insists not running, then tell us the error message. Besides, you better take a look at the Event Viewer to see if there is any error message specific to SQL Server's service. Tag: DTS Package problem?
  - 6
    - continuous attribute & Complexity_Penalty The decision trees algorithm does equal-range discretization at each node based on the node support (# of cases) and the actual range of values for the continuous attribute in question at that node. This explains the split example you describe and also why the same attribute may be discretized differently at another point in the tree. The COMPLEXITY_PENALTY parameter is a floating point number with a range between 0 and 1. It is used to inhibit the growth of the decision tree, the value is subtracted from 1 and used as a factor in determining the likelihood of a split. The deeper the branch of a decision tree, the less likely a split becomes; the complexity penalty influences that likelihood. A low complexity penalty increases the likelihood of a split, while a high complexity penalty decreases the likelihood of a split. The default value is based on the number of attributes for a given model: for 1 to 9 attributes, the value is 0.5; for 10 to 99 attributes, the value is 0.9 and for 100 or more attributes, the value is 0.99. Tag: DTS Package problem?
  - 7
    - Deploying subscriptions on different server Hi, I have three environments which are exactly the same. A dev, prod and backup server. Everyone has its own installation of SQL. What is the best practice to re-use the subscriptions for the other environments I know I could restore the test database but I would prefer not. Thanks in advance for any input. Best regards, Jam Tag: DTS Package problem?
  - 8
    - MDX Query performance issue The problem is with calculated measures that you use in your query. Please provide the expressions for all the calculated measures: [Measures].[Productivity Time in hours - Edited Docs] [Measures].[Productivity Time in Hours - Typed Docs] [Measures].[Productivity Time in Hours], [Measures].[Lines Per 1000] [Measures].[Hours Saved] [Measures].[Time Saved %] [Measures].[Typed Lines] [Measures].[Speech Utilization] Tag: DTS Package problem?
  - 9
    - DFT - Howto last execute a storedprocedure donRiccardo wrote: In a DataFlowTask with several OLE DB Destinations, how can I "last", before ending this DFT execute a storedProcedure This storedprocedure is used for saving metadata (taskname, rowcounts etc) regarding this DFT and I dont want to add an ExecuteSQLTask after the DFT in the Control Flow Regards Riccardo Why not The proper place for this *IS* after the data flow in the control flow. Tag: DTS Package problem?
  - 10
    - Jump To Report Without Running It Automatically Sometime ago, I made a post about this. It was stated that it's by design and that all parameter values must be passed to the report. I believe using the hyperlink feature might work though you'd have to manually append all parameter names and values that you -do- want to pass (reportname&param=val&param2=val2). Tag: DTS Package problem?
  - 11
    - Can I Upload a URL or Shortcut to the SSRS Home Page? OK, I figured it out -- sort of. Uploading a URL shortcut did not work, I got errors when trying to click on the short-cut. My solution was to create a simple HTML page with a redirect to the SharePoint portal site. That seems to works but displays it in the same window and not a new window. If the user clicks on the link from SharePoint to go back to SSRS then they can get cascading frames, one inside the other. That is a minor problem which can be avoided if they just use their BACK button. Tag: DTS Package problem?
  - 12
    - Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. SQLAgent jobs fails because of the reason that it waits for event to signal recovery is complete. Currently the only solution is to switch to thread mode. http://msdn.microsoft.com/sql/default.aspx pull=/library/en-us/dnsqldev/html/sqldev_02152005.asp Above article recommends that you stay away from fiber mode and focus your tuning efforts on other things. If you run into a situation where you feel strongly you need fiber mode, it's probably worth a call into Microsoft Product Support Services to confirm your diagnosis. Thanks, Gops Dwarak Tag: DTS Package problem?
  - 13
    - Capture date and timestamp of a file? Doesn't the transfer of files from the FTP server preserve the date and time You could inspect that with a custom script. Tag: DTS Package problem?
  - 14
    - SCOPE_IDENTITY() @@identity returns the LAST used identity value. It's not neccessarily the Scope value. This example should explain it. Code Snippet create table t1(i int identity(1,1), j int) create table t2(i int identity(100,10), j int) go create trigger _tr on t1 for insert as if @@rowcount=0 return; insert t2(j) select j from inserted; go insert t1(j) values(1) select *, @@identity [@@ident], scope_identity() [scope] from t1 go drop table t2,t1 go Tag: DTS Package problem?
  - 15
    - How to dynamically process a Model in a Web App You would likely use ADOMD.NET, not ADO.NEt, but the results would essentially be the same. You would likely want to create models on the fly for this solution, much the same way we do for the Excel addins. You can download the addins and use the trace mechanism to see what commands we send to the server. Essentially, you want to use CREATE SESSION MINING MODEL, INSERT INTO (you can use an input rowset, or an openquery if your data is in a database), and then SELECT PredictTimeSeries(...) to get the forecast. Using a session model will cause the model to automatically be deleted on disconnection. Note that you will have to turn on the server property to allow session models. Tag: DTS Package problem?
  - 16
    - SUM and Iif statements Hello, Try this instead: =Sum(iif(Fields!BB.Value = 1, 0, Fields!Billed.Value)) =Sum(iif(Fields!BB.Value = 0, 0, Fields!UnBilled.Value)) Hope this helps. Jarret Tag: DTS Package problem?

Bill_C

I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain).

I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent reports them as 'failed' .

What am I doing wrong

Top

Re: DTS Package problem?

Brad Feaker

This looks like a permissions issue...do you have a proxy account setup for the SQL Agent Look here for info...http://www.support.microsoft.com/kb/890775

Brad Feaker

Ex nihilo, nihil fit

Top

Re: DTS Package problem?

Satya SKJ

As referred if you are scheduling the DTS package then make sure to check privileges for the SQLAgent service account on those process, you can start the SQLAgent using a local account with Admin privleges to complete the task.

Top