Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 File System commands from SSIS Script Task

Author  Topic 

lbaldacci
Starting Member

1 Post

Posted - 2009-04-21 : 07:29:30
Hi,

can anyone address me to some good script example or basic guide to manipulate folders, files (like create, copy, delete) from a .NET script?

My ultimate goal is to get some data from a SQL table and create a set of xls file (where name and data in it come from such SQL tables).

Any help will be much appreciated.
LB

tmitch
Yak Posting Veteran

60 Posts

Posted - 2009-04-22 : 21:47:30
You'll want to take a look at the System.IO namespace. It has all of the functionality you mentioned and then some. The File object will allow you copy, move, or delete a file. The Directory object has similar functionality.

Take a look at the pages on MDSN that discuss System.IO. If you run into a specific problem, post back here and I'll be glad to assist.

hth,
Tim

---------------------

Tim Mitchell
www.BucketOfBits.com
Go to Top of Page
   

- Advertisement -