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)
 cmd dtexec with file name parameter

Author  Topic 

shilpash
Posting Yak Master

103 Posts

Posted - 2014-07-29 : 19:01:47
Hi all,

I am loading the excel filename to the database.I also have config files where it takes the variable like file path,filename,and other connection strings.I was wondering if I use the dtexec command line utility with the config file and along with the filename as a parameter,does that overwrite the value in config files.Or whats the best solution for this as I am trying to pass the file name as a parameter along with config file in the command line.

Thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-29 : 19:31:02
http://stackoverflow.com/questions/12455565/how-do-i-make-ssis-dtexec-use-an-alternate-config-file

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -