mubarak.a (10/8/2012)

---

Hi,

I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data?...

Is there a chance that you could post this in English?

Most people here communicate in English and I think you will find that you get a better response if...

+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...