It's no mystery - you have to rewrite your code using .NET syntax. I'm afraid that you have some learning to do, as I doubt that people here have the...

You need to rewrite your VBScript code in VB.NET - the syntax and commands are quite different. I'm afraid that cutting and pasting just won't work.

Phil

Can I just confirm what the underlying business requirement is here? Is it that there are constant amendments to an Excel spreadsheet of employee data and you want these amendments...

haha, I was wondering the same and was hoping to draw out the answer gently,...

Great tip - I did not know about that ... looks perfect for this.

So the sources are being updated continuously? Or just from time to time? You may encounter some locking problems.

One approach could be to move the source file to another folder,...

Maybe you could create a single file containing all the SQL first:

If Exist All_Files.sql Del All_Files.sql

Copy *.sql All_Files.sql /y

and then just execute All_Files.sql to save iterating round - not sure...

When you create a connection to the source file, using the Flat File Connection Manager Editor', select 'Advanced' - you can type in a caret directly as the column delimiter.

Phil

This is a common complaint with Excel input data. Check out this thread for some further details and ideas:

http://www.sqlservercentral.com/Forums/Topic423760-148-1.aspx

Phil

🙂 I'm sorry I was so slow to understand what you were trying to do.

So you want to use SQL Agent to start a Windows service? What happens if the service is already running?

What login credentials is the SQL Agent service running with? Can...

SMAZ (11/25/2008)

---

Well! following are my requiremetns:

1. If file file format is xls then

1.1 convert XLS file into CSV format

...

The version of VB.NET used in SSIS is, I believe, called VB.NET for Applications and is not the full-blown development environment in which you have developed your earlier piece of...

If this is pure numeric data in a CSV file, it should not be surrounded by text qualifiers ("). Try stripping these text qualifiers out from this field.

Phil

I had a quick look at the code: so for selected rows in a source SQL Server table you are executing an FTP process?

You need to get yourself on an...