Post reply

SQL server Data import

  • March 5, 2010 at 1:08 am

    #386443

    Hello,

    Any help would be appreciated on this issue. We run a daily transfer of data from Equation (AS400) to SQL server for our internal reporting use. One file was imported to SQL Server with the correct number of records but with the value ’’0’’ in all fields, nevertheless it surely contained valid data that we used to use in our internal reporting.

    Thank you in advance.

  • March 5, 2010 at 3:01 am

    #1129051

    check the query, default values for the destination table.

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek

  • March 5, 2010 at 3:53 am

    #1129070

    how are you doing the import?

  • March 5, 2010 at 5:02 am

    #1129084

    the import is done by starting a job which uses a package containing the code to import the data.

  • March 5, 2010 at 5:07 am

    #1129087

    Hi

    Better to Create the SSIS OR DTS PACKAGES FOR IMPORTING THE DATA DAILY AND NEEDS TO BE PUT IN SHEDULER

    D i v y a

  • March 5, 2010 at 5:08 am

    #1129088

    Is this a SSIS package?

    If so you can run the package in debug mode in BIDS and set up a data viewer to track the data through the dataflows to find out where you 0's are coming from

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply