• SSIS 2008

    I have a package with 5 data flow tasks and want to run them parallel. If any task fails, should the others still be executed and the task that failed, an email should be sent out.

    shaun20145 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

    Sflatbush60 pointsBadges:
  • SQL server 2008 provide access to SSIS

    Client needs access to SSIS sql server 2008   Thanks, Evgenia

    Evgenia5 pointsBadges:
  • How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005

    Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard". Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I...

    Pjunk5 pointsBadges:
  • How to transfer SSIS Tasks from 2008 R2 to 2012

    I am about to switch from SQL Server 2008 P2 to SQl Server 2012. I use a number of custom SSIS Tasks on 2008 R2 and I’d like to know if it’s possible to transfer them to 2012; and of course if it is possible, how to do it. I tried just opening my DTSX packages in Visual Studio 2010 but they...

    ITKE347,785 pointsBadges:
  • Does SQL Server Data Tools work with SQL Server 2008 (SSIS)?

    I'm trying to figure out if I can use SQL Server Data Tools (that comes with SQL Server 2012) to create SSIS packages for SQL Server 2008. Basically, I just want to use SSDT to create / maintain SSIS on both 2008/2012. Thanks!

    ITKE347,785 pointsBadges:
  • Loading flat file into a database table with SSIS

    Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...

    ITKE347,785 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE347,785 pointsBadges:
  • Security for SQL Server 2012 SSAS

    So I just installed an instance with SSAS only. Now, I'm curious how security (login) will be maintained. I've created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).

    ITKE347,785 pointsBadges:
  • Do you think you have the right analytics?

    Is your company working on any big data projects? How much confidence do you have that you have the right analytics to derive value from it? How happy are you with the analytics knowledge in your organization?

    Ben Rubenstein6,225 pointsBadges:
  • SSIS, CLR, sp_OAMethod or another method to call web method

    I have a question on which method is the best practice. I have been given a task to run a web service method every 5 minutes. There is one input parameter and no output to return. The service runs a bunch of functions to do data validation and then inserts into a DB2 database. (could not get a...

    ToddN200011,820 pointsBadges:
  • Is the future of Big Data bright or is it dimming?

    Tata Consultancy Services (TCS) Ltd., surveyed 1,217 big data and analytics, IT management, and sales and marketing professionals last year. Among their interesting finds were that of the companies that undertook big data in 2012, just over 40% predict seeing a return on investment (ROI) of more...

    Chris Leonard4,300 pointsBadges:
  • Issue with passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...

    274703110311274715 pointsBadges:
  • Will Big Data drive the next management revolution?

    Plenty has been written on the revolutionary technology advances that make big data possible. But the real value comes when people change the way they make decisions. Is big data also the basis of the next big management revolution?

    Chris Leonard4,300 pointsBadges:
  • What’s they key to having a successful data analytics career?

    One of the key takeaways from this year's Enterprise Data World conference was how to have a successful career in data analytics. A good way to ensure it happens...conduct a self assessment. Would you agree? If not, what's the key to having a successful data analytics career?

    Michael Tidmarsh30,910 pointsBadges:
  • Will the big data market continue at this explosive pace?

    The big data industry (Hadoop, NoSQL, and in-memory analytic engines) is booming as Wikibon predicts the market will exceed $47 billion by 2017. Wikibon analyst Jeff Kelly says while big data started out with the web companies, it's now taking off in almost every industry. Will the big data market...

    Michael Tidmarsh30,910 pointsBadges:
  • What’s the best way to deal with using personal data?

    When enterprises deal with big data, a fine line emerges between using public and personal information. While a company can't be responsible for personal data coming out in the public, simply using the data in models can lead to several legal and regulatory issues. What's the best way to deal with...

    Michael Tidmarsh30,910 pointsBadges:
  • HAWQ

    Is HAWQ Hadoop? HAWQ supports all common Hadoop formats can we combine Hive and PIG with HAWQ? Can we input a HIVE query or a PIG script into HAWQ?

    sandhiya5 pointsBadges:
  • Can in-memory computing handle big data demands?

    Big data may have met its match as in-memory computing has become one of the top 10 strategic technology trends of 2013, according to Gartner. Used by Google and Twitter, this approach allows easier access to data and provides better analysis. Do you think in-memory computing can handle big data...

    Michael Tidmarsh30,910 pointsBadges:
  • SPSS data entry problems

    When I try to enter data into SPSS, the program replaces my numbers with question marks as soon as I hit Enter to move to the next box.

    Ashlee5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following