Tuesday, March 31, 2015

Issues with Bulk insert in SQL

Newbie here


I have some flat files which I am uploading via the Bulk insert functions. All, except one, went fine.


The one with the issue, I decided to have a staging table whereby all the fields are varchar(50). The input file does have some dates and floats.


The problem I am now facing is to upload from the staging table to the final destination table, whilst converting the dates & floats back as should be.


Any quick and easy solution?


Kind regards


Ash



No comments:

Post a Comment