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 2012 Forums
 SSIS and Import/Export (2012)
 SSIS variable to connect to remote server

Author  Topic 

yardy78
Starting Member

3 Posts

Posted - 2014-10-13 : 20:59:43
i created a variable Foldername with the folllowing expression

"/QWSERC(" + "\\"+"c:"+"\\"+"download" + "\\"+(DT_STR,4,1252)YEAR( DATEADD( "dd", -1, getdate() )) +"-"+ (DT_STR,4,1252)MONTH( DATEADD( "dd", -1, getdate() )) + "-"+(DT_STR,4,1252)DAY( DATEADD( "dd",0 , getdate() ))+"\\"+"*.*"

the location is /QWSERC(the server name c:\download\2014-10-13 the it will pick up all log files *.log

i then open my MULTIFILE connection manager properties then in expression i call the variable [user::foldername] this way it picks ups the files daily in the various dated folders. The process runs however it does not picky up my log files even though it has a green mark for success. When i remove the expression and manually point my MULTIFILE connect to the location and select all the files and run it , that works perfectly, i dont want to manaually do this i want programatically do so this the variable

PLEASE ASSIST
   

- Advertisement -