Sunday, November 12, 2006

SSIS Presentation Online

I had fun at my latest presentation about using SQL Server Integration Services (SSIS) to about 100 people at Microsoft Canada. We covered the basics including sources and destinations, some transforms and of course the overall architecture of SSIS.

This is a brand new product that happens to ship with a great database engine called SQL Server. I make this comment because it’s important to determine at design time where actions are taking place. Sometimes, it’s better to perform operations within SSIS and other times you should take advantage of the database engine to perform an operation. You can handle both from within SSIS.

Microsoft has recorded the session and posted it online here:


Blogger Zberteoc said...

Hi, I have 2 questions as I am in the process of learning about SSIS but having solid experience with DTS.

1. Is it possible with SSIS to dynamically change the connection property during runtime? I know it is possible with DTS becasue I've used this extensively.

2. Second question is if and how can be parameters be passed to a SSIS package. With DTS I used the feature of passing the connections properties as parameters to a package, that is the sql server name or an excel or csv file path+file name. How is this possible with SSIS?


9:04 AM  
Blogger Val Matison said...

Your questions are related. You simply have to set the right variable at runtime.

To pass parameters to a SSIS package use the /SET option of dtexec.exe.

From books on line:
dtexec /set \package.variables[myvariable].Value;myvalue

The package would have a variable named within it and that’s what you set as a parameter.

You can also make changes via a configuration file if you choose.

To set any connection property or any other property do the following:

From Books On line:
You can determine the value of propertyPath by running the Package Configuration Wizard. The paths for items that you select are displayed on the final Completing the Wizard page, and can be copied and pasted. If you have used the wizard only for this purpose, you can cancel the wizard after you copy the paths.

4:02 PM  

Post a Comment

<< Home