Category: SSIS

Tip: Connect to dBASE files in SSIS

Post author By Jen McCown
Post date August 12, 2010
Categories In NonSQL, SQL Saturday, sql server, sqlserverpedia-syndication, SSC, SSIS, Tips
1 Comment on Tip: Connect to dBASE files in SSIS

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 . […]

SSIS Ground Zero at NTSSUG – #6

Post author By Jen McCown
Post date July 16, 2010
Categories In News-ish, NTSSUG, sql server, SQLPASS, sqlserverpedia-syndication, SSIS
1 Comment on SSIS Ground Zero at NTSSUG – #6

Sean is insane, but he’s good enough to get away with it. By that I mean this: He’s been teaching this monthly SSIS class at the NTSSUG meetings for six months, and he’s waiting later and later to figure out what he’s going to teach. Last month, he was busy enough that he had to […]

SSIS: Deploy Packages, Part 1

Post author By Jen McCown
Post date September 9, 2009
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, SSIS, Tips

This is the companion text to the video SSIS: Deploy Packages. This will be a two- or three-part series, I think. There are two ways to deploy SIS packages, and the difference becomes important when you have a lot of packages. The first way is just to individually deploy a package directly to SQL (or […]