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...

Then you are onto a winner. Try with the derived column idea and post back with any further problems.

If the names really are formatted perfectly, you should be able to create derived columns to do this for you.

But I'll bet that they are not all quite so well...

Not possible, as far as I know.

You can parameterize it, if you have 2012+, by right clicking on its data flow task and selecting 'Parameterize' (who'd have thought?) – though...

vipin_jha123 (2/3/2015)

---

Hi,

I am new to the SSIS. I am trying to load multiple source tables from my staging database to corresponding destination table in the data warehouse.

All the source...

nguyenl71 39244 (2/3/2015)

---

After I add 2 tasks following this linked, ran the package but nothing return and no errors. No data in excel as well. What's is wrong...

Can you elaborate on that please? I'm not sure what that...