Thanks Anthony.Green

BCP supports CSV Load when all the destination fields in the DB is of character type. That's where the challenge is.

I was using FULL and Bulk Logged and later...

Valid point. I have already removed batch processing.

I wanted result of all the hashes. But it can be in batches as well. Not necessarily in one shot.

Thanks.

This was to lookup for some information only. I got it done using a stored procedure and TVP. It's working fine. Thanks for your time in replying.

Yeah. Make sense. This one is creating lot of confusion.. Will see to it.

Thanks BTW 🙂

Thanks a lot for the quick reply.

My datetime is stored in UTC format.

Eg. 1299781800000 ( GMT: Thu, 10 Mar 2011 18:30:00 GMT, Your time zone: 11/3/2011 00:00:00 GMT+5.5)

Roughly like ;

[font="Courier New"]stringstring2string3string4string5intint6anyType

Orders.xml_KA-ORDRS-21-Jan-2013

OrderDetails.bin_KJ-18-Mar-2013-WEGradedWarehouseEntryTSWearhouseEntryTS25-Jul-12 8:24:35 PM2

OrderDetails.bin_KJ-18-Mar-2013-WEGradedWarehouse TypeClosed and RoofedType A143

OrderDetails.bin_KJ-18-Mar-2013-WEGradedDLCRDLCR000085401

OrderDetails.bin_KJ-18-Mar-2013-WEGradedCandF_SectionForwarding SectionsPEandPaperCorrugated10

OrderDetails.bin_KJ-18-Mar-2013-WEGradedPackingAndMovementPackingAndMovement5 X 6 Feet , With godowns10

PendingOrders.bin_KA-UE-04-Feb-2013WearhouseEntryTSWearhouseEntryTS25-Jan-13 8:10:15 PM20

PendingOrders.bin_KA-UE-04-Feb-2013Warehouse TypeWarehouse Typev8.010

PendingOrders.bin_KA-UE-04-Feb-2013DLCRDLCR0000854010

PendingOrders.bin_KA-UE-04-Feb-2013Forwarding SectionsForwarding SectionsElectricalCarriage10

PendingOrders.bin_KA-UE-04-Feb-2013PackingAndMovementPackingAndMovement5 X 6 Feet , Without godowns10

PendingOrders.bin_KA-UE-04-Feb-2013QuantityTransferQuantityTransferyes10

PendingOrders.bin_KA-UE-04-Feb-2013StoreIDStoreIDFootware10

PendingOrders.bin_KA-UE-04-Feb-2013SodexoSodexoSodexo10

PendingOrders.bin_KA-UE-04-Feb-2013AC HeadAC...

But how can I pick the fields in this way ?

You are right. This structure is risky. But fortunately , this lies in the old DB from which we are migrating data to a new beautiful one 🙂

Thanks a ton everyone.. I am jumping to the pool. Lot of things pending.. Thanks again... 🙂

Thanks a lot dwain.. It's working 🙂

You're missing a couple of key pieces of information here.

1. What is your backup plan? How long must a full backup be available on disk and how often will you...

Thanks 🙂

Yeah. Off course..

I am using SQL 2012 Enterprise Edition ( Running on Windows 7 Professional Version with SP1 )

We need both versions in sync

Hi.. Thanks every one ... I have resolved this.

I have dynamically created procedures for each table which meets the criteria, rather than running dynamic SQL to delete the data. Then...