469,934 Members | 1,974 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

need to open text file for datapump from activex script

Help
I am trying to open a text file that I am naming dynamically through
global variables in a dts package. When I print the file name to the
screen, it is correct. When I use the dts package itself with this file
name it opens only when I click on the elipsis, click on the file and
click open.
I have tried this with and without the text extension.
I am trying a workaround by setting the properties of the text file in
code and opening it this way but I don't have the correct syntax.
Can anyone help?
Set oConn = DTSGlobalVariables.Parent.Connections("Mail Import")
oConn.DataSource = sFileName
oConn.Properties.FileType = "ANSI"
oConn.DataSource.Properties.RowDelimiter = "{CR}{LF}"
oConn.DataSource.Properties.TextQualifier = "<none>"
oConn.DataSource.Properties.FirstRowHasColumnNames = 1
oConn.DataSource.Properties.ColumnDelimiter = 1

thanks
Suzy

Oct 5 '06 #1
0 1606

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Piedro | last post: by
4 posts views Thread by Philipp | last post: by
2 posts views Thread by Jackson Yap | last post: by
1 post views Thread by Frank | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.