hi frnd i have one SQL Server Table containing 936784521 Records since 2003, now i want to import data > 2007 to different SQL Server Database, for this i i want BCP using SSIS Package , So please can any one let me know the ALL POSSIBLE WAYS using which i can do this BCP in SSIS Package. willing for your kind responce. Thanks, AmiteshRegards, Shanu

Why BCP if you use SSIS, why not copy directly to the different database?

I am agree with Christa, you can use SSIS data flow task and use oledb source pointing to source db, and use oledb destination pointing to the destination db, data transfer will ran in-memory, why you want to use csv as staging?! also you can use simple Import/Export wizard for this simple operationhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com

hi Christa / Reza, thanks for your response, i want to transfer huge amount of data from one server to another and i think Data Flow Task is more expensive then BCPRegards, Shanu

if both source and destination are sql server, and they are on same server, or they are linked together, t-sql statements will perform better than Data flow or BCP. for example: insert into .... select .. from ...http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

also you can boost SSIS Data flow performance, this is good article: http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/http://www.rad.pasfu.com My Submitted sessions at sqlbits.com