DTS package has invalid data in destination column

Posted on 2005-04-28
Last Modified: 2010-03-19
When I preview my selection query all the records are fine and execute with no errors.

When I hit the test button in my activex script it executes with no problems and returns data in the window without error.

If I exit back to the designer workspace and right click on the package to execute it I get an error that there is invalid data

being passed to a destination column.

Any sugestions where to look or a specific action to take?


Question by:dprice7
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>Any sugestions where to look or a specific action to take?<<
    The preview is only selecting the first few rows.  Evidently the problem is beyond that.  Without know the specific nature of the query or error message it is a little difficult to contribute anthing more than that.
    LVL 30

    Expert Comment

    .. so prune your import file down and import bits and pieces of it till you find the offending row(s).
    LVL 11

    Expert Comment

    The test and preview only do a samll number of records not all of them. You might find that in later records you are trying to put letters into integer fields or something like that. Check the number of recs that are succesful and then try and track the offending record

    LVL 75

    Accepted Solution

    I can take credit for this question.

    Author Comment

    Sorry everybody,

    I go tied up on other things.

    Will be returning to this next week.

    If I need to I will start a new question.



    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now