Thu 16 Apr 2009
I just wanted to help dispell the rumors that some have about the Bulk Insert task in SSIS. This task is NOT marked for deprecation. It will be around for quite a while. At this time, rest assured that if you are using the Bulk Insert task, you will be supported for quite some time.
May 20th, 2009 at 1:49 pm
Thank goodness – I used Bulk Insert all over the place and I love it.
June 7th, 2009 at 11:35 pm
Transfer SQL object task gives fatal error
The Validate method on the task failed, and returned error code 0×80131501 (Failed to connect to server infpu05406.). The Validate method must succeed and indicate the result using an “out” parameter.
Any help or pointer. Tries a lot of things but it does not work.
July 22nd, 2009 at 2:44 pm
what’s the difference btw Bulk Insert in T-SQL and Bulk Insert Task on SSIS ??? performance is better?? or its just different way to Bulk data??
Regards,
August 19th, 2009 at 1:55 pm
The answer to Lily’s question is below:
The Bulk Insert Task can be used to insert data from
a text file or a flat file into a SQL Server Table in the same way the BULK INSERT statement or BCP.EXE command line tool is used.