I accept with Srinkanth. It is my personal experience...

Raj,

You mean that from 3 different soruce tables to three different destination tables?

I have done same kind of package before.

You can do this by Dataflow task.

Create 3 data source tasks...

venki (6/26/2008)

---

Don't leave me, I have another requirement came up for same kind but bit different. I will think in your way and I will try today. If it comes...

Jeff,

sorry man, pduplessis is helping me from starting since two months. That's why I remembered him. Now you are the second one.

Thanks a lot for your help as I...

pduplessis (6/25/2008)

---

Now....

For the SSIS bit.

1) Create connectionmanager to your data

2) Create a preparation SQL task which basically deletes the data, as per the delete statement

3) Create a dataflow. OLEDB source...

Thanks a lot to all of you who helped me successful this task.

Especially Jef and Pduplessis, I would like to tell you many more thanks.

It's awesome and fantastic learning experience...

Hi,

Your suggestions are always welcome. No body responded for this one yesterday that's why I deleted it.

I have kept it for halfen hour and taken back. Now I am...

Pduplessis,

Have you checked my Stored Procedure?

OK I...

Yes, but what can I do. Dead line has came up. I have to submit it yesterday that's why I have created the stored procedure and I executed it in...

I got a doubt when I am trying to create a Stored Procedure.

I am pulling the data i.e recordset by written a query from different tables.

I supposed to modify the...

pduplessis (6/22/2008)

---

hey venki,

Once more, I misunderstood you...

You have a SP that inserts data from one table to the other. I didnt realise that you are trying to pass parameters, and...

Please help me out as dead line came nearer. I have submit my tasks.

I have created the executesql task and I set up the resultset property as FULLRESULTSET.

I mentioned the...

pduplessis (6/20/2008)

---

In your case, I would still go for SSIS merge join and derived columns. But its gonna be quite some work changing it by the sounds of it.

Why? Because...

mlimp (6/20/2008)

---

Hi,

This is an easy one.

How do delete rows from a table?

I want to delete all the rows from the last month of a table so i have to be...