Maybe you can download the evaluation edition from the SQL Server website and upgrade it to developer edition? Don't really know where you could purchase the license key though.

Make sure that the packages are stored and executed on that server.

For example, you can install the SSIS service on machine A on store them on that server, but if...

You can buy it on Amazon:

US

http://www.amazon.com/SQL-Server-Developer-Edition-2012/dp/B007RFXQAM/ref=sr_1_1?ie=UTF8&qid=1352789801&sr=8-1&keywords=sql+server+developer+edition+2012

UK

http://www.amazon.co.uk/MICROSOFT-E32-00941-Server-Developer-Edition/dp/B007ZKW786/ref=sr_1_1?ie=UTF8&qid=1352789847&sr=8-1

France

http://www.amazon.fr/MICROSOFT-DEVELOPER-EDITION-ENSEMBLE-FRAN%C3%87AIS/dp/B008MY8S6Y/ref=sr_1_1?ie=UTF8&qid=1352789879&sr=8-1

Germany

http://www.amazon.de/SQL-Server-Developer-Edition-2012/dp/B007ZKVIO0/ref=sr_1_1?ie=UTF8&qid=1352789913&sr=8-1

and so on...

Lots of reading 🙂

Thanks for the question.

Yes. Such a split is easy to do in the derived column and it saves you the staging step.

edit: never mind, you cannot specify a length for DT_NTEXT.

What is the datatype of the destination?

Replacing a field doesn't actually do the conversion.

You need to create a new column and add the expression (DT_WSTR,32000)EmailBody there.

Roland is right, there's probably a one-to-many relationship, resulting in possible multiple results for one Dutyrostershift.ID.

Nice introductory article, but I would have liked another case study instead of the plain old BikeBuyer one.

Ah, that might be...

Please do not crosspost. It wastes people's time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1383543-5-1.aspx

The log says otherwise 🙂

There seems to be some sort of issue with this account, because the log mentions (unknown) instead...

asranantha (11/12/2012)

---

hi small doubt to loading xls and xlsz files format

actual whil loading xls file extendent propertis=excel 8.0 and

...

Which account is used for the SQL Server Agent service?

http://stackoverflow.com/questions/18932/how-can-i-remove-duplicate-rows

Using Google for a bit probably won't kill you.