472,342 Members | 1,427 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

need to open text file for datapump from activex script

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


Oct 5 '06 #1
0 1665

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Piedro | last post by:
Hi y'all I'm having some trouble with the following script I use in a dts-package. I use it to automatically import a dat-file of which the name...
by: Philipp | last post by:
Hello I would like to include text from an external file in my html file. This is normally done with <object> or <iframe> but in this case the...
by: CW | last post by:
I wrote an HTML based chat application. The front end is built entirely on HTML + javascript. Essentially, I have a hidden frame that's refreshed...
by: Jackson Yap | last post by:
can someone kind enough to help me look at the attached html and js file? Why is it that the javascript menu could not work at www.apchosting.net...
by: Frank | last post by:
I am attempting to convert an asp file to a asp.net file using C#. The original file has an ActiveX control which is contained in a cab file. ...
by: Frank | last post by:
Short Version of Question: Can anyone provide an example of how I should embed the ActiveX and license, and then use it in a function?
by: BJ | last post by:
Problem: How can I code up a client side process to detect if the network is available? Synopsis: I am writing ASP.NET input forms for a...
by: SimplySuzy | last post by:
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...
by: mike | last post by:
I help manage a large web site, one that has over 600 html pages... It's a reference site for ham radio folks and as an example, one page indexes...
by: lwhite | last post by:
MS SQL 2000 sp4 on WinXp Pro SP2 I am very new to this so please let me know what I can do to make it easier for you to understand the problem. ...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.