• 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...

    ITKE56,470 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!

    ITKE56,470 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...

    ITKE56,470 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!

    ITKE56,470 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...

    ToddN20006,360 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:
  • Importing data into SQL server from Intersystem Cache Database

    I have been trying to import data to SQL Server 2012 R2 from Cache database (Inter system Cache). How could I do it? I have tried by using SSIS through which I can export data to Cache? Am I going in the right way? Please help me? Thanks in advance

    nagakrishna5 pointsBadges:
  • Setup SSIS for a group of developers.

    I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that the 12...

    Cnboon5 pointsBadges:
  • The SSIS 2008 R2 job does not complete execution

    I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly. 2....

    Iamhere98025 pointsBadges:
  • SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?

    I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL...

    RobertDBA5 pointsBadges:
  • MaximumErrorCount

    HOW DO I CHANGE THE MaximumErrorCount IN SSIS

    Vercom5 pointsBadges:
  • SSIS cache

    We are developing packages in a SSIS environment using Version 9.00.3042.00. I’m presently having problems or a misunderstanding on when to use Partial or Full cache on lookups. Seems like the lookup results differ when using these two modes. For example, full lookups often “succeed” (turn...

    Kurt5 pointsBadges:
  • Refresh Excel file on a different server with SSIS package

    I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.

    Tocken10 pointsBadges:
  • Write Record to table as XML from RecordSet destination

    Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?

    Kayj5 pointsBadges:
  • Without Using Script in SSIS

    HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script... please help me T_T.... Thx so much... :D

    SSISCaseStudy5 pointsBadges:
  • Tool for ETL/SSIS packages testing

    Which is the Best Tools for ETL/SSIS packages testing

    Contactvishal5 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