sudhirnune (9/28/2015)

---

We are using SQL Server 2012 Data tools and trying to read data from a flat file with <LF> as header row delimiter and Row Delimiter. '~' is...

SSIS always understands OutputColumnWidth = 50 by default. You can absolutely adjust the value manually. But you must notice that a data page of SQL Server only allows to store...

vipin_jha123 (9/14/2015)

---

Hi ,

I have requirement for Emp files processing. I will have to process the files in the order of the files time stamps. Lets if have files time...

Hi,

When you run the package in Visual Studio, it uses your account to run, which you logged in. However, you run in SQL Agent Job, it uses the account of...

Polymorphist (8/13/2015)

---

Hello All,

I feel really dumb for asking this question, but here's my situation:

I added a new field to an existing ETL process which uses SSIS to ingest a...

Markus (12/18/2014)

---

This is my first SQL2014 install. We want to have it listen on a different port than the default. I have followed these instructions but after I...

Is there any solution to ask my .NET application uses 2 included .dll instead of .dll in new server?

John Mitchell-245523 (9/5/2014)

---

Why do you not want to upgrade your packages? All you should need to do is open them in the version of SSDT that comes with SQL...

I mean that the second is preferred in this...

purushottam2 (3/7/2013)

---

Which one is more performance oriented query?

1. SELECT 1 FROM table1 WHERE Id IN (SELECT Id FROM table2)

2. SELECT 1 FROM table1 t1 INNER JOIN table2 t2 ON t1.Id...

is250sp (3/6/2013)

---

In my dataset I have this script. Report parameter @acct is set as multi-value. When I select a single value it runs fine, however when I select...

Thought 5 minutes before getting a correct answer 😀

J M-314995 (3/5/2013)

---

When I run a script that uses COMPUTE BY in SSMS I get the desired results. When I try and create an SSIS package to export out...

yuvipoy (2/27/2013)

---

How to publish SSRS for internal alone.

I have a project which needs to be circulated only to my team members using my hostname.

What are the steps to deploy them.

now...

The rules to read the...