Using Powerhsell or SQLCMD for Bulk Insert of CVS, TXT files SQL 2008 / R2 RRS feed

  • General discussion

  • If you plan to import Data with Powershellscripts or sqlcmd be aware of using impersonation. Therefore you need the correspoinding Service Prinzipal Name for your SQL Server Account or Machineaccount and the option of delegation (set in AD Domain & User - on the account properties delegaton) otherwise the account of your SQL Server Service will be used for the file access. Further information's about bulk insert and using powershell or sqlcmd, e.g. you will find at: http://msdn.microsoft.com/en-us/library/ms175915.aspx
    Tuesday, October 11, 2011 2:03 PM