I think I would be tempted to use an 'Expression and Constraint' Precedence Constraint to control the flow, as Excel files are not really errors, just a different path ...

Can...

Jeffrey Williams (4/17/2009)

---

The error message is telling you what the problem is:

...

The permissions on the services appear to be correct - and shouldn't need to be changed. I would...

Do you mean that you are having trouble writing the T-SQL? Or some other problem?

Yep, you need to change Local System Account to something which has the appropriate access - a domain user.

Panks (4/16/2009)

---

I have tried both dbase III and IV but they dont work.

The problem is i am not a DBA, just a developer. So i can't

download and install just any...

Use the FLOOR function - it exists in SSIS as well:

if number = floor(number) then

--number is whole

else

--number is not whole

end if

Using what - VB.NET?

Check out this thread:

http://www.sqlservercentral.com/Forums/Topic285021-146-1.aspx

Or Visual Foxpro, for which another (free) driver is almost certainly required.

Are you looking for the function to do this?

Eg

if a <> int(a) then ----> error file

or more detailed instructions? I'm assuming that you are not operating within SQL -...

Can you describe roughly why you need to run the SP so frequently and give us an idea what it does. Maybe someone here will have other ideas about how...

Maybe you could try INSERTing the data from another SQL Server table and comparing times - to work out whether the problem is something to do with the import or...

Add a process at the end to remove the dups from the flat file ... ?

Not elegant, but avoids the major redesign.

-- edit -- see below.

If you are using the VariableDispenser method to set/retrieve variables, you do not need to add the variables to ReadOnlyVariables or ReadWriteVariables - in fact, you should not. Just trying...