To my disappointment, the bcp utility is logged, appears to be fully. The -h switch with "tablock" seems to greatly improve performance; full logging appears to be minimal.

Happy Memorial Day! Be careful out there camping...

For SQL 2016 none of the above worked; I right-clicked the connection manager > paramaterize, and that solved all of the issues trying to use both the connectionstring and ExcelFilePath...

So did you settle on the 3rd party drivers, or figure out the connection. I'm using the Sybase.AdoNet2.AseClient and Destination and it's working ok.

Can you provide an example?

I think I know what you're trying to say, though. Like this?

SELECT NULLIF(CAST('1/1/1900' AS datetime),'')

Hi,

Have you researched your go-to for replacing this feature? I...

Jonathan Kehayias (12/24/2010)

---

ab5sr (12/23/2010)

---

Interesting post, Tim, and timely, just about the time that I was "debunked" and "called out" in a "game-on" fashion just today. I appreciate the reply,...

Interesting post, Tim, and timely, just about the time that I was "debunked" and "called out" in a "game-on" fashion just today. I appreciate the reply, Jonathan, but 1)...

Yep you have to throw it in the GAC

Lee

Forget all of that com stuff and interop stuff...search Google for c# assemblies for SSIS or building custom assemblies for SSIS. I have a post on my blog that...

Used to love to write extended stored procedures. They're located in the binn folder, and the others are correct - they are either c or c++ .dlls built using...

See if this helps any...

http://databases.aspfaq.com/database/how-do-i-use-a-select-list-alias-in-the-where-or-group-by-clause.html

Like this maybe?

http://www.texastoo.com/post/2008/12/17/Create-a-custom-assembly-in-SSIS.aspx

Can you use a * either side of your expression?

Go back and do a Run As login with the user that you originally set...