Can I set path as parameters in SSIS packages?

  • I need to set path parameters for my SSIS packages to be able to have a flexible data source.

  • There is a connectionstring property you can set for your datasources in SSIS. You can use a variable in the expression builder for the connectionstring property.

  • hi,

    There is no "ConnectionString" in the Property Expression Editor drop-down list. what am I going to do?:)

  • attach below is the property expression editor screen shot. there is no "ConnectionString" in the drop down list.

  • What type of data source (Connection Manager) are you using? All of the connection managers allow you to set their properties with expressions, but unless you need to dynamically change them during package execution, package configurations is the correct way to do this.

  • Michael Earl (6/3/2008)


    What type of data source (Connection Manager) are you using? All of the connection managers allow you to set their properties with expressions, but unless you need to dynamically change them during package execution, package configurations is the correct way to do this.

    We always use package configurations for Database Connection Managers. We use a configuration table in which we store all the different database connections.

    However, we do use expressions to set the ConnectionString for file connection managers. We create a path variable were the files reside, and produce the connectionString using an expression to add the path and the filename together.

  • This is what I run from DOS prompt:

    "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /f {dtsx_file_name} /CONNECTION DestinationConnectionOLEDB;"trusted_connection=yes;Database={db_name};Server={server_name};Provider=SQLNCLI;" /CONNECTION SourceConnectionFlatFile;"{path\flat_file}"

    Replace {} with proper names.

    The name of connections matches connections in SSIS package.

  • you can use the config file to change the environment varialbles, such as connection string.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply