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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Passing Dynamic Variables in SQLAgent

Author  Topic 

eman0827
Starting Member

4 Posts

Posted - 2011-03-14 : 14:40:50
Is it possible to pass dynamic variables using SQLAgent?

For example, using dtexec in a stored procedure:

/SET \Package.Variables[User::fileName].Properties[Value];"' + @fileName +

Is it possible in SQLAgent to pass @filename with a dynamic value during runtime?

Thanks!
   

- Advertisement -