@jeff,

Needs your help on SQL statements. Can u kindly refer to this thread?

I have tried your method but it is not logically right. I am kinda urgent...

Sort of....

Hi all,

I AM BACK. haha i did quite a number of article reading. I think i am slightly better now. I managed to get what i want by creating 6...

Drowning....GPHM!!! Haiz i tried Execute SQL tasks, cant do it. I tried Execute T-SQL statement task cant do it either. I have read aot articles and examples but my requirement...

Thanks jeff, Haha slowly getting the hang of it. I did a breakdown of your codes and realize it will return me:

the following error: "The conversion of a char data...

Jeff Moden (12/10/2012)

---

Phil Parkin (12/10/2012)

---

10e5x (12/10/2012)

---

Hi Phil,

I shall try your approach first since u sounds very confident. And I believe u totally know your stuff. But sad to say, I...

Hi Kraig,

So is a misunderstanding from my boss of SSIS? Oh no, i shall i report this to her.... i am v new to the department. this is my 3rd...

Phil I also hope some1 in the office can guide me but they are all stuffed with projects. I am at my wits end. Now I shall do as...

Ok Jeff I got it. So I can't use your method? Even if I create those task? So sad, so wasted anyway thanks for the help.

Btw if I am...

Hi Jeff,

Thank you for all te effort u have put in. I just felt very wasted not be able to implement what u taught. But I shall not give...

Hi Phil,

I shall try your approach first since u sounds very confident. And I believe u totally know your stuff. But sad to say, I am not up till the...

Hi ray,

I tried what u suggested on my own but i got this error:

SSIS package "Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.

Information: 0x4004300A at Data...

Hi phil,

My source is an SQL table from SQL server 2005. So you are suggesting me to leave everything till the SSRS side, then do a stored procedure? In my...

Hi Jeff,

HOLY MAMA!!! Omg how did that even come about? Its my third time reading your method and i am still like circling around the forest. Thats way too high...

Phil Parkin (12/9/2012)

---

May I ask how you think that SSIS can help you with this problem?

Based on the data provided, it looks like a stored proc would be suffucient to...