All,

I am trying to load a .sql file dynamically in an SSIS Execute SQL
Task. There doesn't seem to be a way to set the FileConnection
property when you select "File Connection" as your "SQLSourceType".
Does anyone know how to set this property dynamically through an
expression or otherwise? (I don't want to staically set the
filename/path using a "New File Connection.")

Thanks

David

Hello David,

What about the file connection do you want to set? The location? this would
be done on the connection manager itself and not the ExecuteSQL Task (ConnectionString
property)

Allan

Allan,

Thanks. That is what I needed.


Allan Mitchell wrote: