Dwain does it again - nice article sir!

dwilliscp (11/1/2013)

---

My data conversion is giving... Error at Data Flow Processing Data, conversion from DT_STR with code 65001 to DT_STR with code page 1252 is not supported... so just how...

Nice article. Your numbering system needs alignment (starts off zero-based and moves to one-based in the results table).

I would be interested to see whether the final 'staging table' option would...

Here's another version for lazy people:

Using Service broker (SQL Server) to call a WCF service which could add data to the queue. There are tables related to the service broker...

frdrckmitchell7 (10/29/2013)

---

Good day all the clever ones

I have a table (stock) that I need to update every day from a certain date (the first day of the month) to the...

Matt Miller (#4) (10/29/2013)

---

300mb of data should load in no time flat, but you seem to be going at it the hard way.

If the input file is to simply be...

When you say users details, do you...

See here.

I do not understand this bit. Let me explain why.

Step 1: create the SQL

----------------------

Dim fileSystemPath As String

fileSystemPath = Dts.Variables("User::SingleFileName").Value

Dts.Variables("User::destNameSQLQuery").Value = ""...

pnr8uk (10/28/2013)

---

Actually it is more complicated than a REPLACE will allow. The REPLACE allows me to choose the column now, but later on in the package, I need the proper...

pnr8uk (10/28/2013)

---

Thanks I thought of that, but sadly the value is then wrong on what SQL is looking for:

The FileSystemPath has to match exactly, so if I remove the apostrophes...

How about replacing ' with '' in your fileSystemPath variable when you create the SQL?

blasto_max (10/28/2013)

---

I am not able to convert SSIS get date to sql server datetime format. I saw some error which i don't remember. anyway, so i decided to execute sql...

Thanks for the concise article Dwain - an interesting read as usual.

To assign the results of a query to an object variable, use an ExecuteSQL task, not a dataflow. Examples abound, here's one I found.