SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Flexible DTS Packages with Perl


Flexible DTS Packages with Perl

Author
Message
Jeremy Brown
Jeremy Brown
SSC Eights!
SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)

Group: General Forum Members
Points: 813 Visits: 311
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jbrown/flexibledtspackageswithperl.asp



K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (24K reputation)

Group: Moderators
Points: 24270 Visits: 1917
Congrats, Jeremy! on being published!

K. Brian Kelley
@‌kbriankelley
Jeremy Brown
Jeremy Brown
SSC Eights!
SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)

Group: General Forum Members
Points: 813 Visits: 311
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
dbamark
SSC Eights!
SSC Eights! (832 reputation)SSC Eights! (832 reputation)SSC Eights! (832 reputation)SSC Eights! (832 reputation)SSC Eights! (832 reputation)SSC Eights! (832 reputation)SSC Eights! (832 reputation)SSC Eights! (832 reputation)

Group: General Forum Members
Points: 832 Visits: 53
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
Jeremy Brown
SSC Eights!
SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)

Group: General Forum Members
Points: 813 Visits: 311

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
Jeremy Brown
SSC Eights!
SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)

Group: General Forum Members
Points: 813 Visits: 311

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
Rich Waters
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 1
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
Jeremy Brown
SSC Eights!
SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)SSC Eights! (813 reputation)

Group: General Forum Members
Points: 813 Visits: 311

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





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search