I presume that you've been keeping an eye on vacancies in the last few months. That should give you an idea of the market. My perception, as a person who...

Oops, didn't see this in time.

Chris.Hubbard4U (8/17/2015)

---

DECLARE @Date

SET @Date = 2012

DECLARE @Year int

SET @Year = (SELECT DATEPART(yyyy,@Date))

SELECT @Year AS Year

--SELECT *

-- FROM [Orders].[dbo].[Orders] od

-- WHERE .Orderl_Date < @Date;

----WHERE DATEPART(yyyy,@Date)= @Year

----WHERE DATEPART(yyyy,od.Order_Date)=...

Eirikur Eiriksson (8/17/2015)

---

ilovedata (8/16/2015)

---

I have a source from which I select the AccountID, StatusID, and value. I am using an aggregation Transform to find the SUM(Value) GROUP BY AccountID, StatusID.

I...

s.kandepi3 (8/16/2015)

---

I guess that would be possible if I am using just the view as my source .. by my source query is kinda complicated. the view gets joined with...

You could try Adblock Plus.

s.kandepi3 (8/15/2015)

---

found it.. it is getting converted to int in the view. so removed the cast in the view and let it flow as varchar.. and then in the derived...

s.kandepi3 (8/14/2015)

---

my package gave me this error.. the varchar value xyz cannot be converted to datatype int.. how to do error handling for such conversion errors? I tried the following...

Do not put the password in an expression.

Mirroring, yes.

Log Shipping, not as far as I know.

Yes...

happy55 (8/13/2015)

---

I have an SSIS Project which has few packages .All of the packages involve transferring file data to/from database to flat files. I am confused if I need...

Or pass it in via a 'sensitive' environment variable if SSIS 2012+.

Using not-very-advanced Google search strings suggested yes.

Try this.

Use a UNC path. Do not rely on network drive letters.