this part if the error is suspicious:

requires a higher level edition

Verify you are running a Package in 2005 format.

Bill Talada (1/14/2016)

---

I think the OP should go with a calendar table. I did take it 90% of the way to show him how to manipulate dates. His...

Bill Talada (1/14/2016)

---

DECLARE @days TABLE (dt date not null primary key);

DECLARE @dt date;

SET @dt = '20160101';

WHILE @dt < '20170101'

BEGIN

INSERT into @days VALUES (@dt);

SET @dt = DATEADD(DAY,1,@dt);

END

SELECT DATEPART(MONTH,dt) MonthNbr, DATEPART(week,dt) WeekNbr,...

Jeff Moden (1/14/2016)

---

Orlando Colamatteo (1/13/2016)

---

Counting the number of lines in a flat-file in a Script Task in SSIS is trivial and wicked fast. You can then take that count and...

noober (5/24/2013)

---

Instead of writing it to a file and then using an xml source...why not just do everything in a script component? You can call the web service, de-serialize the...

cycle90210 (1/14/2016)

---

I will need to experiment but how does a StreamReader determine a "line"? If I have a CRLF in the middle of a text field; will stream reader count...

Slay it. I was completely bummed when I learned how bad it was because functionally FORMAT is a breath of fresh air compared to other methods. Too bad it's essentially...

A third option is to drop and recreate the table.

That returns 201601 for days in January. The OP wants 2016/1 for January and 2016/10 for October. There is no style offered by CONVERT for that...

Some users, yes, but still not someone in the db_owner Role as they could...

How do you need to handle the schema changes? Assuming these changes are a fact of life, what do the people adding these fields expect from the DW solution? Dynamic...

Duplicate post:

http://www.sqlservercentral.com/Forums/Topic1752396-149-1.aspx

.

You could use a Script Task and use the WebClient class. Should not be too much code.

sushantkatte (1/13/2016)

---

I want to select getdate() in the format yyyy/M. i tried to write a query as SELECT FORMAT(GETDATE(),'yyyy/M') but it is giving me error.I am a beginner in sql....