Forum Replies Created

Viewing 15 posts - 7,261 through 7,275 (of 13,879 total)

  • RE: SSIS : script task

    Nikku (4/13/2016)

    Hi Phil,

    Cell A Cell B Cell C Cell...

    April 14, 2016 at 4:42 am

    #1871933

  • RE: Actually need to use ? in Where clause

    Sergiy (4/13/2016)

    Are you sure those are actually question marks?

    Those might be characters not from your default code page.

    Because you import some sort of unicode strings into varchar columns those characters...

    April 13, 2016 at 5:47 pm

    #1871890

  • RE: Excel Source file problem running in SQL Agent

    In SQL Agent, edit the job step.

    Click on the Configuration tab and then the Advanced tab. Check that the '32-bit runtime' check box is selected.

    April 13, 2016 at 5:06 pm

    #1871886

  • RE: Actually need to use ? in Where clause

    pvong (4/13/2016)

    I have a problem where an SSIS import will give me some ? characters in my varchar column. I want to run an update command where it will...

    April 13, 2016 at 2:39 pm

    #1871866

  • RE: Reassign sequential group numbers to results of DENSE_RANK?

    Ordering the output by the IDENTITY column makes this a challenge, as I am sure you are aware.

    What is the difference between the first batch of NULLs and the second...

    April 13, 2016 at 2:10 pm

    #1871861

  • RE: Excel Source error code 0xC020801C.

    uzn2010 (4/13/2016)

    I observed this second error in Execution task

    [Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB...

    April 13, 2016 at 10:07 am

    #1871781

  • RE: Loading files in parallel

    richardmgreen1 (4/13/2016)

    The files contain different data (and headers) and are loaded via a BCP routine.

    The targets are also dealt with in a similar fashion (the target SQL table is starts...

    April 13, 2016 at 9:14 am

    #1871748

  • RE: Excel Source error code 0xC020801C.

    uzn2010 (4/13/2016)

    No, excel file did not change. No columns added or renamed. Everything is same.

    OK, thanks.

    Now, regarding this part of the error message:

    There may be error messages posted before this...

    April 13, 2016 at 9:11 am

    #1871746

  • RE: Excel Source error code 0xC020801C.

    uzn2010 (4/13/2016)

    I'm seeing this error when I'm trying to use Sql Command in the Data Access mode. I'm trying to skip 9 rows. In this try i tried to skip...

    April 13, 2016 at 8:35 am

    #1871725

  • RE: Loading files in parallel

    richardmgreen1 (4/13/2016)

    Hi Phil

    Yes, each file goes into its own table and is further processed by SQL separately.

    That's a good start.

    Do the source files and target tables have the same formats?...

    April 13, 2016 at 8:34 am

    #1871723

  • RE: Loading files in parallel

    richardmgreen1 (4/13/2016)

    Hi all

    I've got an SSIS package that loads 140+ files sequentially.

    I want to make it process the files in parallel (for example, 4 at a time) by checking the...

    April 13, 2016 at 8:10 am

    #1871702

  • RE: SSIS : script task

    Nikku (4/13/2016)

    Hi All,

    I have one predefined excel sheet where multiple columns are present in scattered form.

    I want to load data for respective column in respective excel cell dynamically. Those headers...

    April 13, 2016 at 7:59 am

    #1871695

  • RE: Print Object Explorer panel?

    doasidont (4/13/2016)

    Aside from Print Scr, is there a way to print the Object Explorer window?

    Thanks.

    Not that I know of.

    April 13, 2016 at 7:57 am

    #1871694

  • RE: find date value from file name

    Manic Star (4/13/2016)

    The easiest way to do this would be to point a For-each container at the directory containing the files, set the mask to either be everything, or filter...

    April 13, 2016 at 7:56 am

    #1871693

  • RE: Excel Source error code 0xC020801C.

    Has the format of the Excel file changed at all? Sheet name different? Column names different? New columns added?

    April 13, 2016 at 6:52 am

    #1871668

Viewing 15 posts - 7,261 through 7,275 (of 13,879 total)