how to copy large text from one database into another

  • My SSIS package failed when transfering data from one table to another because there is a Text column in the tables and the size of Data in the source table for that text field is very large (i.e. two lines of text). What is the best mechanism for solving this problem in the BIDS.

    I eventuallly ended up copying one row at a time from one table to the other, however, I want to save the package so that people who may use it in the future don't have to do what I did?

    Faye

  • Do you need to copy each time from one table to another? If once then you might create table by writing SELECT INTO from one table to another and then run copy. It will work after wards for all transcation. So it depends that you need only one time or for each time. u can use SELECT into only once as once it will create table and when you run it again; it will fail.

    First run SELECT INTO query. - Create new table. (if u need existing table then change the datatype of existing table and run second step)

    Second step is run insert into query.

    I hope it helps.

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

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