Dec
4
2010

Dec 14 webinar - Loading Spatial Data into SQL Server with FME

I have mentioned SAFE Software before as the most visible provider of tools and components for working with spatial data in Microsoft SQL Server, with or without Integration Services. SAFE recently announced a free 1-hour Webinar on Tuesday, December 14, 2010 - "Loading Spatial Data into SQL Server with FME". More information: Sign up for the Webinar Read more about SAFE Software and SQL Server Here is the description of the Webinar from their Web site: "This free webinar demonstrat... [More]
Oct
20
2010

More affordable spatial data loading for SQL Server

Do you have spatial data stored in ESRI Shapefiles, MapInfo TAB files, MIF/MID files, or CSV files that you have to load into SQL Server? If you do, then this new and more affordable product from SAFE Software may meet your needs. SAFE has quietly released FME Desktop SQL Server Loader Edition, a $500 subset of the full functionality found in their "FME Desktop Microsoft SQL Server Edition" product. Here's the description of this new product from their Web page: "Quickly load data into ... [More]
Aug
11
2010

Running multiple SSIS Foreach Loops in parallel

The Parallel Loop Task, recently released in beta by Cozyroc Software, "can execute multiple iterations of the standard Foreach Loop Container concurrently. In tests, a CPU intensive sequential process when executed in parallel on 4-core machine was executed 3 times faster compared to the sequential." This new task appears in Beta 2 of the Cozyroc package, SSIS+ 1.5. For more information or to try out the Parallel Loop Task... Read the blog post announcing the new task and the new Beta 2 relea... [More]
Aug
11
2010

Running PowerShell tasks from an SSIS task

In an earlier blog post, I noted that there hasn't been much buzz about performing SSIS-related tasks with Windows PowerShell. But what if you want to perform PowerShell tasks with SSIS? A PowerShell Task for SSIS was released recently just for this purpose by /n Software. From their Web site: "The PowerShell SSIS Task is the 'swiss army knife' of SQL Server automation. It can be used to create highly-flexible SQL Server workflow solutions via easily configurable PowerShell scripts. When ... [More]
Jun
16
2010

SSIS with Dynamics CRM: Case study from a large bank

Two years ago, I wrote a short blog post here about using SQL Server Integration Services (SSIS) with Microsoft Dynamics CRM. There are 2 ways that you can work with CRM programmatically: The supported way, through the Web services API that the application exposes The, uh, less supported way, by interacting directly with the database where CRM stores its data And we've got some information for you today on both approaches! First, our feature article, "Uses for SSIS with MSCRM In a Bankin... [More]
Jun
8
2010

New Excel components out in beta from Cozyroc

Yesterday (6/7/2010), Ivan Peev of Cozyroc announced the beta release of version 1.5 of SSIS+, Cozyroc's suite of custom components for SQL Server Integration Services. The new components for Excel in SSIS caught my attention. The announcement summarizes this new release as follows: "The new version includes components for integration with Microsoft Dynamics CRM, enhanced tasks and connections for handling emails, enhanced support of Microsoft Excel workbook files and components for integration wi... [More]
Apr
23
2010

More SSIS and spatial, with an offer from SAFE Software

An offer from SAFE software, "The Spatial ETL Experts" In my recent blog post where I mentioned some components and resources for using SSIS with geospatial data, naturally I mentioned the extensive set of custom components available from SAFE Software. I pointed out that their SSIS integration is only available as part of larger product packages. SAFE contacted me after that blog post, and invited me to share this offer of an extended free evaluation period with SSIS developers: "Developer... [More]
Nov
3
2009

CDC for heterogeneous sources with SSIS, from Attunity and Microsoft

See the press release from yesterday (11/2/2009): Attunity extends its partnership with Microsoft to enable heterogeneous Change Data Capture Some excerpts: The solution, based on Microsoft’s SQL Server Integration Services (SSIS) and Attunity’s low-impact change data capture (CDC) technology, enables efficient and real-time integration of heterogeneous data with significant cost savings. ... The integrated offering of Attunity’s CDC with Microsoft’s SSIS is now available for many... [More]
Sep
23
2009

Updated product: EBCDIC Source component "Lysine" from Amino Software

Patrick & Ben at Amino Software have announced a new version of "Lysine," an Integration Services source component for loading EBCDIC data into the data flow of an SSIS package.   I wouldn't know an EBCDIC if one ran up and bit me, so I'll just quote their announcement: Lysine 1.3 Released We are excited to announce that our planned release for 1.2 was merged with features that had been planned for release in 1.3 at a later date. Due to increased international demand, we put a rush on 1... [More]
Feb
20
2009

Import EBCDIC in SSIS packages with updated Lysine 1.1

You can now import EBCDIC data more reliably in SQL Server Integration Services packages with version 1.1 of "Lysine", just announced by Patrick & Ben at Amino Software. If you work with EBCDIC dta, what's in it for you? "The major benefits of Lysine are two-fold: It saves you from having to write a pre-processor to unpack and convert the binary data. It prevents you from having to pre-process the data saving an extra, and many times costly, trip through the data." Here's the features list from t... [More]