Hi,
1 Is it Bcp supported in Sql server 2005?
2 Instead of using BCP, Is there any other alternative options in 2005
Thanks
Altaf Nizamuddin
Here is the how to technet article on the T-SQL Bulk Copy Utility for 2005 (which can be used through a execute sql task):
http://msdn2.microsoft.com/en-us/library/ms162802.aspx
Also, check your control flow items for "Bulk Insert Task" item, which will copy the data from flat file to table (although it has been stated that this may be depricated in a future version and is mainly in this version for compatibility between dts and ssis)
Note that using the sql server destination adapter in the data flow you will have comparable performance to the bulk insert task with more flexibility. This is owing to the fact that the sql server destination adapter uses the same interface into sql server as the bulk insert task. You MUST be in the sysadmin or bulkadmin groups to run either SQL Server Destination Adapter or Bulk Insert Task.
|||Thanks EWishdahl
没有评论:
发表评论