Hi Ed,

Thanks I have the value coming in as a decimal format already (expecting to convert so I said might as well place in the data type it should...

Never mind I think I see it now I need to put the puzzle together thanks for the help.

Jack,

Going to sound dumb but I have only a small experience with SSIS...where is the flat file connection manager? I don't see it Business Intelligence (Visual Studio)

Shot in the dark...is the stored procedure within the job using the full convention? You indicated you had multiple schemas

Can you try ...

[databasename].[databaseowner/schema].[tablename]

PR,

I found this link that spells out the application role purpose and how to establish an application role between app and SQL server

http://articles.techrepublic.com.com/5100-22_11-5068954.html

Thanks again...I went with something a bit more simpler, I realize it is using xp_cmdshell

echo on

rem Delete of SQL Backup Files on HQ/SQLBACKUP% older than 5 days from today's date....

Thanks all will try the extended stored procedure first I forgot about this...

Michael,

Total shot in the dark but trying to help...start looking at this system table: sys.certificates This is where the certificates are held and their expiration date.

Here is a link...

Greich,

Make sure that the Domain user that you just created with the ODBC connection is attached to Microsoft Query that retrieves the data into Excel.

I am assuming you use the...

Chester,

Appears to be a security risk yet the stored procedure is still in SQL 2005...here is the excerpts from BOL

xp_processmail

Uses extended stored procedures (xp_findnextmsg, xp_readmail, and xp_deletemail) to process incoming...

Found it... the problem is not bcp or the BULK INSERT or any of that..our antiquated dinosaur of a ERP system likes to see a space for blank columns...I re-did...

I would be curious to the answer to this as well. I do know as knowledge that using Select * on large databases you are going to take a...

I got it all no problems but I think the obvious...I am stumped on this

This specifies association between entities.

I have

_E_A____S_I_

It's killing me I am over thinking this!!!

Merry Christmas all

Thanks Piotr that works...

Adam,

Thanks for the help works like a charm!