I would take the advice of Phill (no dis-resept to the other suggestions - but why re-invent the wheel). The site Phill recommends has plenty of samples to get you...

I have been using it at work for about a year now and I have been happy with the results. It has allowed me to schedule backups of sturctured files...

Allan,

Take a look at this site - some good examples using variables.

http://www.sqldts.com/default.aspx?107

Darrell

Matthew,

It certainly sounds like a permissions issue to me. A good site for you to check out on DTS would be http://www.sqldts.com/

Good luck,

Darrell

If you have access to .Net dev tools you can also take advantage of the FileSystemWatcher - this would allow you to perform your tasks as each file is saved/moved...

Ilan,

Take a look at BOL for Create Function. Between that and Seth's suggestion you should be well on your way.

Have you considered DTS? It does a nice job with CSV imports.

Darrell

OK,

Let's try that again! 🙂

http://www.sqldts.com/

Not sure if this is "easy" or not but..

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/_pluslang_ascii_character_codes_chart_1.asp

The picture did not come through but..

Take a look at this site and see if it helps you any.

Darrell

If you look at this site it should get you well on your way!

http://www.sqldts.com/default.aspx?101

Darrell

Anthony,

This site should be able to help you figure out how to do what you need.

Darrell

Does the server that the DTS is runing on have access (permission) to the drive that the Excel file is on?

Yuvraj,

The link I told you about has a code sample of executing DTS from ASP without using XP_CMDSHELL. If you don't have execute rights to XP_CMDSHELL this may be your...

Also notice that Global Variable names ARE case sensitive.