Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 2131

COM based database access API bundled into Windows by Microsoft.

3 votes

Import Excel Table to SQL Server - with date column

Internally, Excel stores dates as an integer value. I've run into this before and solved it both in SSIS and straight TSQL https://stackoverflow.com/questions/9085928/reading-in-date-column-if-first …
billinkc's user avatar
  • 16k
3 votes

SSIS OLEDB Command not firing triggers

I was not able to reproduce your error (although I only tested with one table in the mix). An OLE DB Destination has the ability to disable trigger and other check constraints when it loads but the O …
billinkc's user avatar
  • 16k