I had service pack 2 installed, but it didn't work. I had to install enterprise edition on other computer, and it worked fine..

SQL King (2/28/2008)

---

But for your case, I think we can use the same logic, but just more script to get the month as in your case here, it is the...

Eric,

I think this should work.

First, define both the Access and SQL DBs in connection manage. Then drag a SQL task. You can use query buider or just write...

alter table AHMC_CLAIMS_GAR

add PAYOR varchar(50) NULL ---<---- or whatever type is required to hold that data

update AHMC_CLAIMS_GAR

set Payor=AHMC_GAR_FC.[Description]

from AHMC_CLAIMS_GAR

...

right, that would work.. but partially.

I still need to know how to break the package..

Michael,

I tried what you said, but i'm getting an error saying that "the raw adapters do not support image, text, or ntext data."

I am attaching two screenshots of my Advanced...

Yeah, I did create a an empty text file....

SSIS...

What is...

haha. Thanks. Now I feel like a dumbhead. it's like DUH.... I've done these queries before... i guess I haven't had my coffee today..

Thanks.

Rav.

Crispin Proctor (1/30/2008)

---

Where's the screen shot?

I removed the screen shot and the file. It had some information that I shouldn't be posting. See the earlier posts...

Rav.

Pankaj,

Easy solution. you can accomplish the task by using File System Task.

Here's the link for tutorial http://msdn2.microsoft.com/en-us/library/ms140185.aspx

Rav.

Matt and Dsmith,

Thanks for the suggestion. My stupid head didn't think about customer data. I just removed both of the files.

Matt, we do have Monarch. ...

I wish I wish that was...

In the Flat File Souce Editor, do you have Error and Truncation set to "Fail Component" or "Ignore Failure"?

Ravi.