Will FTP and File System Tasks run in Workgroup Edition?

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - Why does using the "in" clause cause an error in my "Having" condition in 2000, but not 2005? Okay, here's the real query: select "Business_Grp" . "BusinessGrpAbbrev" AS "level0key" , case when "Business_Grp" . "GLUnitCode" in ( '012201' , '09C202' , '10C010' ) then 'A' else 'B' end AS "levelkey" , sum ( "Facility_Snapshot" . "TotalCmtmnt" ) AS "Total_Cmtmnt" from "t_mlcdm_d_businessGrp" "Business_Grp" , "t_mlcdm_f_facilitySnapshot" "Facility_Snapshot" where "Business_Grp" . "BusinessGrpKey" = "Facility_Snapshot" . "BusinessGrpKey" group by "Business_Grp" . "BusinessGrpAbbrev" , case when "Business_Grp" . "GLUnitCode" in ( '012201' , '09C202' , '10C010' ) then 'A' else 'B' end having case when ( "Business_Grp" . "GLUnitCode" in ( '012201' , '09C202' , '10C010' )) then 'A' else 'B' end = 'A' Keep in mind that this works correctly in SQL 2005, so the syntax should be valid as is. Replace all the case statements with simple comparisons, and it works in SQL2000 as well. Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 2
    - Dose anybody knows how to use MergeJoin component programitcally? I'm building a package programitcally and I can't find any document which shows how to work with MergeJoin component in code. Please help, Thanks Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 3
    - SQL Server 2005 SP2 cannot be installed because the Database Engine setup remains in suspended installation mode SP2 refuses to install for the Database Engine because “the previous upgrade did not complete”, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine. When I try to do the same thing this time, I’m presented with the ”complete the suspended installation” option, which when I run it reports the installation completed successfully. However, in reality the installation still remains in suspended mode for whatever reason. If I reboot and open the maintenance dialog, I’m still presented with the ”complete the suspended installation” option. I’ve even tried to run it more than once, but it doesn’t help. Needless to say, SP2 still refuses to install. I don't know why the installation is in a suspended state. I know every part of SP1 installed successfully in the end, and the computer never crashed during the installation. I've been using it every day since then, without any problems. All other parts of SP2 did install successfully. I created a feedback entry on Microsoft Connect, where you can find the log files created by Windows Installer. The URL is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=259606 Any ideas what I can do to resolve this problem Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 4
    - patindex with nvarchar Your query is working fine on my mac.. I tried with following statement ... Code Snippet Select * From dbo . GetKeywordsFromQuery ( N '"SQL Server" is "very good" AND "very Powerfull" AND ' ) OUTPUT: Word ------------------- SQL Server is very good very Powerfull What I am doubting here is @QUERY parameter. Pls check the datatype. And when you call the SP you should prefix the N. Example: Code Snippet Exec dbo.YourSP @query = N '"SQL Server" is "very good" AND "very Powerfull" AND ' ) Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 5
    - MDX Ranking Question Hi Michael, This is a common requirement, but it's beyond the ordered SQL temp table approach. You could use Rank() dynamically, as shown in the query below. But there might be a performance penalty - see this 2005 thread from the OLAP newsgroup: With Member [Measures].[QuantityRank] as Rank ([Product].[Category]. CurrentMember , [Product].[Category].[Category], [Measures].[Order Quantity]) Member [Measures].[SalesRank] as Rank ([Product].[Category]. CurrentMember , [Product].[Category].[Category], [Measures].[Sales Amount]) Member [Measures].[CostRank] as Rank ([Product].[Category]. CurrentMember , [Product].[Category].[Category], [Measures].[Total Product Cost]) Member [Measures].[OverallActivity] as 1/( (1/[Measures].[QuantityRank])^2 + (1/[Measures].[SalesRank])^2 + (1/[Measures].[CostRank])^2 ) Member [Measures].[ActivityRank] as Rank ([Product].[Category]. CurrentMember , [Product].[Category].[Category], -[Measures].[OverallActivity]) select {[Measures].[Order Quantity], [Measures].[QuantityRank], [Measures].[Sales Amount], [Measures].[SalesRank], [Measures].[Total Product Cost], [Measures].[CostRank], [Measures].[OverallActivity], [Measures].[ActivityRank]} on 0, [Date].[Calendar Year].[Calendar Year] * [Product].[Category].[Category] on 1 from [Adventure Works] Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 6
    - BCP loading failing on timeout error Yes I am using Cognos 7.3 version. Drive Space for temporary isquite high. SQL Server 2005 Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 7
    - allows blank value for integer Parameter Hi have a problem to solve and I hope that this is not a SSRS Bug. I created a Reports(using SQL Server Project) which has several parameters which values are passed to a SP. One of these parameter is an Integer and it is an optional value, so if the user fill it is used by the SP, otherwise the SP uses NULL and run anyway. I starts to define tha parameter: Datatype = integer Allow blank value Available: Non queried Default: Null if I want to Preview the report I have to provide an integer to the parameter's field ... If for instance I set: Default: Not queried = 0 In the moment I deploy and I use the ReportViewer in my window application the parameter's field is unabled!! So I tried this solution: Datatype = integer Allow blank value Allow null value Available: Non queried Default: Null In the preview the checkbox: NULL is checked and I click on the View Report. But when I deploy it,in the ReportViewer in my window application the parameter's field this checkbox is unchecked. Do I forget something during my setting I have to control it programmatically N.B. By default the user will not user this parameter so the best is that he can click directly on "View Report" without any additional "work" on the parameter!! Thank you for any help! Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 8
    - No one can help me on this prolem?????? Hi Jordi, Thanks for your message. Actually, I had tried this before if I don't misundstand what you sugested. 1. created @Employee at report side and passed the value{n1,n2,...,nk} to it from web app; 2. created @EmployeeName at report isde and set its value come from =parameters!Employee.Value, lable = parameters!Employee. Lable or. 2. created a dataset select EmployeeName from tableName where EmployeeName IN (@Employee), then, created @EmployeeName and set its value come from this dataset when the report was running, I had been able to get the values I wanted {n1,n2,...,nk} just liked what I passed from the web app with checkboxes beside them, but after I checked some of them and clicked "view report", the values in the @EmployeeName always showed the default value I set when created it (e.g., the value came back to 'Null' if the default value was 'Null', or 'n1,n2' if the default value was 'n1,n2') and the result report came out agains the default value. It really comfuse me! Did I do something wrong Any response will be appreciated!!!! Jone Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 9
    - SSIS deployment - redefined < xml version="1.0" > - < DTSConfiguration > - < DTSConfigurationHeading > < DTSConfigurationFileInfo GeneratedBy =" prev \user1 " GeneratedFromPackageName =" Package1 " GeneratedFromPackageID =" {0C5712C4-BFAD-45B6-A75D-E8C1BBCC9D29} " GeneratedDate =" 06/11/2007 15.14.52 " /> </ DTSConfigurationHeading > - < Configuration ConfiguredType =" Property " Path =" \Package.Connections[MyProject].Properties[ConnectionString] " ValueType =" String " > < ConfiguredValue > Data Source=X3SQLSERV;Initial Catalog=DBTest;Provider=SQLNCLI.1;Integrated Security=SSPI; </ ConfiguredValue > </ Configuration > - < Configuration ConfiguredType =" Property " Path =" \Package.Connections[RiskMgmt.mdb].Properties[ConnectionString] " ValueType =" String " > < ConfiguredValue > Data Source=F:\RiskMgmt.mdb;Provider=Microsoft.Jet.OLEDB.4.0; </ ConfiguredValue > </ Configuration > </ DTSConfiguration > that is my example config. file. So, if I add all of my connections as < Configuration ConfiguredType =" Property " Path =" \Package.Connections[MyProject].Properties[ConnectionString] " ValueType =" String " > < ConfiguredValue > Data Source=X3SQLSERV;Initial Catalog=DBTest;Provider=SQLNCLI.1;Integrated Security=SSPI; </ ConfiguredValue > </ Configuration > in one config file, I should be OK It doesn't metter that the attribute GeneratedFromPackageName =" Package1 " references one package of my is project Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 10
    - Merge Replication (Push) over Internet Hi all, I was wondering if someone could suggest a solution to my problem: I have an in-house production database. I wanted to use Merge replication (push) to mirror parts of this data to our Internet server on the web which has a Public IP. Steps I followed 1. Created an entry in “C:\WINNT\system32\drivers\etc\hosts” file with IP address of the Subscriber and just the “Servername” of the Subscriber on publisher machine (local server) 2. Created an Alias to the Subscriber 3. Connected to the remote server thru Mgt Studio 4. Created Merge Replication on the Local Database 5. Created Subscription to the remote server. 6. Started the Replication Agent I receive following msg " The process could not connect to Subscriber 'ISVR'. When I check the View Synchronization Status in Mgt studio it shows "The server 'ISVR' is not a Subscriber" I presume that if we have a Public IP at our end, then the Merge Replication will be thru. Is it possible to replicate without having a Public IP Any suggestions, Thanks. Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 11
    - Secure SQL Server remote access from ISV application mrdenny wrote: There is no way to block the local user from connecting while still allowing your application to connect. I believe that it is possible to restrict users to login only through application with the use of application roles ( sp_setapprole ) [1]. Search BOL, internet for more articles on the issue [1] SQL Server 2005 BOL Application Roles http://msdn2.microsoft.com/en-us/library/ms190998.aspx Added later: Check also my answer in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1612977&SiteID=1&mode=1 Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 12
    - SQL server 2000 move Madhu thanks for the reply. I tried tranfering the logins and it said that it was seccussful but when I go into the users of the master DB they are not there. any ideas of what I'm doing wrong thanks for you help. Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 13
    - Using CTE in data paging I select only 20 records at a time. But I need to send the count for entire selection. If I count on the client side I will always get up to 20 . Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 14
    - Aggregating records and displaying Hi, Thanks hunchback for the quick reply. I keep getting the error : Column 'dbo.class.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. I tried adding the GroupBy to the inner select without much success. Any clues!! Thanks. Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 15
    - Cannot connect to SQL Server with PHP Anybody Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 16
    - Changing the default database files path fails Waleed, You need to add the data and log files before you can assign the filename properties. Try the code here (I've adjusted your code): try { ServerConnection connection = new ServerConnection("localhost"); Server server = new Server(connection); if (!server.Databases.Contains("SMO_TEST")) { Database database = new Database(server, "SMO_TEST"); FileGroup fileGroup = new FileGroup(database, "PRIMARY"); database.FileGroups.Add(fileGroup); DataFile dataFile = new DataFile(fileGroup, "SMO_TEST_Data"); fileGroup.Files.Add(dataFile); dataFile.FileName = "D:\\SMO_TEST_Data.mdf"; LogFile logFile = new LogFile(database, "SMO_TEST_Log"); database.LogFiles.Add(logFile); logFile.FileName = "D:\\SMO_TEST_Log.ldf"; database.Create(); } } catch (FailedOperationException ex) { Console.WriteLine(ex.Message); } Tag: Will FTP and File System Tasks run in Workgroup Edition?
- Next
  - 1
    - Store Membership information using Access .mdb database Great. Thanks again Caddre. The converter worked and didn't give me any errors. Now I have a file named 'AccessMembershipProvider.vb' I'm now trying to understand what I have to do so that this file it is picked up by the "ASP.net Web site Administration Tool" once I view the "provider" tab. Any advice for that is also welcome. Thanks so far. Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 2
    - SQL 2005 Server DDL Trigger Errors Hi Brian, can you plese email me the code @ jigarlakhani@yahoo.com also, will this also work for SQL 2000 thanks Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 3
    - Merge Join - Output of Lookup as sorted field? You'll have to re-sort after the lookup, since the Merge Join requires sorted input. Can you guarantee that the values looked up will already be in order Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 4
    - Failing Execute SQL Task I tried changing it inside the SP and in the parameter mapping inside the SQL task to nvarchar, but I still no luck. If you have any other ideas, let me know! Thank you! Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 5
    - Null Values I remember running in to similar problem, but I am not sure if it is exactly the same. The work around (or the solution for that matter) was I opened the DataSet containing my dataTable. Clicked on the field in that dataTable and in properties, I Changed 'NullValue' property to (Nothing). By default, it's set to (Throw Exception), which forces the dataSet to throw exception even if its AllowDBNull is set to true. See if that solves your issue. Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 6
    - Management Studio Express "Save Results As..." CSV Encoding Thanks Satya, I have tried SP2 CTP and it seems to be exactly the same with that. Will look into Excel. Thanks for the info Dave. That is probably the next thing i would have come across. I am sure the extra functionality (encoding, formatting) could be added relatively easily/quickly. I think it is already incorporated in the full version of management studio. It seems strange that what they output in the express version does not open correctly in the program people are most likely to use (Excel) to view/manipulate the data. I tried to look into disassembling the code and possibly changing the encoding but the ssmsee.exe is not written in .NET. Also i am sure i would have had a few other problems if i had been able to. Thanks again Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 7
    - Connecting to a SQLServerCE database through vbscript Is it possible to talk to a SQLServerCE database from a vbs script If so, does anyone have an example Thanks, Mike Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 8
    - How to convert SLQ Server Express Database File to SQL Compact Edition File? try Primeworks's Data Port Wizard Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 9
    - No Report Manager When I enter http:\\localhost\Reports I get the following error message: The report server is not responding. Verify that the report server is running and can be accessed from this computer. The service is running. I have uninstalled/reinstalled SQL server and visual studio. I can't seem to be able to get to a report manager. Is there a way to recreate the proper links Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 10
    - For each Year Group in Matrix return last quarter's data I posted some pic links here but they do not show for me so I posted the issue with pics here I was trying to use a matrix report to return just the last quarter's data for a specific dataset. I didn't want to show the whole year data, so Sum was out - Likewise I couldn't use Last as the results went skewy as below, returning the last record as opposed to the SUM of the last quarters member data Using TopN for the Quarter Filter works to return the max quarter data for each year though, but obviously it does it for all the data points. Competitive Base Inventory needs to be the last quarter per year's data (like a balance if you like) but another measure in the matrix should sum all 4 periods. I realise this is due to the way the data is entered. Can I do this with a matrix or should I say go to SSAS and create some sort of calculation for Competitive Base Inventory This was the formula I used to get the max quarter per year BTW Just got to work out how to use the topN filter just for one data set (i.e. competitive base) but not for the other (Occupancy %) Hmmmmm Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 11
    - help with sql server express :S ok guys i think this is the right place to post this.. i developped a windows application for a client from which he can restore a dump database in order to simply run the program on a daily basis.Now the client is is another country and the boss is looking to work with something that disables "user interfirance"..thats is if lets say his machine crashed there would be no need to install sql server and bla bla bla..a friend of mine adviced me to use sql server express as a tool to do that...i read articles about it and realised that yeah this might work....since it will offer the same features as in installing sql server...(correct if i am wrong) now i downloaded the file from http://msdn.microsoft.com/vstudio/express/sql/download/ " SQL Server 2005 Express Edition SP2 Not sure what you need from your Microsoft SQL Server download and want to get started quickly Download the SQL Server Express database engine and Management Studio Express. Install Microsoft SQL Server 2005 Express Edition (more...) Microsoft SQL Server 2005 Express Edition is the free, easy-to-use, lightweight version of SQL Server 2005. Integrated with Microsoft Visual Studio 2005, SQL Server Express makes it easy to develop data-driven applications that are rich in capability, offer enhanced storage security, and are fast to deploy. SQL Server Express is free to redistribute and can be seamlessly upgraded to more sophisticated versions of SQL Server. " ok great ...so far so good.. i installed it and i cant simply work with it.. i dont know what my next step is. i mean if i open query analyser from my computer and connect to the computer in which i installed sql express i should be able to do that... am i missing something... do i need to write some code to connect can i manualy restore a database with sql server express i have sp2 installed .net framework 2.0 and 1.1 i am using vs.net 2003 sql 2005 i read major articles about that and nothing is simply streight forward...(i guess i didnt undestant a thing) help me out here...lol..a bonus might appear any moment now..hehe thanks in advance.. Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 12
    - Maximum size of the SSIS String Variable? I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT). Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 13
    - Distinct Count with Junk Dimension Attribute Hi, Suppose I have following Model Dimension which is formed based on Junk Dimension definition. JunkID ModelID ModelCode ModelTypeID ModelTypeCode ModelSpecificationID ModelSpecificationCode 50 50 BAO 2 FFCVT 2 F1C1 53 53 BGO 1 FFAT 1 FW4A4 55 55 NBO 3 FRAT 9 V4A5 60 60 NCO 3 FRAT 9 V5A5 97 55 NBO 3 FRAT 11 V4A5 99 53 BGO 1 FFAT 13 F4A4 And In Fact Table Suppose there is data as below... JunkID Amount 50 5210983 53 9576 55 7994 60 7872 97 4306 99 6519 Now my requirement is to make Distinct Count on ModelID. If I makes Distinct Count on DimModel.ModelID then it gives me 5 on every combination in Cube. If I make Distinct Count on FactTable.JunkID then it gives me 6 in places of 5 as above seen data. Please help, how can I make Distinct Count on ModelID in this situation Thanks in Advance Bhudev Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 14
    - /3GB Switch Here's how to change in through the system stored proc: Code Snippet --To display all options EXEC sp_configure 'show advanced options' , 1 RECONFIGURE --To change the max server memory. EXEC sp_configure 'max server memory (MB)' , 3072 RECONFIGURE --To switch off the display of all the options EXEC sp_configure 'show advanced options' , 0 RECONFIGURE Probably want to bounce the SQL service after that. HTH Ray Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 15
    - Many-to-many Relationship Issue/Question Deepak, I couldn't get the quoting to work, but here are my answers: So there are apparently 2 fact tables/measure groups here: EmployeeMonthly and BonusMonthly, with the latter having an associated "BonusType" dimension. - Yes But are the other 10 dimensions all directly related to EmployeeMonthly, or are some referenced via a separate "Employee" dimension (ie. each employee has a single associated member) - The other 10 dimensions all directly related to EmployeeMonthly, In either case, these dimensions would have referenced relationships to the BonusMonthly measure group, either via the Employee or EmployeeMonthly fact dimension. - I haven't tried that yet, but I will. I think that is one of the points I am missing. The only obvious many-to-many relation is between the BonusType dimension and the EmployeeMonthly measure group, via the BonusMonthly measure group (I'm assuming that EmployeeMonthly has a composite key like {Employee, Month}, which is a foreign key in BonusMonthly). - That makes perfect sense, but I am still confused on the exact relationship between EmployeeMonthly and BonusType. How do they connect to each other Is that with a composite key or with BonusMonthly Or is BonusMontly a table with the composite key When you are referring to a composite key, do you mean selecting the EmployeeKey, BonusKey, Date, etc. and make that a key Or concatenating those keys into a single field for the row, which is now a Primary Key The way I picture this is: EmployeeMonthly Table Employee Monthly Key Employee Key Date Key Bonus Composite Key 1 1 20061001 0 2 2 20061001 2_20061001 3 1 20061101 0 4 2 20061101 0 BonusMonthly Table Employee Key DateKey Bonus Key Bonus Composite Key 2 20061001 1 2_20061001 2 20061001 1 2_20061001 2 20061001 2 2_20061001 Here Employee #2 got three bonuses on 10/1/2006. Two of the bonuses were the same type and that is what confuses me about the composite keys, don't I need a Primary key in BonusMontly Also, I may be thinking in terms of a relational database, but when I connect EmployeeMonthly and BonusMonthly (in the setup above) I would expect three rows of duplicated data. Is that correct Thank you so much for your help with this. -Gumbatman Tag: Will FTP and File System Tasks run in Workgroup Edition?
  - 16
    - Cannot open report on Production Server Hello there, I have created a report with MySQL using ODBC connection.It works on my localhost server.then when i deployed it on the production server i get error saying.i checked my data source connection to my localhost and both have the same setting.what could be wrong.please help i am very desperate to make this work.thanks. An error has occurred during report processing. Cannot create a connection to data source 'Payment'. For more information about this error navigate to the report server on the local server machine, or enable remote errors cheers zolf Tag: Will FTP and File System Tasks run in Workgroup Edition?

Erik Sampsell

I have a package that does an FTP and some File System Tasks. It runs perfectly fine in BIDS but doesn't want to run via SQL Agent. Is the SQL Server Edition the problem

Re: Will FTP and File System Tasks run in Workgroup Edition?

Phil Brammer

I suppose it could be. But then do you have any error messages

Re: Will FTP and File System Tasks run in Workgroup Edition?

TheViewMaster

Another problem might be that your Package Protection level is set to "EncryptSensitiveWithUserKey" (default option) - and your Job runs under administrator account - in which case it is not able to decrypt FTP connection User/password

The solution I use is to set the ProtectionLevel to DontSaveSensitive and provide User/pass from config file.

Re: Will FTP and File System Tasks run in Workgroup Edition?

Erik Sampsell

The error message is:

The task "Get CMP File - FTP Task" cannot run on this edition of Integration Services. It requires a higher level edition.

Re: Will FTP and File System Tasks run in Workgroup Edition?

Phil Brammer

Erik Sampsell wrote:
The error message is:

The task "Get CMP File - FTP Task" cannot run on this edition of Integration Services. It requires a higher level edition.

Yes, you'll need to move to SQL Server Standard or Enterprise editions.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Re: Will FTP and File System Tasks run in Workgroup Edition?

TheViewMaster

Or you could try to use FTP component in script task

Or you could try to create batch file and execute that

Re: Will FTP and File System Tasks run in Workgroup Edition?

Erik Sampsell

Yeah that's what I did...I have a vbscript that creates a dynamic ftp script (necessary because the files I need contain the date) and then I execute a bat file that executes the ftp with the script.

I then use vbscript to do my file archiving and deletions.