Can you tell us the full data types of all the columns involved please?

Edit: have a look here. It is likely that you are experiencing rounding errors at a very...

Here's how I would do it.

Add a lookup to your package and use it to determine Insert vs Update.

If it's an Insert, send it directly to the target table.

If it's...

rocky_498 (2/9/2015)

---

Opps I should mention.

I am using so far two transformations ( Derived Column, Data Conversion)

Plus I am using SCD..

That would be next question. If I pick Second Option...

What sort of transformations do you have in mind?

Will you be doing just inserts, or inserts and updates, or inserts, updates and deletes?

Guitar_player (2/9/2015)

---

nope ...but on click of the 'Parameterize' option, we will get the chance of selecting our own property i believe but i just have selected the connectionstring instead of...

Guitar_player (2/9/2015)

---

Let me explain,

We will have project connections in our connection manager , so i right click on them and clicked on "Parameterize" option

and selected the connection string...

But does an expression contain the parameter?

Does your package contain an expression with a sensitive parameter?

Does this thread help?

Guitar_player (2/9/2015)

---

Hi Phil,

I need another help from you , currently in our project we have given as "DoNotSaveSensitive" as the Encrypt level , suppose if the...

A little off topic, but it would be interesting to know why you would choose to convert from CSV to Excel prior to doing an import. I would usually suggest...

Can you explain what you are expecting this row to do please?

CAST(ROW_NUMBER() OVER (PARTITION BY DIA.reference ORDER BY dia.entry_date+dia.entry_time) AS datetime) 'TEST'

If you can find the command-line syntax, you should be able to use an Execute Process task to do this.

Here is a possible way of doing it.

You might be able to use this technique:

declare @T1 table (Id int)

insert @T1

(Id)

values (1),(2),(3);

with vals(x) as (select ',' + cast(Id as...

abhas (2/4/2015)

---

Thanks Phil for your suggestion. I am able to split lastName as Pawar by using below code of stuff.

SUBSTRING(Name,1,FINDSTRING(Name,",",1) - 1)

but not able to identify FirstName as Ramesh. M...