Where does the target file name come from?

Yes it can be done. Have a look here for some pointers.

I'm assuming that you are using a flat file source and not SQL Server? Otherwise there may be a...

If you check BOL for BCP (see here), you'll see that it can take a table, a view or a query as an argument. But not a proc.

Nothing built in.

But have a look here [/url]for a comparison of different ways to achieve this.

Your Excel column is holding mixed datatypes, so you'll need to bring in the column as string and add IMEX=1 to the Excel connection string (Google it for details).

sqlstud (10/10/2012)

---

Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your...

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