.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Move SSIS from Enterprise Ed to Standard

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server



We have developed a SSIS solution on SQL Server 2008 R2 EE (64 bit) and now a client would like it on SQL Server 2008 R2 (64 bit), are there any issues? Workarounds ?



View Complete Post

More Related Resource Links

SSIS Environment Variable Standard Edtion Vs Enterprise Edition



We current use SQL 2005 Enterprise Edition and we have our SSIS package working great where the server names are picked from Environment Variables file stored on the server. We are now planning to use SQL 2008 R2 STANDARD edition and for some reason the SSIS package which works great on SQL 2005 using variables is not working on SQL 2008 R2. It complains about not able to find the location/environment variables.

Question: Is the Environment variables thing supported in SQL 2008 R2 STANDARD Edition?


Thanks !


Move (detach/attach) db from 2008 Enterprise to 2008 Express

Hello I just thought about this question. Is it possible to create a database on a SQL 2008 Enterprise edition and move it to a SQL 2008 Express edition or would i run into the same version problems as when moving from 2008 to 2005? The reason for this is that i have a virtual Dev environment that has SQL 2008 Enterprise edition installed and now i get a project that is to run on SQL 2008 Express. It would be nice if i could skip installing the express edition and work against the Enterprise edition until deployment. Thanks ps. wasn't sure if this was the right forum to post this in. Please let me know if there was a more appropriate place for this.

Content migration from MOSS Enterprise edition to MOSS Standard edition

Hi,     I have developed a web application using MOSS 2007 enterprise edition. I have customized the site using custom ASPX pages, custom Webpart and custom features. Also I referred http://blog.brianfarnhill.com/2009/03/19/changing-list-forms-through-code/ for updating the contents of list forms. I have configured SQL-Form based Authentication for this site. Now I have a need to migrate this site to an environment which has MOSS 2007 standard edition and use a Active Directory Authentication instead of SQL-Form based Authentication. So can anyone guide me wether this scenario is possible or it will create any compatibility issue?      Which are the precautions I need to consider for performing this task? I would appreciate any help on this. Thanks, Patav

SQL 2008 Upgrade Standard to Enterprise: Fail

I'm trying to upgrade an existing SQL Server 2008 SP1 Standard Edition to Enterprise.  Running the enterprise edition maintenance->Upgrade Edition wizard first got me the dreaded "Invoke or BeginInvoke cannot be called on a control until the window handle has been created." Eventually, I found an entry on Connect that mentioned closing all other windows and ensuring that the installer has the focus and this got me past that error.  Now that I can run the edition upgrade through to successful completion, it's not actually doing anything. Edition still reports as "Standard" and enterprise features such as "Compress Backups" do not work. I've run the upgrade twice and restarted the system to no effect. Before I do a "Rip and Replace" does anyone have any ideas on how to actually get the edition upgrade to work? Steve G. OS:    Windows Server 2008 R2 DB:    Product: SQL Server Standard Edition (64-bit)   Version: 10.0.2531.0 P.S. Just in case someone asks, yes, I did follow the instructions located here.

Downgrading from Sharepoint 2010 Internet Enterprise to Standard (Purely a licensing rights question

My company already owns a license for Sharepoint 2010 Internet Enterprise.  We are planning a two server Internet farm.  We need to buy one more license and we only need the standard version which is significantly cheaper.  Is it allowed to use Standard when we own a license for Enterprise?

2005 Enterprise upgrade to 2008 Standard?

We are currently running 2005 Enterprise Edition. Is it possible to move the database to 2008 Standard Edition?  

upgrade standard to enterprise MOSS 2007

When installed MOSS 2007, we provided the key for standard edition. Now we have to Install and configure Excel Calculation Services and full features in MOSS 2007. it is possible? If not support for standard edition how can we upgrade enterprise edition. we have a Enterprise key also.

MS SQL Server 2005 Standard or Enterprise with default encryption

Hi, I wish to know whether or not by default MS SQL Server 2005 Std or Ent edition will encrypt the communication over the network by default? As, when we test out the database activity monitoring solution to capture the SQL traffics from the network, we are unable to see the DB user name and Source Program but SQL statements is able to seen. According to the vendor, it is due to the nature of MS SQL Server 2005 that encrypt the communication by default. But, why is it only encrypted the DB user name and Source Program but not the SQL statement? Can someone provide me the answer? Is that true what the vendor claims?   regards, Teh

SQL Server 2005 standard Edition to SQL Server 2005 enterprise edition



My current version of SQL server is Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I want to upgrade this to Enterprise edition. I would like to know the below information please

  • step by step instructions on how to perform this upgrade
  • I have databases & replications setup on this server. Will the upgrade have any adverse effects on the current replication setup?

Any help and guidance is truly appericiated. Thanks.

Problem using SSIS to move DB2 data to Oracle



I will need your advice on a SSIS package which moves IBM DB2 (for z/OS V7) data to Oracle (AIX 10g). Thank you in advance.

Basically, this is a very simple SSIS package (created by SSIS import / export wizard) and just maps column by column. I used IBM OLEDB provider for DB2 to connect the source and Oracle Provider for OLEDB to connect to the destination.

The problem I ran into was that if the DB2 source value contains special (or invisible) characters then this value will be converted to a SPACE (' ') value on Oracle. To be more detailed, take the following example:

On DB2, value  000002D0000002D7 (EBCDIC HEX codes). This is actually a value of a column defined on DB2 as CHAR(8). Please note HEX '00' in EBCDIC stands for NULL and HEX 'D0' stands for character 'K';

On Oracle, this value will be stored as a SPACE (or a string of SPACEs) after data move.

On both DB2 and Oracle this column was defined as CHAR(8).

I guessed this was related to a code page issue, so I tried a few different code page to set for the source property (by setting the DefaultCodePage of the DataFlow source property), I used code page 37, 500, etc... All resulted in the same Oracle value.

The character set on DB2 is EBCDIC and the one on Oracle is ALT32UTF8. I guess it was the source provid

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise


We moved our databases to new hardware today (using copy database wizard)


The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m



We are a Prtner and get both of theseas part of our Action Pack subscription.  I am also installing CRM 4.0 on our SBS STANDARD 2008 Server.  Is it possible to put both the SQL 2008 ENTERRISE R2 and SBS 2008 STANDARD on the same box?  CRM 4.0 REQUIRES SQL for the Reporting functions etc.

  I need to do this asap as our Old Server is failing daily

Move data to DB2 on AS400 with SSIS


Anyone writing data to DB2 on an AS400 with SSIS?

I cannot get the OLEDB destination configured correctly.  I can set the destination up with a SELECT sql query, and preview the resultset.

The general state of SSIS as an Industry Standard

I wanted to solicit the feedback of the SSIS forum experts, as to their take on the state of SSIS as an industry standard application for processing files.  I've been using SSIS for close to a year, and have implemented some pretty complex solutions using it.  And from the beginning, I found myself annoyed by many of its quirks and limitations, some of them surrounding seemingly basic principles.  Even more annoying, is the fact that Microsoft seems to dismiss these limitations, as if they're not important.  With the release of SQL Server 2008, their obvious lack of attention to SSIS evident by it's minuscule enhancement list makes me feel that the support is not there -- by the industry, and therefore, by Microsoft.

I care, because I've found SSIS making my life easier, overall, when it comes to processing data from and to files, and I can see its potential.  But on the other hand, I am concerned that I (and the company I work for) may be investing too much energy into a technology that does not seem to be gaining support by the industry -- and again, consequently, by Microsoft.

Is SSIS going to continue to just be a back-burner solution, just used by a niche group of individuals, or will it eventually catch on and become more of an industry standard, and ultimately require Microsoft to put more of their own invest

Is Enterprise Edition necessary for a remote distributor, or is Standard edition sufficient


We're implementing SQLServer 2005 peer to peer replication on two servers running SQLServer 2005 EE. We also want each server to use a remote distributor (2 additional servers). Can we run SQLServer 2005 Standard Edition on the remote distributors, or is it necessary that they too need Enterprise edition?





WSS 3.0 on W2K3 Standard Server or 2K3 Enterprise?


Hi All,

Functionally, WSS 3.0 sites will work similarly on both Windows 2003 Server - Standard and Enterprise Editions. What would be the reasons for choosing one over the other?

Enterprise/Standard multi-instance licensing


Currently we are upgrading our SQL Server 2000 box to 2008 R2 Enterprise.  However, one of the apps locks itself to the Standard edition and will not install to Enterprise (without an additional 100K).  With SQL Server Enterprise you can install multiple instances of SQL Server without additional licensing--my question is, can one of the instances be a downgraded Standard version installation from the SQL Server Enterprise license, or do we have to get an additional SQL Server Standard license for the same box?

All licenses we are looking at moving to are SQL 2008 R2 processor licenses.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend