Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • I would actually look at this other Pinal Dave article (blog.sqlauthority.com/2013/04/18/… ) that talks about using SSIS for this sort of thing. It will give you the flexibility you need and will give you error handling and really you can essentially have it do whatever you want. And it is fast. Certainly worth looking at if you are comfortable with checking out that environment. Commented Sep 1, 2015 at 20:31
  • And just substitute his SalesForce destination for a SQL Server one. The same principles will work. Commented Sep 1, 2015 at 20:32
  • BULK INSERT into a temporary table, which you can trash if something seems wrong. Then BULK INSERT from the temp table into the target table when everything is all right. Commented Sep 2, 2015 at 2:03