Forum Replies Created

Viewing 15 posts - 8,866 through 8,880 (of 13,876 total)

  • RE: Specifying Multiple Text Qualifiers For A Flat File ETL

    Is there any way around this without doing some crazy file manipulation?

    1) Use a delimiter which does not appear in your data.

    2) Use SSIS 2012 onwards. See here.

    December 11, 2014 at 1:00 am

    #1763963

  • RE: Developer vs. DBA role

    JoshDBGuy (12/10/2014)

    Grant Fritchey (12/10/2014)

    Small company or not, I strongly recommend putting process for getting stuff out to production into place and following it religiously. The last thing you want are...

    December 10, 2014 at 10:10 am

    #1763850

  • RE: Using variable to evaluate part of file name?

    tiredofchoosing (12/9/2014)

    Oh, old files are not archived. They simply accumulate in the folder.

    This is not best practice – you should consider moving the files to a 'Processed' folder after they...

    December 10, 2014 at 12:21 am

    #1763695

  • RE: Using variable to evaluate part of file name?

    You could avoid the whole issue (assuming the import folder only ever contains the files to be processed, because processed files are archived) by using a FOREACH loop selecting files...

    December 9, 2014 at 2:16 pm

    #1763651

  • RE: SSIS Access

    What is the error?

    Is the server in the same domain as the machine she's trying to log in from?

    December 9, 2014 at 9:09 am

    #1763577

  • RE: Developer vs. DBA role

    butcherking13 (12/9/2014)

    She is currently developing stored procedures to automate several reports. Not sure what they have planned for her down the road.

    She has asked for sys admin rights because we...

    December 9, 2014 at 9:06 am

    #1763575

  • RE: Developer vs. DBA role

    butcherking13 (12/9/2014)

    Hello, I was looking for suggestions from the tenured DBA's here as I am a very new junior DBA.

    I work with one developer who has a few years experience....

    December 9, 2014 at 8:30 am

    #1763554

  • RE: Insert records into a table with an identity value

    Do not use SET IDENTITY INSERT ON – that is telling SQL Server that you wish to override the auto-increment for some reason. So given a table X

    Id int identity...

    December 6, 2014 at 11:09 am

    #1763126

  • RE: need to group values

    Can you write out the desired results, based on your sample data?

    If you could provide your input data in consumable (ie, runnable in SSMS) format, you will be more likely...

    December 6, 2014 at 5:29 am

    #1763117

  • RE: Hi guys, looking for suggestions

    What's your specific question please?

    December 5, 2014 at 8:11 am

    #1762985

  • RE: create filestream for filegroup for a DB in SQL Server 2008

    armm1388 (12/5/2014)

    Hi

    i have a DB in SQL Server 2008. and i wants to store file in DB.

    how can i create filestream for filegroup for a DB in SQL Server 2008

    Thanks

    Don't...

    December 5, 2014 at 3:36 am

    #1762905

  • RE: change name of FILEGROUP of a DB in SQL Server

    See here.

    December 5, 2014 at 1:33 am

    #1762880

  • RE: Update a record with a validation from other table

    skb 44459 (12/4/2014)

    Table to Update is CustomerCredit

    - Fields are CustomerNumber, CreditLimit

    Validation Table - UserAuthorization

    -Field UserID, Password

    I am writing an asp application where Fields on the asp form is CustomerNumber, CreditLimit,UserID...

    December 4, 2014 at 8:12 am

    #1762737

  • RE: Redirect duplicate records using ssis

    nhimabindhu (12/4/2014)

    Is there any other approach other than this which we achieve the result as per requirement.:-)

    If your requirement is such that terrible performance is acceptable, there is. Are you...

    December 4, 2014 at 4:23 am

    #1762661

  • RE: update query is slow

    manju.ccc (12/4/2014)

    Yes Phil all servers are identical. There are three servers in three different locations. One is publisher and other two are subscribers. OS is windows 2012 and SQL is...

    December 4, 2014 at 3:41 am

    #1762646

Viewing 15 posts - 8,866 through 8,880 (of 13,876 total)