prennings (11/10/2013)

---

Hi all,

I was reading up on this article:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/102924/

And I was wondering in the article it was about updating the tables of your database but not a complete new insert....

Depends on the code. But if you're using, for example, a data adaptor, that's using up RAM for sure.

:w00t:

Reminds me of a report one of my ex co-workers used to run every month.

It was a pay analysis and...

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