Elliott W (3/9/2010)

---

I think it would be helpful to include the output from the SSIS output window, I'm wondering if there is some other text that might provide some additional...

It's located on the same server. "C:\App\ErrorLogs\"

Also,

SQL Agent Services Account has local admin rights on the server. Same permissions as the owner of...

This was faced by one of the new user of the server whom I had given access to.

After granting access to him he was able to log on to...

I just (not so willingly) remotely restarted the server. Bingo !!...

I appreciate you help truly !

This is how my Login name properties look like.user dbo is mapped to myusername(my login)

This is W.Server 2008. And it does have User Account Control...

I do have dbo permissions on those databases. In-fact, I have sysadmin permission assigned since I installed the server.

Initially SQL, SSRS, SSIS and SQL Agent were running under my username...

Thanks for replying Phil,

Yes, fixing the header returns success. I have used Script task to modify the file and then import it into SQL which solves the problem.

Actually, I was...

Lowell,

What's your take on this one?

UPDATE T1

SET T1.CustName = T2.CustName,

T1.CustAddress = T2.CustAddress

FROM Customers T1

INNER JOIN UpdateList T2

ON T1.CustomerCode = T2.Code

AND T1.Convert(varchar,ImportedDate,103) = convert(varchar,GETDATE(),103)

Thanks a lot !

🙂

For Using SSIS:

http://timothychenallen.blogspot.com/2007/07/how-to-import-dbase-tables-into-sql.html

Well, thanks !!

This program is part of another program which stores recno value to a variableA and then it says

Do updatecustomers.prg with variableA

Let me go ahead and post that code...

What is the source of your dbf file ?

Depending upon the source of the dbf file you can look into the following.

Some of the sources for dbf files are Access,...

Thanks for replying and please excuse for the poor description before ! This time I'll try to make this code more realistic and descriptive.

Here's what I think this code is...

Well, that's wonderful piece of information on your blog. Thanks for sharing !!

I tried using dummy flow task and then came the expression part. I tried to evaluate the expression...

Hi,

Thanks for your reply !

There are multiple files that comes daily with current Date Stamp on them. For single file, I face no issue using expression and variables.

But, I'm...

You may use Even Handlers.

You can define Event Handler per executable task. Add details like for Error or Success etc.

Then configure your send mail task to send the generated file...