Thanks to help from here i can use the folliing axtive x code to dynamicly
set the source filename

Dim Oconn
Set oPkg = DTSGlobalVariables.Parent
Set Oconn = DTSGlobalVariables.Parent.Connections("Text File (Source)
Copy")
OConn.DataSource = DTSGlobalVariables("gv_FileFullName").Value

' I have tried adding this but it doesnt seem to work .. any idea's
OConn.Skip Rows = 10

You can see what properties a DTS Connection has in Books Online, and Skip
Rows is not one, as this is on the underlying connection provider. Fully
implemented properties cannot have spaces in their names either.

Connection object
"mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\dt
sprog.chm::/dtspothobj_6eyc.htm"

Try this-

Dim oConn
Set oConn = DTSGlobalVariables.Parent.Connections("Text File (Source)")
oConn.ConnectionProperties("Skip Rows").Value = 9


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Peter Newman" <PeterNewman (AT) discussions (DOT) microsoft.com> wrote