Thanks every one... the above solutions worked... If I want directly load to main table then I can use type cast in Advanced tab... and if first load to staging...

Hello Ben, thanks for your response... I trying that but not able to get the time along with it... the string when it get inserted to the table the time...

Hi All,

Thanks for your response.. I will make my requirement more clear..

I have a flat file source... and in that I have a column say C1 with date time value...

Thanks for your response.

Thanks dwain.c,

I'm getting the answer with that code. I'm just trying to see if I can rewrite this some way so that I don't have to hard code my 90+...

Thanks Brandie,

But here in our case we are not sure of the out put column names. Based on the parameters what we pass to the SP, the out put columns...

Thanks..will try this.

Thanks for trying it.

Why I'm not happy with Option 1 because here we are copying the entire data after extracting so performance point of view I think Option 2 is...

Hi opc.Three,

I have sent you a PM with the package ( entire solution ) I'm attaching the same here again.

The solution has two packages, Package1 is where I have tried...

Hi opc.three,

Yes the template has the sheet with same name "BP"

I have tried the below steps for Option2

1. Created the file system task and pointed the source and destination...

Hi All,

I have tried 2 options

Option 1. After the DFT I have used a File System task to copy the file to the required destination location. This worked successfully but...

Thank you all.

I have tried the option of copying the file ( with data ) to the new location using File System task, but I don't think it is the...

Thanks Koen Verbeeck.

So you mean to say we cannot make it dynamic the way I required..? Is there any way you can suggest to achieve it?

Grant Fritchey, thanks a lot for making it clear.. 🙂

Friends,

When I updated the statistics it resolved the problem thanks to all who helped me.

But the question "how both the severs gave me same result within same time when...