Hi,

I tried the deploying of packages in sql server 2005 , the way it is in that link. But, I'm getting some error as it is not able to deploy...

Thank you. 🙂

Hi,

But I din't find any NOT IS NULL condition in Conditional split.

Where it is?

How to use it?

Thanks for your replies and ur help. But, I din't come up with the...

please help me how to use conditional split. 🙂

Can u please be more specific.

I have used Look up transformation.

After that, which transformation to use to find the value is already existing.

As i am a beginner to SSIS, please...

Can u plz be more specific.

Its not exactly deleting.

I need to update the existing row, if the value for the same row comes from the source.

Please tell me...

Hi,

In the first conditional split, I gave the expression as:

((DT_DBDATE)timestamp == (DT_DBDATE)DATEADD("dd",-1,GETDATE()))

which returns only yesterday's i.e, previous day's rows.

In the second conditional split, I gave the expression as:

((DT_DBDATE)timestamp == (DT_DBDATE)(DATEDIFF("mi",timestamp,timestamp)%...

Can you please explain me giving some code?

Thanks.

Thank you friend.

Hi all,

I would like to explain it more clearly.

I have a table. tbl_Readings.

The table structure is as shown below,

TimeStamp, ...

Thank you friend.

Got it worked.

thanks.

Thank you friends for your fast reply.

It worked. Thanks. 🙂

Thanks Jack.

Thanks for all your replies. I would like to describe what I want in detail.

I have a table, consider meterreading table.

I have columns like,

Date, meter1reading, meter2reading,.....meter100reading.

values are like,

12/2/2008 15:15:00,123.45,234.56,345.67......

14/2/2008...

Thanks mukti for your reply.

Please tell me how to add two rows and make it as one row using script transformation.

Thanks in advance.