I got it working now with using a UserID=Admin. Don't know why becauce the excel file has not user id.

select

*...

I verified and corrected some registry settings on the providers and now I am getting the error

OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not...

The account that my SQL Server runs under and my account both have the same primissions. I am a sysadmin and have full NTFS rights to the file. But when...

Thanks Chiraq and Both options work fine.

Thanks I was wondering about the expression but the function idea is good. What would the sentax be to add it the the constraint?

The client tools can be installed but it will be in another application directory as MS Visual Studio 2005 or Microsoft SQL Server 2005 \ SQL Server Business Intelligence Development...

I was able to disable the checkpoint option and it ran fine. But because the checkpoint failed, I wonder what that was telling me?

Simulating CheckPoint of 23290 pages like SQL Sever...

We just use a sql task to drop table [table_name] and then another sql task to create table [table_name]

DROP TABLE NEW_TABLE

CREATE TABLE `New_Table` (

`pmt_no` Long ,

`amount` Double ,

`issue_dt`...

The above is correct. Each user needs one SQL CAL. Be sure to check the costs to make sure Processor license is not cheaper and remember. Also, remember that each processer on...

Make sure you go through the profile security settings, this got me. There are public security setting and private security settings assigned to your mail profiles you created..

Might want to...

I was having the same issue. If you expend all the file tree listings out you will see a common directory that it wants to wite to the C drive....

No you were right to begin with, the property was not showing up in the expression property editor list of properties. It was there back on the flat file destination property list...

I finally found it. Great. Thanks. I had posted a post to the MSDN feed back and they kept telling me the same thing. I was playing around with their...

Thanks. I did not think so but wanted another voice. Thanks

Would this also apply to workstations that have only the client network utility installed. Should we go around and upgrade these when ever we upgrade the server?

Thanks