Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Flexible DTS Packages with Perl Expand / Collapse
Author
Message
Posted Wednesday, March 30, 2005 2:25 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jbrown/flexibledtspackageswithperl.asp


Post #170989
Posted Saturday, April 2, 2005 6:52 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
Congrats, Jeremy! on being published!


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #171687
Posted Monday, April 4, 2005 12:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307
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".


Post #171900
Posted Tuesday, April 5, 2005 7:11 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 6:59 AM
Points: 692, 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!!!


Post #172042
Posted Tuesday, April 5, 2005 7:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307

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.




Post #172058
Posted Tuesday, April 5, 2005 8:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307

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.




Post #172106
Posted Tuesday, April 5, 2005 11:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 27, 2005 7:27 AM
Points: 44, 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
Post #172171
Posted Wednesday, April 6, 2005 11:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307

 

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




Post #172521
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse