InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 17:49:37 GMT20http://www.sqlservercentral.com/Forums/Topic170989-221-1.aspx<P> </P><P>Its actually more like...</P><P> </P><P>$Connection-&gt;{ConnectionProperties}-&gt;{"File Type"} = 1;</P><P>$Connection-&gt;{ConnectionProperties}-&gt;{"Skip Rows"} = 0;</P><P>$Connection-&gt;{ConnectionProperties}-&gt;{"Text Qualifier"} = """";</P><P>But yeah, you get the general idea...</P>Wed, 06 Apr 2005 11:41:00 GMTJeremy Brownhttp://www.sqlservercentral.com/Forums/Topic170989-221-1.aspxGreat Article, have been looking for some more info on Perl DTS packages lately. One question for you, do you set the connection properties like this?$Connection->ConnectionProperties("File Type") = 1;$Connection->ConnectionProperties("Skip Rows") = 0;$Connection->ConnectionProperties("Text Qualifier") = """";In VBS its connection.ConnectionProperties("File Type") = 1so from what I can tell this looks correctTue, 05 Apr 2005 11:33:00 GMTRich Watershttp://www.sqlservercentral.com/Forums/Topic170989-221-1.aspx<P>Just got a good question in an EMail about ActivePerl licensing. ActivePerl is a free download from ActiveState and is provided for both commercial and non-commercial use. </P><P> </P><P>See <A href="http://aspn.activestate.com/ASPN/docs/ActivePerl/EULA-Community_License.txt">http://aspn.activestate.com/ASPN/docs/ActivePerl/EULA-Community_License.txt</A> for licensing details on the ActivePerl package itself.</P>Tue, 05 Apr 2005 08:59:00 GMTJeremy Brownhttp://www.sqlservercentral.com/Forums/Topic170989-221-1.aspx<P>Thanks guys, I really appreciate it.</P><P>Also, sorry if you get a "side scroller". I tend to write string concatinations on one line in my code. </P><P>I'll try to watch out for this in the future.</P>Tue, 05 Apr 2005 07:49:00 GMTJeremy Brownhttp://www.sqlservercentral.com/Forums/Topic170989-221-1.aspxJeremy, good job on the article! The "2 AM" test is the highest of all tests!! If it passes, it must be good!!!Tue, 05 Apr 2005 07:11:00 GMTdbamarkhttp://www.sqlservercentral.com/Forums/Topic170989-221-1.aspxThanks. I really enjoyed writing this article. I have a few good ideas on other articles I would like to write, so this may be the first in a "series".Mon, 04 Apr 2005 12:10:00 GMTJeremy Brownhttp://www.sqlservercentral.com/Forums/Topic170989-221-1.aspxCongrats, Jeremy! on being published!Sat, 02 Apr 2005 06:52:00 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic170989-221-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/jbrown/flexibledtspackageswithperl.asp">http://www.sqlservercentral.com/columnists/jbrown/flexibledtspackageswithperl.asp</A>Wed, 30 Mar 2005 14:25:00 GMTJeremy Brown