June 2, 2008 at 7:23 pm
I need to set path parameters for my SSIS packages to be able to have a flexible data source.
June 2, 2008 at 9:17 pm
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.
June 3, 2008 at 12:39 am
hi,
There is no "ConnectionString" in the Property Expression Editor drop-down list. what am I going to do?:)
June 3, 2008 at 1:13 am
attach below is the property expression editor screen shot. there is no "ConnectionString" in the drop down list.
June 3, 2008 at 5:04 am
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.
June 3, 2008 at 9:18 am
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.
June 5, 2008 at 1:28 am
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.
March 19, 2009 at 9:25 am
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