Sean Lange (8/19/2015)

---

David Burrows (8/19/2015)

---

Sean Lange (8/19/2015)

---

Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table...

DamianC (8/19/2015)

---

Hello

I have inherited a few SSIS packages along with some jobs that run them.

I am able to find the packages behind pretty much every SSIS package as they're held...

The string format YYYYMMDD can be converted directly to datetime.

declare @x nvarchar(20) = '20110905';

declare @y datetime;

set @y = @x;

select @y;

Display formats are, of course, different from storage formats. It...

As far as I know.

karthik82.vk (8/19/2015)

---

Hi,

I have some excel files stored in a FTP folder. I want to transfer data from these excel files to my sql table directly from FTP without downloading it...

Rather than ExecuteSQL, why not use a standard dataflow with suitable source/destination components?

MikeTomkies (8/18/2015)

---

There should be no reason why the file system task wont move having the source and destination as variables. I use it for all file movements and with an...

Although it may seem as though the script components offer infinite flexibility given enough code, your problem will be that the input and output columns are defined at design time.

I...

Sure, use File.move in your script task.

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.