The sample you've provided looks to be more like an XML format to me, not really a CSV. Unless the intent is to just load the XML stuff into columns...

I'm a bit of a SQL newbie myself, fair warning.

What's the data type for column 3? What's the actual data that's in row 1 column 3 in your CSV file?

Is...

Phil that's a great recommendation. I'm going to head down that path today! At a cursory glance it looks like I can definitely implement command line syntax, so I don't...

Yes, that's correct. The data in the master table never gets updated, just new rows added on an hourly basis.

Hi Jeff (and MWise),

Things are coming to an end on this, though possibly not as efficient as they could be. I did a couple of tasks in SSIS - Download...

I'm just now realizing what you said, Jeff - that I simply can't use a variable name with BULK INSERT - in T-SQL or SSIS (since it's simply executing the...

Excellent, I've now got it set up with the SourceConnection expression and it's showing the correct path/filename....however...upon saving the project it immediately throws a non-fatal error indicating that it cannot...

Double post - removed.

@MWise - I've a question I'm hoping you can assist with. I've done some searching but have been unable to come up with a solution so far.

Thus far...

Thank you both for your assistance. I'm probably going to go the SSIS route since we've a good amount of existing packages today (and xp_cmdshell is presently disabled). Thanks guys!

Eirikur Eiriksson (12/3/2014)

---

Quick questions, what is the data source (ORA Version)? Have you tried using ALTER SESSION SET NLS_DATE_FORMAT to "format" the output of CURRENT_DATE? Don't think it's an...

Eugene Elutin (10/7/2014)

---

you can try:

DECLARE @sql NVARCHAR(MAX) = ''

CREATE TABLE #tResults (TableName VARCHAR(50))

SELECT @sql = @sql + 'INSERT #tResults SELECT ''' + st.name + ''' WHERE '...

Eugene Elutin (10/7/2014)

---

you can try:

DECLARE @sql NVARCHAR(MAX) = ''

CREATE TABLE #tResults (TableName VARCHAR(50))

SELECT @sql = @sql + 'INSERT #tResults SELECT ''' + st.name + ''' WHERE '...

Yeah, there's no way around that for sure.

Thank you to everyone that replied and tried to understand what the hell I was trying to achieve. I greatly appreciate everyone's time...

Sean Lange (10/7/2014)

---

Let me see if I understand your request here. You have 13,000 tables in your database with specific naming convention. You then need to look at every row...