import data using ssis?

trying to set up an import form live database to our development database.

I trying to do this using SSIS, but the import is failing because of constraints.

  • Convert MS SQL script to Mysql and Oracle
  • ValidateExternalMetadata property, what exactly does this do?
  • unresolved reference to object .
  • Combining (concatenating) date and time into a datetime
  • Azure SQL server error Statement 'RECEIVE MSG' is not supported in this version of SQL Server
  • TSQL md5 hash different to C# .NET md5
  • E.g. I have the following tables:

    * Customers
    * Products
    * OrderLines
    * Orders
    

    Importing Customers and Products is fine, because they do not depend on anything. But when importing OrderLines it fails because the Order is not yet created.

    How do I change the order of how SSIS imports tables?

    Or maybe I’m not supposed to use foreign key constraints?

  • SQL Server: Must numbers all be specified with latin numeral digits?
  • SQLServer SQL query with a row counter
  • Why CREATE VIEW must be first statement in a batch?
  • SQL Group rows together based on specified Value
  • Microsoft® ODBC Driver 11 for SQL Server® on RedHat Linux with PHP - gives an error when bind parameter with PDO for stored procedures
  • Pentaho vs Microsoft BI Stack
  • One Solution collect form web for “import data using ssis?”

    It sounds like what you already have are foreign key constraints. You want to load the Orders table before you load the OrderLines table.

    I’m assuming that you have a single SSIS package that contains one Data Flow task for each target table. You need to create a connection between the Data Flow that loads Orders and the Data Flow that loads OrderLines. This connection is called a precedence constraint.

    Select the Orders Data Flow and you should see a green arrow. Click and drag the arrow to the OrderLines task. This creates the precedence constraint that indicates the Orders Data Flow must successfully complete before the OrderLines DataFlow can start.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.