You could even take it one step further and make the day of the week you wish to execute the task on configurable. So "Wednesday" would be stored in a...

Say for example you want to run the stored proc only on Wednesdays. One way would be to have a check in the package that checks the current day against...

Try this:

Dts.Variables("DestinationTableName").Value = System.IO.Path.GetFileNameWithoutExtension(FileName)

I hope I understand what you are asking.

Try this:

Dim counter As Integer = CInt(Dts.Variables("varpackage").Value)

I *think* you need to replace fol.Folders with fol.SubFolders.

System::ErrorDescription is a String, so you'll need a varchar/nvarchar column.

What was the exact error? I've seen a few things that can cause problems with that parameter.

Example file: ff10162008.ks

Task: Rename to ks.txt

Sample script task code (untested):

Dim fileName As String = "c:\cff10162008.ks"

'Get the file extension (this will be ".ks")

Dim extension As String = System.IO.Path.GetExtension(fileName)

'Remove the leading "."...

This link will help you with your task:

http://msdn.microsoft.com/en-us/library/ms136025.aspx

In my opinion, a script task will be easier to understand and maintain for simple tasks like this.

I think you will need Excel installed on the server where the ssis package will run.

Just search the Web for something like "vb.net beginner tutorial" (or similar) and you should get a whole bunch of useful stuff. And/or purchase a beginner vb.net book.

A good way...

I believe you will need to install the pffice primary interop assemblies (which puts them into the GAC) and then copy the relevant DLLs you want to apprear in the...

Seems to be looking for "file1.txt" again for some reason. Are you updating the value of the variable holding the name of the file to next rename?

Do you need to examine the filenames before renaming them? If so, you'll probably need a script task to do it. If not, you can use the file system task...

Yeah but I'm not sure if you can simply pass the filename as a variable to the FTP Task. I think the FTP Task will expect a source file connection...