Brandie Tarvin (3/23/2012)

---

I...

You can copy paste the contents of the script files to the Execute SQL Task. Change the SQLSourceType from File connection to Direct input and put the code in the...

It's feasible.

You'll just have to put a bit more development effort in it.

The path you mention is correct. It's the path where the SSIS package is located that's being used by the job.

However, is this job in production? Then this package is...

If they are on the filesystem, there should be a filepath in the job that references the package.

The user is asking for the latest version. Are there versions stored somewhere...

Gianluca Sartori (3/23/2012)

---

charles.southey (3/23/2012)

---

If you want a commercially-supported CLR-based utility for this our SQLUtilities product includes a wide range of date formatting & parsing functions, as well as other useful...

Charmer (3/23/2012)

---

SQLRNNR (3/22/2012)

---

Even taking the DDL from the...

If the overtime happens on a consistent basis, yes.

But usually when I do some overtime I work a bit less long the day/week after.

Well, the local version works. If I enter google.com I'm automatically directed to...

It's you.

The fact that you're apparently not an SSAS admin can probably cause issues with you trying to connect from Excel.

Log into SSAS using SSMS and add yourself as one of...

I'm curious, did the OP get the idea for this question by watching the SSIS Tips&Tricks session on the 24 hours of PASS? Josef Richberg devoted a section on FastParse.

If TCP/IP is disabled it doesn't really matter.

It's just localhost, you should be able to connect just fine.

There must be something wrong, the problem is finding it.

Did you install SQL...

Gianluca Sartori (3/23/2012)

---

Thank you, Koen.

The BOL page for CONVERT is linked in the "built-in method so far" section. unfortunately hyperlinks are not easy to spot both on the forums and...

Very nice question about a quite unknown feature of SSIS. Thanks!