Post reply

Data is not copied into the table using SSIS package.

  • March 22, 2012 at 11:35 pm

    #259061

    I created SSIS Package to extract the data from text file then load data into database.

    So i used one flate file surce and OLEDB Destination.

    Finally, when i am going to run the package,package showing successfully running in green color.

    Then i look into the table.There is not any single data row is writtein into the table.

    Please share your thoughts.

    I am trying to get rid off this issue since in a morning.

    Thanks in advance.

  • March 23, 2012 at 1:05 am

    #1463187

    Where are you running the package? BIDS or on the server?

    Did you do the correct mappings in the OLE DB Destination?

    Did you select the correct table in the OLE DB Destination?

    Did you enable logging in the SSIS package?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 23, 2012 at 1:20 am

    #1463198

    It looks like you are running this through bids.

    I would start with the error logging mentioned by Koen.

    I would also through a couple of data viewers into the package. This helps me to determine (visually) where I might be losing the data (as in not getting the data into the expected location).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 23, 2012 at 9:59 pm

    #1463882

    @koen,

    I am using BIDS.

    and also i had set the column mapping in the OLEDB Destination.

    I am looking warning sign that i had pasted below.

    Warning:Validation warning. Data Flow Task: {9E207FB6-BD00-4642-BE4C-D9639BFFE7EE}: Truncation may occur due to inserting data from data flow column "Column 2" with a length of 50 to database column "Acctno" with a length of 15.

    If you have some good thought, please share me.

    Thanking you

  • March 24, 2012 at 12:46 pm

    #1463933

    Truncation may occur due to inserting data from data flow column "Column 2" with a length of 50 to database column "Acctno" with a length of 15.

    -- increase the length of column and try again.

    specially column no2 which mapping to your database table column number 2.

    -- means suppose your database column num 2 accountno varchar(15)

    then increase it to varchar(50) or varchar(100)

    post if still not resolved or any confusion.

    Raj Acharya

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

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