Nevyn (11/6/2013)

---

Thanks for the suggestion, but it appears to still not work.

This feature would work for testing different environments in SSDT (for example, a different server name to connect to...

Nevyn (11/6/2013)

---

Hi Phil,

I am using environments for when the project is published to the server (or will be, that is part of what I was setting up). ...

As you're on SSIS 2012, you should consider creating an 'environment' which contains your connection strings and use the 'Configure' option to map those connection strings to connection managers in...

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?