I'm using a VERY simple script that works to change my flat file connection path but can't get the syntax to set the DataRowsToSkip property of the connection. To change the path I'm using:
Dts.Connections("ReturnDataFile").ConnectionString = Dts.Variables("FullPath").Value.ToString
How would I change the datarowstoskip for an integer variable HEADR:
Dts.Connections("ReturnDataFile").Properties("DataRowsToSkip") = Dts.Variables("HEADR").Value
?????????????
Thanks,
Joe B