m.rajesh.uk (4/19/2015)

---

My error log was keep on increasing and consuming entire disk space because of below error.

An exception occurred while enqueueing a message in the target queue....

Quick suggestion, use the ToString() method

😎

DataGridView1.Rows(0).Cells(1).Value = oDate.ToString()

Quick question, can you post DDL (create table) for the tables, some consumable sample data as an insert statements and the expected output? This will make answering your question a...

Brandie Tarvin (4/17/2015)

---

We have a database server and an application server. On the db server is a sql job calling up an SSIS package that resides in the file store...

Again reiterating the suggestion of using...

Brandie Tarvin (4/17/2015)

---

My workplace is getting ready to upgrade to SQL 2012. While I wait for the servers to be built, I started playing with 2012 SSMS pointing to our...

caojunhe24 (4/17/2015)

---

addition info: there are multiple folders I have to go through to check each folder if excel file is opened or not .should I have to create one foreach...

Further on Gianluca's question, all usable details are missing from the error dump you posted, obvious guess for a question would be why the job failed but then there is...

MadAdmin (4/19/2015)

---

exactly what I put into his request for code review of updating stats using nested cursors posted on 7april. To DBA01, Instead...

keshab.basnet (4/19/2015)

---

Thanks Sir.

I take full database and Transaction log backup once a day at night time when there is almost no transaction in database. Can i shrink log file to...

This looks like a typical situation for ELT, load everything as a text into the staging area and then do the conversion afterwards.

😎

Grant Fritchey (4/19/2015)

---

Eirikur Eiriksson (4/19/2015)

---

spaghettidba (4/19/2015)

---

Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.

Did...

spaghettidba (4/19/2015)

---

Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.

Did I say something wrong?...

Second solution, which is more efficient than the previous one as it doesn't use the XML concatenation. The code is somewhat self-explanatory.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_STR ...

coool_sweet (4/16/2015)

---

hi

i am adding new field to my existing package which is char(10).

getting this error:

[Flat File Destination [139]] Error: Data conversion failed. The data conversion for column...