Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-07-26 : 12:46:38
|
| Hi,I hav eplaced an expression for the flat file connection as below@[User::FileDirectory] + @[User::FileName]This is supposed to be used instead of the ConnectionString property of the flat file connection.You can see that I have created two variables.The variable @[User::FileDirectory] is set to the directory. i.e. I have hardcoded the path to it and assigned it to this variable.The variable @[User::FileName] is picked up automatically.The question is:When I go to the properties of the flat file connection, I delete the value inside the connectionstring property becuase there is now the expression which is set to the connectionstring.But when I come back to this property then I am not sure why the connectionstring property gets populated with the directory that I hardcoded to the variable.Many thanks |
|
|
|
|
|
connectionstring gets populated unwillingly