Forum Replies Created

Viewing 15 posts - 3,271 through 3,285 (of 13,877 total)

  • Reply To: SSIS Excel Import Error

    No apologies are needed here!

    What I assumed you did was as follows:

    a) Have a sheet called AllDogs in your trial spreadsheet ... imports successfully.

    b) Have a sheet called (whatever) in...

    October 8, 2019 at 5:31 pm

    #3687110

  • Reply To: SSIS Excel Import Error

    So this bit

    BTW, I did try renaming the sheets after the C & P to no avail

    wasn't quite true? 🙂

    Changing your code to accommodate the space character should be trivial.

    October 8, 2019 at 4:52 pm

    #3687082

  • Reply To: SSIS Excel Import Error

    Can you create a couple of screenshots & paste them in, as follows:

    1. Showing the trial Excel file, with headings & first 10 rows
    2. Showing the prod Excel file, with...

    • This reply was modified 6 years, 11 months ago by Phil Parkin. Reason: Fix typo

    October 8, 2019 at 3:49 pm

    #3687051

  • Reply To: Add row number column based on id and stages

    I don't understand the logic for setting rownum. Can you explain it, please?

    October 8, 2019 at 3:23 pm

    #3687045

  • Reply To: SSIS Excel Import Error

    Sheet names being different is critical ... unless you are handling it dynamically in your package, which is a little advanced.

    Try renaming the sheet after cut & paste from trial...

    October 8, 2019 at 3:17 pm

    #3687042

  • Reply To: SSIS Excel Import Error

    Are you using code (rather than a data flow) to transfer the data? If so, please explain why. And consider adding some TRY/CATCH error handling to help you diagnose the...

    October 8, 2019 at 2:37 pm

    #3687025

  • Reply To: SSIS Excel Import Error

    I sympathise!

    On which component is the error happening, exactly?

    Are your production files stored locally, or on a network drive somewhere?

    October 8, 2019 at 1:56 pm

    #3686997

  • Reply To: XML get result

    DesNorton wrote:

    It is not possible, as the value "Avis" does not exist in the sample data

    I usually have a bad reaction when people use absolutes. Never say never 🙂

    October 8, 2019 at 12:44 pm

    #3686952

  • Reply To: Table Function becomes slow

    balestragerman wrote:

    Hi folks, I have a 2012 sql and it works very fast, one of the most used queries is a table function. This function over time becomes slow and...

    October 8, 2019 at 12:33 pm

    #3686944

  • Reply To: Export to csv then FTP using variables

    I imagine that you've called your variable something like 'FileName', and not "C:\SCRIPTS\SQLServersExport_20191007.csv"!

    Thus, I suspect you need to revisit the various relevant properties in your package components, looking for incorrect...

    October 7, 2019 at 1:28 pm

    #3686672

  • Reply To: compression file - Error: Exception has been thrown by the target of an invocati

    Please expand on what you have provided, to include

    a) Your question

    b) Which line throws the error, and an outline of what you are trying to achieve

     

    October 6, 2019 at 8:28 pm

    #3686414

  • Reply To: Insert forum posts/threads in the DB table

    C#, maybe.

    October 5, 2019 at 5:07 pm

    #3686275

  • Reply To: How to return lowest level parts from BOM

    As long as max level is the same for all of the lowest-level items, that is. Otherwise, it gets trickier.

    October 4, 2019 at 6:37 pm

    #3686128

  • Reply To: How to return lowest level parts from BOM

    Add hierarchy level to your CTE and base your selection on that?

    October 4, 2019 at 3:42 pm

    #3686084

  • Reply To: T SQL While Loop - Into a Temp table for final output

    Why do you refuse to format your code?

    Your SELECT should be outside of your WHILE loop.

    October 4, 2019 at 2:59 pm

    #3686063

    • Viewing 15 posts - 3,271 through 3,285 (of 13,877 total)