ningaraju.n (12/17/2012)

---

Hi All,

I am new to SSIS,I have given task of implementing the following task

create SSIS packages which takes input parameters and call stored procedure and the result set of...

xmozart.ryan (12/17/2012)

---

i knew it, those triggers is works until i added the Instead Of Update trigger on that table,,,

but b'coz i dont understand too much about instead of update...

Subbu S (12/16/2012)

---

Finally i found the solution, here u go,

Select 1 [Id],1000[value] into TempA

Select 2[Id], 10 value, 1 parent into TempB

Insert into TempB

Select 3,9,1

union all

select 4,5,1

Select * From TempA;

Select *...

ByronOne (12/11/2012)

---

Hi everyone

I have a table in SQL server that contains the following : ID, Date, Description, Type, Manager and Site. There can be more than one record per...

Nice question.However it will fetch error in SQL 2005 not sure about upper version as we can not assign value while declaration.

abhas (12/5/2012)

---

Hi rhythm,

I am doing below steps.

1) Execute sql task - here I am fetching studid,studname,deptname,HodName,HodMail.

2) I am using foreach loop

3) In foreach loop I am using script task and...

Thanks Koen.

Koen Verbeeck (12/6/2012)

---

Put a dataflow on the control flow. Add an OLE DB source and an OLE DB Destination. Done.

(you can find stuff like this in even the most basic...

It totally deppends on the business...

Probably you have include your mail task in...

Store the names of student in string variable using Execute Sql Task and then use send mail task to send...

SSIS.COM (8/24/2010)

---

Thanks to Elliott and everyone who reponded.

Here is a brief description of my problem

Initially my destination(reference) table is empty... I am trying to load data from my staging table...

Phil Parkin (11/27/2012)

---

rhythm.varshney (11/27/2012)

---

Phil Parkin (11/27/2012)

---

There is no good way of doing this in SSIS - I'm with Jeff on this one.

If you want to put an SSIS 'wrapper' round...

cooljagadeesh (12/3/2012)

---

Hi All,

how to i find out the user when stored procedure last modified

i am able to get the list of sp's modified date

using below Queries

select...

I got it by following way.Please let me know if there is any better way of doing it via SSIS transformations.

1.Truncating and filling records from CSV to staging table.

2.Putting look...