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.

  • Get size of SqlDataReader payload
  • Having ANSI_PADDING set on but still cannot insert padded with spaces values
  • SQL Server Convert date time to n period ago
  • how to implement undo operation in datagridview
  • How can i get all my sql server managment studio activite on my database as a executable tsql log?
  • Executing LINQ-to-SQL Debug Output?
  • 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?

  • TSQL Execute result different in PHP and SSManagement Studio
  • Connection Pooling in .NET/SQL Server?
  • Permissions issue while running SqlAgent Job
  • How to Control the Column Order in a Server-Side SQL Profiler Trace?
  • TOP slows down query
  • Update column based on combination of other columns
  • 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.