DTS was what I was trying to remember. The data will be some arbitrary fields that will have to be transformed some so programmatic logic will be needed. Thanks
> Use Bulk Insert from stored procedure or you can use DTS package but use > Bulk Insert is more straight forward process > > Snapple > ----- Original Message ----- > From: "Michael Dinowitz" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Monday, November 10, 2003 11:22 AM > Subject: Upload help > > > > I've got a tab delimited file of 20,000 rows that I need to get into a DB. > I > > also need to transform some of the data as it comes in. I remember doing > this > > many years ago, but the exact SQL methodology escapes me. > > Does anyone have the initials or reference to what I need? Thanks > > > > -- > > Michael Dinowitz > > Finding technical solutions to the problems you didn't know you had yet > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1724 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
