What is the purpose of console.ReadLine ()? That looks interactive to me.

A bit of a newbie question, but have you confirmed that the SQL Server instance is configured to use mixed mode authentication?

It's probably not finishing because there's a permissions issue somewhere (either in accessing the data or in writing the file).

You don't have to do anything special to make it finish...

The folder to be iterated over can be a package or project parameter. Can you confirm that you are using UNC naming conventions throughout (and not drive letters)?

The file names...

sqld-_-ba (7/6/2016)

---

Hello Fellow DBAs/Developers/Consultants/Managers,

I couldn't find a reliable + recent source for DBA salaries in USA.

If you're interested in this poll, you must select 4 options :

one (and only one)...

It's explained in detail & perhaps that makes it seem a lot. It really isn't.

Basically, you need a variable. You run an execute SQL task and map the results of...

dirkdirden (7/5/2016)

---

I can't seem to figure out how to add a variable that uses a table for its value.

I'd like to use

SELECT DATEADD(HH, -1,MAX(LastModifiedDate)) FROM TicketsTable

As my variable.

Currently I...

Steven.Grzybowski (7/5/2016)

---

Is it possible to open a package in BIDs and then run it programmatically? I have a few packages that can't be run on the server due to...

dndaughtery (7/5/2016)

---

Hey guys, I foresee the possibility of going to Project deployment on my team. The one big red flag that concerns me is that if one of the developers...

Jeff Moden (7/4/2016)

---

Phil Parkin (6/28/2016)

---

Jeff Moden (6/27/2016)

---

jeffe_verde (6/26/2016)

---

The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names),...

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague in London...

If no one is prepared to hang around late & diagnose this while it's happening, the obvious alternative is to collect as much logging information as you can & then...

ffarouqi (7/4/2016)

---

Phil Parkin (7/4/2016)

---

ffarouqi (7/4/2016)

---

Hi,

I am not sure if this is a unique issue for me or is it a known issue for others as well. Basically, they have an...

ffarouqi (7/4/2016)

---

Hi,

I am not sure if this is a unique issue for me or is it a known issue for others as well. Basically, they have an SSIS package which...

I suggest that you focus on the string splitter now.

As far as I remember, query plans do not return accurate results for UDFs.