Forum Replies Created

Viewing 15 posts - 511 through 525 (of 7,164 total)

  • RE: Migrating SSIS 2005 to SSDT 2012

    this part if the error is suspicious:

    requires a higher level edition

    Verify you are running a Package in 2005 format.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 1:53 pm

    #1852073

  • RE: Need help on creating a logic between week number & month

    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...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 9:09 am

    #1851972

  • RE: Need help on creating a logic between week number & month

    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,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 8:54 am

    #1851960

  • RE: Guarantee entire flat file loaded

    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...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 8:37 am

    #1851949

  • RE: XML from RESTful web service into SQL table(s) using SSIS

    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...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 8:33 am

    #1851946

  • RE: Guarantee entire flat file loaded

    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...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 8:06 am

    #1851937

  • RE: how to Select getdate () in yyyy/M format ?

    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...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 7:51 am

    #1851919

  • RE: Purge/Delete records from a table

    A third option is to drop and recreate the table.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 14, 2016 at 1:27 am

    #1851827

  • RE: how to Select getdate () in yyyy/M format ?

    johnwalker10 (1/13/2016)

    SELECT CONVERT(nvarchar(6), GETDATE(), 112)

    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...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 13, 2016 at 10:36 pm

    #1851809

  • RE: Stop deletes on a table

    johnwalker10 (1/13/2016)

    to stop some users from deleting records from a table

    DENY DELETE ON OBJECT::dbo.table_to_deny TO restricted_user;

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

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 13, 2016 at 10:34 pm

    #1851808

  • RE: Data Source Schema Changes..

    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...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 13, 2016 at 7:26 pm

    #1851794

  • RE: TSQL that outputs to XML

    Duplicate post:

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

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 13, 2016 at 7:20 pm

    #1851793

  • RE: SQL query that outputs to XML

    .

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 13, 2016 at 7:17 pm

    #1851792

  • RE: Make simple HTTP call from SSIS?

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

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 13, 2016 at 7:16 pm

    #1851790

  • RE: how to Select getdate () in yyyy/M format ?

    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....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 13, 2016 at 7:14 pm

    #1851789

Viewing 15 posts - 511 through 525 (of 7,164 total)