Yes, this is harder than you might think. PSEXEC is what I have used in the past.

I would guess that the worksheet is called something other than 'sheet1'. Find out what that is and change the connection info.

n79799 (10/9/2012)

---

I am assuming you are getting the error in a script task. That happens when you are trying to access a vraibale inside the script without first specifyinf it...

I'd do this by using a Conditional Split in the dataflow. Just redirect the unwanted rows to an output which goes nowhere, while letting the good rows run through as...

Who'd have thought?

Mark, perhaps?

Another way:

declare @BigString varchar(max) = ''

select @BigString = @BigString + Firstname

from #temp

order by id

select @BigString, lower(@BigString)

ssms-man (10/9/2012)

---

Ok, I understand what you want and will add to "to investigate" list. We did not re-use regions till now, so we'll need some time to invest before we...

ssms-man (10/9/2012)

---

Phil Parkin (10/9/2012)

---

ssms-man (10/9/2012)

---

Phil Parkin (10/8/2012)

---

I've downloaded and installed SSMS Boost. Some interesting features and some usability issues too (eg Script Object as CREATE/ALTER fails with 'No suitable objects...

ssms-man (10/9/2012)

---

Phil Parkin (10/8/2012)

---

I've downloaded and installed SSMS Boost. Some interesting features and some usability issues too (eg Script Object as CREATE/ALTER fails with 'No suitable objects found at cursor...

Steve Jones - SSC Editor (7/28/2008)

---

Good explanation. OLEDB is newer and superceeds ODBC. You should aim to use OLEDB connections where possible. I believe there's an OLEDB provider that encapsulates...

Charmer (10/8/2012)

---

Phil Parkin (10/8/2012)

---

Charmer (10/8/2012)

---

Phil Parkin (10/8/2012)

---

Are you doing the imports in parallel or in series?

A no-code solution could utilise FOREACH containers - the container just does not execute if...

Four tables with different structures to one file?

I've downloaded and installed SSMS Boost. Some interesting features and some usability issues too (eg Script Object as CREATE/ALTER fails with 'No suitable objects found at cursor position' unless you...

Charmer (10/8/2012)

---

Phil Parkin (10/8/2012)

---

Are you doing the imports in parallel or in series?

A no-code solution could utilise FOREACH containers - the container just does not execute if the file is...

Are you doing the imports in parallel or in series?

A no-code solution could utilise FOREACH containers - the container just does not execute if the file is not there and...