Hi All,

Can I use this with excel files ??

Phil Parkin (1/10/2013)

---

Lidou123 (1/10/2013)

---

Hi All,

Very difficult - SSIS is meta data driven and changing meta data gives it a severe headache.

Also, if your columns change every day, how will you...

Thank U guys.

just let me test the 3 scripts and I will come back !!!!!!!!

Thank U

Lidou

????

Hi Lokesh,

that works well with index .

Thank U !!!!!!!!!

Hi Vinu,

thank U for your answer !!!

I tested the script but I have an error !!! it is in french .

Msg 116, Niveau 16, État 1, Ligne 8

Une seule expression peut être spécifiée dans...

Hi Lokesh,

Thank You for your answer.

I tested the script but the execution is too long ( about 30 minutes for 1064 lines) :(.

Do U think that it is possible to...

Hi Jeff.

The iso_wk function works well

Thank You Jeff

Thank You Jeff.

Hi Jeff,

Thank you for your answer.

For my company, the first day of the week is Monday.

And the weeks are numbered by the start of the year.

We use the ISO Calendar.

All...

OK. Thanks.

For you, I must create a table with parameters inside.

And another package that will load this table with dates that users want ??

Hi Daniel,

My question seems to be stupid but I am a newbie in SSIS. 🙁

With your solution, how can I do a package configuration with variable ???

Hi Daniel,

Thank you for your answer.

1 - But users who load data are not familiar with SSIS. It’s impossible for them to change the values of a variable in...