+1

impossible to help with this without getting an idea of what the file looks like and what you need out of it.

Thanks to all who have responded with their ideas. I've been away for a couple of days & will be coding my solution this coming week.

Jeff, I have worked through...

CELKO (9/27/2012)

---

First, let's fix your DDL. There is no such thing a “type_id” in RDBMS; read ISO-11170 or any book on data modeling. Would you say “blood_type_id”? Of course not!...

Have a look here and see how you get on. It does something similar to what you require.

Hmm - it seems that I have had a go at helping someone solve this issue in the past - check here.

It would seem to be a problem specifically related...

Hardy21 (9/27/2012)

---

Yes Phil. It is...

Is the ResultSet property of the ExecuteSQL task set to SingleRow?

Have you mapped 'TableExists' to your package variable on the Result Set property page?

Hardy21 (9/27/2012)

---

I am using SSIS package to read the data from Access file and import them to SQL Server table. I have total 10 tables that I need to migrate...

sqlstud (9/25/2012)

---

Thanks Phil..

Forgot to inform that i need to use SSIS 2005. So that i can schedule it in SQL Server Agent job to run on daily basis.

How do we...

If you can, I would recommend that you change the PK definitions in the target database - they should be defined as int, but NOT identity.

Why? So that the PKs...

say for example , I have to delete space from the below string.

select 'karthik keyan 44768 sql server 2008'

which number i have to use? how many REPLACE i have to...

Interesting image that conjures up. I didn't take in the rest of your post. :w00t:

SomewhereSomehow (9/24/2012)

---

Also found this one:

SSMS Tools Pack add-in

As it's said on the utility page:

Query Execution History logs every SQL statement that you run in a file on your disk or...

Jason-299789 (9/24/2012)

---

Phil,

what about using the Results to File option in SSMS, its a bit cumbersome but should will allow the results to be stored.

Also switch on "Include the...

I'm pretty sure that my unicorn will run faster than your apple:-D