SSIS – Passing Variables to SQL Scripts

by Charles Tournear, Senior Consultant, MCT, MCSE, MCSD, MCDBA, CRCP

When using an “Execute SQL Task” you may wish to pass data into the query similar to passing parameters into a stored procedure at run time. To pass data to a script we need to create variables. We can then use the variables as the SQL script or to pass data into a SQL script.

Read the full article...

Adding Excel to the New Menu of a Document Library

by Michael C Mullin, Consultant, MCAD, CRCP, MCTS

This article discusses how to have multiple document types listed on the New menu of a document library. We will walk through a detailed description, including screen shots, of how to list Excel on the New menu, although the technique can be used with any document type.

Read the full article...

Business Objects XI 3.0: Product/Curriculum Review

by Troy D. Gottfried, Senior Consultant and Instructor, BECP, CRCP, MCP

As many of you know, Business Objects Enterprise XI 3.0 has been released, along with its supporting cast of applications. Whenever new products, and new versions of products, are released by Business Objects (now owned by SAP), a series of new curricula is also released. As soon as I can get my hands on the newest version, I dive into the product and all supporting documentation in order to understand what has changed, what has stayed the same, and what new features are offered.

Read the full article...

Change, Change, Change

by Aaron Zechman, MCSE, BOCP – CR on XI, CR 2008

Na, na, na, na, na, na, na, na, hey, hey, hey goodbye.. Now you might ask what exactly I am saying goodbye to and it affects everyone who uses Crystal Reports. Well, it is the Business Objects Knowledgebase that I am bidding farewell. What? Where are we going to find answers to questions we might have? No need to fret.

Read the full article...