xsevensinzx (5/19/2016)

---

sestell1 (5/18/2016)

---

Darn, it looks like that uses the MS Office API to connect to the workbook and do the conversion. I was hoping for a command-line utility that...

Very interesting question.

Thank you for posting this!

Yes, I do as well. Unfortunately, clients are forever finding new ways to break that with inconsistent layouts, missing header row values, header values that span columns, etc... ...

Darn, it looks like that uses the MS Office API to connect to the workbook and do the conversion. I was hoping for a command-line utility that does not...

Excellent, I'm glad you found a solution.

I'm curious to know what tool you are using to convert the Excel worksheets to CSV files. That could be handy.

for the string...

I'd use SSIS for this, although it'd be rather complicated.

I think I'd create an SSIS package with a connection to your Workbook. I'd then use a data...

That is because you are missing the last parenthesis. 😉

Hello,

I'm afraid I'm not quite sure what you are asking.

You said that you want to return VERSION. I see that you have it included in your...

Both of those queries work because they are essentially the same thing.

You should probably work to understand those queries so that you can modify them to return the...

I don't think you are going to be able to do this in a reliable manner.

You can use a script task to connect to the workbook and force...

If you are running the job within seconds of creating it, then I'm wondering if you even need a schedule at all?

You could kick off the job without a schedule...

You can try doing something like this:

CASE

WHEN RTrim(@@VERSION) LIKE '%(VM)' + CHAR(10) THEN 'Virtual'

WHEN RTrim(@@VERSION) LIKE '%(Hypervisor)' + CHAR(10) THEN 'Virtual'

ELSE 'Physical'

END AS Machine_Type

...but I can't vouch for the...

If you did decide to go this route,...

rk1980factor (5/13/2016)

---

below query gives me wrong result , it seem to list all the values

SELECT

*

FROM

#Employee Employee

FULL OUTER JOIN

#Class Class

ON

IsNull(Employee.[Emp_no.], '') = IsNull(Class.[Emp_no.], '')

ANDIsNull(Employee.Org_Code, '') = IsNull(Class.Org_Code, '')

ANDIsNull(Employee.Org_Num,...

Interesting question.

I've always used a combination of xp_cmdshell and bcp to move data to/from files within T-SQL.

You could also use OLE automation, but that would require that you enable 'Ole...