Post reply

Adding new columns to SSIS package

  • August 2, 2007 at 11:21 am

    #174669

    We have an SSIS package that inserts data from a .csv file to a table.  We've recently added two new fields in both .csv file and the table and I've updated that section of the package and redeployed it.  Here's an example of the old and new data:

    Old data

    col1, col2, col3

    a, b, 3

    New data

    cole, col2, colA, colB, col3

    a, b, 1, 1, 3

    The problem that I'm running into is that, in the table, colA and colB are not being populated and the values for those colums are prefixing the value for col3.  Using the above example colA is null, colB is null and col3 is 113.

    I've looked at the package and the external and output columns are matched up correctly.  We also have a DTS package that's running on a SQL Server 2000 box that is running the same process and it's working correctly.

    Has anyone seen this problem?  I'd greatly appreciate any help.

     

    Thanks,

    Lori

  • August 3, 2007 at 3:04 am

    #724420

    Have you remapped the source manager?

    If you use a data viewer, what columns exist in it and what are the values in the rows?

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 3, 2007 at 7:12 am

    #724487

    Thanks for your respnse.  The column mappings look correct, but it's difficult to see the values because the name of the data file is dynamically generated as needed.  I use a variable to represent the name of the file to be loaded.

    Thanks,

    Lori

Viewing 3 posts - 1 through 2 (of 2 total)

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