Difficult to help without knowing a bit more.

My advice would be to focus on the first error - resolving it may fix some of those that occur after it. What...

The ALTER TABLE requirement continues to puzzle me. Anyhow, now that I understand better what you are trying to achieve, here is how I would do it:

1) Create a staging...

I am afraid that I do not know about your error message.

But I have never found anything in an ActiveX task that cannot be accomplished in a script task and...

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

...