Grant Fritchey (2/24/2011)

---

Do not pile on to this one, please. I just thought I'd point out where I was bad. That one really yakked me off. Again, no need for...

rashmiptl22 (2/24/2011)

---

hi

But how the Filewatcher task will come to know that a new file is placed in the source folder .Once the package stops ,you need to run the SSIS...

rashmiptl22 (2/24/2011)

---

Hi

I agree with you ,The File Watcher Task will keep running until the file shows up.

But let's say 2 files are to be read.The package starts and reads the...

rashmiptl22 (2/24/2011)

---

Hi

If you start the package when the server starts,

let's say it runs at 12:30 and ends after 5 minute .

But the file is placed at 12:36.When the file...

What if we take...

alin.selicean (2/24/2011)

---

Still got errors. When I assign the local path to the LocalPath property, I got an error stating the connection "E:\DBBackups\TEST.BAK' does not exists.

Do I need to do...

Phil Parkin (2/24/2011)

---

No.

The requirement: ".. very next minute..."

Your solution misses that...

rashmiptl22 (2/24/2011)

---

Hi

I don't think so.Using File watcher task or WMI eventwatcher task in the SSIS package can be usefull but it will not meet the requirement.The requirement is that...

The code inside the Execute SQL Task would be as follows:

DECLARE @firstname VARCHAR(100), @middlename VARCHAR(100), @lastname VARCHAR(100), @contactid INT;

SET @firstname= ?; -- 0

SET @middlename= ?; -- 1

SET @lastname= ?; --...

This is a very, very common problem with SSIS and Excel. Did you try google, because there are literally hundreds of articles, blog and forumposts about this subject.

I'm too lazy...

That is quite...

Try setting the property DelayValidation to TRUE on the FTP task.

Nice question, thanks.

I voted for the connect issue.

chris.stuart (2/24/2011)

---

Koen, I'm thinking Jet, really not sure if you could, but previously have worked a lot with Excel & Excel VBA, and Named Ranged solved a lot of these...

chris.stuart (2/23/2011)

---

Just a thought, and I'm not sure that it will work, but what about importing "Named Ranges" from the Excel sheet, will sort out the problem if you could...