Flexible DTS Packages with Perl

Question

Post reply

Flexible DTS Packages with Perl

Jeremy Brown

SSCarpal Tunnel

Points: 4223
More actions
March 30, 2005 at 2:25 pm

#163089

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jbrown/flexibledtspackageswithperl.asp

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Congrats, Jeremy! on being published!

K. Brian Kelley
@kbriankelley

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 2

Thanks. 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".

dbamark SSCommitted Points: 1694 More actions · Answer 3

Jeremy, good job on the article! The "2 AM" test is the highest of all tests!! If it passes, it must be good!!!

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 4

Thanks guys, I really appreciate it.

Also, sorry if you get a "side scroller". I tend to write string concatinations on one line in my code.

I'll try to watch out for this in the future.

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 5

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.

See http://aspn.activestate.com/ASPN/docs/ActivePerl/EULA-Community_License.txt for licensing details on the ActivePerl package itself.

Rich Waters SSC Journeyman Points: 94 More actions · Answer 6

Great 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") = 1

so from what I can tell this looks correct

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 7

Its actually more like...

$Connection->{ConnectionProperties}->{"File Type"} = 1;

$Connection->{ConnectionProperties}->{"Skip Rows"} = 0;

$Connection->{ConnectionProperties}->{"Text Qualifier"} = """";

But yeah, you get the general idea...