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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 16, 2014 9:48 AM
Points: 193, Visits: 293
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jbrown/flexibledtspackageswithperl.asp


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


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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 04, 2005 12:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 16, 2014 9:48 AM
Points: 193, Visits: 293
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 05, 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 05, 2005 7:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 16, 2014 9:48 AM
Points: 193, Visits: 293

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 05, 2005 8:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 16, 2014 9:48 AM
Points: 193, Visits: 293

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 05, 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 06, 2005 11:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 16, 2014 9:48 AM
Points: 193, Visits: 293

 

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