Ray, >>> Is there an easy way to do this? I'm trying to avoid using >>> the command-line route to do this. Seems like that it would >>> be a standard feature of SQL Server 2K to have this built-in.
Here's a method that's worked for me in the past: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS I've used this method to allow users to upload text files, which after uploaded to the database server, I'd call this stored proc to actually run the DTS script. -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247556 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
