March 13, 2007 at 3:28 pm
I am looking to promote a SSIS package to various servers. The name and location of the text Log File setup in BIDS for the package is expected to change. The SSIS package will be executed through a 3rd party scheduler as a batch command file.
I am trying to use this command to change the location
dtexec /F DASD_Database_List_export.dtsx /L "DTS.LogProviderTextFile.1;E:\Log.txt"
For which I am getting this error:
Description: The connection manager "E:\log.txt" is not found. A component failed to find the connection manager in the Connections collection.
I tried Set command approach from
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72104
It did not work.
Has anyone been successful in using the dtexec log parameter DTS.LogProviderTextFile.1? Could you post how you got it to work? Thanks
David Bird
March 16, 2007 at 8:00 am
This was removed by the editor as SPAM
June 6, 2007 at 1:49 pm
I am having the same issue. Anyone know the answer?
July 28, 2011 at 10:02 am
Try below:
DTEXEC /FILE "pkgDirecotry\pkgName.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "\Package.Variables[variableName].Properties[Value]";variableValue /REPORTING EWCDI > .\Logs\pkgName_%YYYYMMDD%_%HHMM%.log
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply