Back to list
Views:   5.7K
Replies:  1

Bulk Insert into Table

Hi All, 

I am reading and capturing an certain information from delimetered. Then I write those data values to another delimeter file as per the table structure.I  used Insert Bulk FileName. 
May you please advise on the following: 
  • Is there any other way to only insert the record at once. Reason being this has introduce an extra step to write the file FTP the file to SQL server. 
  • Also what should i do to to enable SQL to read the file even if it not in the same server as database server. 
  • How do I manage the difference of the tables since some tables has 6 other have 9 columns.

  • Thank you. 
Mike Maseko, Aug 24, 2014
Reply 1
I suggest you to choose SSIS Package because SSIS is meant for such tasks. Well, for accessing file from other/remote server , you can use .NET Impersonation. It gives you a "Run As" capability in your code. If you Google you will find  cut & paste code that you use with SSIS script.Using .NET bilkupload/Bulkcopy is not bad but using SSIS is right choice.

In SSIS " Script Task" you can write simple logic for column differences and make it work"

Best Regards
Shabir Hakim, Dec 20, 2014
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.