Our last Follow Friday, at the end of May, was mister Tim Mitchell of the NTSSUG board. I’m apparently following a theme this summer, for today’s Follow Friday is NTSSUG board candidate Ryan Adams (blog, Twitter)! Ryan’s a SQL Server DBA who has been at the same company for…twelve years?? I don’t even know what you […]
Piggybacking tangentially off of Tim Mitchell’s (blog, Twitter) SSC editorial Turn a Bad Job into a Good Experience…yesterday I got some user questions about the department’s new password policy. The policy is admittedly complex, especially considering half the place had been using the “kid’s name and ‘password’ scribbled on a post-it” philosophy of security. And, […]
This has come up several times in the course of the last TWO jobs, so I’ll put it here for my reference (and yours). To use a dBASE file as a source in SSIS (and I know you want to), in your new connection manager: Select Native OLE DB\Microsoft Jet 4.0 OLE DB Provider . […]