Home Forums Data Warehousing Integration Services Connection String Expression Syntax RE: Connection String Expression Syntax
Koen Verbeeck
SSC Guru
Points: 259085
More actions
October 22, 2013 at 1:18 pm
#1660663
Try this:
"C:\\Folder1\\Folder2\\" + @[User::Site] + ".MDB"
I assume @[User::Site] is a string variable?
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP