Forum Replies Created

Viewing 15 posts - 136 through 150 (of 290 total)

  • Reply To: Indexing Tables

    Jonathan AC Roberts wrote:

    If the index doesn't already exist you need to remove DROP_EXISTING = ON from the index creation or set it to OFF.

    If I do that then I get an...

    April 9, 2023 at 3:05 am

    #4171127

  • Reply To: Indexing Tables

    frederico_fonseca wrote:

    Intellisense telling you it thinks there is an error isn't the same as having an error.

    so do you GET an error when you execute the code?

    does the index not...

    April 9, 2023 at 3:03 am

    #4171126

  • Reply To: Indexing Tables

    Jeff Moden wrote:

    You cannot do INCLUDEs on Clustered Indexes, period.  The reason why is that the Clustered Index IS the table and it already includes all the data.

    I posted a link...

    • This reply was modified 1 year, 7 months ago by  water490.

    April 8, 2023 at 5:13 am

    #4170823

  • Reply To: Indexing Tables

    Hi everyone

    I had a bit of time to work on my side project.  I am getting "Cannot specify included columns for a clustered index" error.

    Here is my script:

    

  • This reply was modified 1 year, 7 months ago by  water490.
    •

April 8, 2023 at 4:30 am

#4170813

  • Reply To: Indexing Tables

    I have a script that was running fine but today it is taking way too long.  I looked at the script and I see these errors:

    "cannot specify included columns for...

    March 19, 2023 at 10:43 pm

    #4162583

  • Reply To: Records Are Not Sorted by Date

    it worked!  thank you so much

    March 18, 2023 at 9:25 pm

    #4162375

  • Reply To: SSIS CSV File Failed To Load

    Thank you so much for the solution.  It works perfectly.

    March 18, 2023 at 1:27 am

    #4162146

  • Reply To: SSIS CSV File Failed To Load

    here is a picture of what I am seeing the preview option.  It has the leading zero missing:

    Screenshot 2023-03-17 173920

    Yet, the OLE DB preview is showing the...

    • This reply was modified 1 year, 8 months ago by  water490.

    March 18, 2023 at 12:39 am

    #4162142

  • Reply To: SSIS CSV File Failed To Load

    thank you for the reply.  I tried that and the consuming app still didn't recognize the CSV.  I figured out what the problem is but I do not know how...

    • This reply was modified 1 year, 8 months ago by  water490.

    March 18, 2023 at 12:12 am

    #4162126

  • Reply To: SSIS Error

    thank you both!  it works

     

    • This reply was modified 1 year, 8 months ago by  water490.

    March 15, 2023 at 5:47 pm

    #4161083

  • Reply To: Stored Procedure to Output CSV from Select Query

    i found a way better way to do the same thing.

    https://analytics4all.org/2018/03/10/ssis-lesson-1-export-to-csv/

    it works and its safe.  none of the headaches with the original approach I was trying earlier

    March 13, 2023 at 3:34 am

    #4159976

  • Reply To: Stored Procedure to Output CSV from Select Query

    frederico_fonseca wrote:

    while still putting emphasis on what Jeff stated with regards to company data on a local PC I am still supplying what I consider would be the better approach...

    March 12, 2023 at 10:43 pm

    #4159941

  • Reply To: Stored Procedure to Output CSV from Select Query

    Jeff Moden wrote:

    water490 wrote:

    Jeff Moden wrote:

    It doesn't close any "security hole".  Only the people that can enable it can use it.  Turning it off won't prevent that.

    As to your "access denied" error,...

    March 12, 2023 at 10:39 pm

    #4159940

  • Reply To: Stored Procedure to Output CSV from Select Query

    Jeff Moden wrote:

    It doesn't close any "security hole".  Only the people that can enable it can use it.  Turning it off won't prevent that.

    As to your "access denied" error, where is...

    March 12, 2023 at 2:08 am

    #4159776

  • Reply To: Stored Procedure to Output CSV from Select Query

    What do I need to do to give SS the appropriate permissions?  I plan to revoke them once the query is done.

    March 12, 2023 at 1:23 am

    #4159771

    • Viewing 15 posts - 136 through 150 (of 290 total)