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

nguyenl71 39244 (2/2/2015)

---

Yes, I have try to use the File system task to copy the file to other folder c:\OutputClient\....xls but how can I append the format date like this....

I know that you are new here, so I'll try not to be too hard on you :-), but ...

Saying that a proposed solution 'does not work' is not very...

atul.jadhav (2/2/2015)

---

Dear Expert

I have below code which send email from SQL Table "testing$" with use of store procedure

but I am not getting any email, please check where is the error

and...

Could the table have been locked by another process?

+10!

Sean beat me to it again!

It would be a good idea to post the error message text. And to fix the fact that only single-row updates are handled.

bouazizimedridha (1/30/2015)

---

Hi,

Description :

I opened an existing package in visual studio 2012, and noticed on the OleDBDestination component that the selected DataAccessMode was "Table or View". The duration of the load...

atul.jadhav (1/30/2015)

---

Dear expert

I am using import/export wizard to upload excel in sql table

I have primary key in my table

and all primary key value has been change every day

i.e. I have...

sm_iransoftware (1/30/2015)

---

Because I read somewhere , PK and Clustered index, can be separate (These two do not necessarily Be one thing)

And it's better that clustered index related to Bussiness...