Forum Replies Created

Viewing 15 posts - 16 through 30 (of 96 total)

  • RE: Receive AS400 file to windows

    Welsh Corgi (2/7/2012)

    quillis131 (2/6/2012)

    Koen Verbeeck (2/6/2012)

    What exactly do you mean with a file?

    A database table, or an actual file, such as a flat file (.csv)?

    Looking for downloading a file (.XYZ...

    February 7, 2012 at 12:33 pm

    #1444056

  • RE: Receive AS400 file to windows

    Koen Verbeeck (2/6/2012)

    quillis131 (2/6/2012)

    Matt Miller (#4) (2/6/2012)

    AS400 is a midrange operating system (think mainframe). You're not going to be able to hook up to it directly because it has...

    February 7, 2012 at 9:43 am

    #1443920

  • RE: Receive AS400 file to windows

    Matt Miller (#4) (2/6/2012)

    AS400 is a midrange operating system (think mainframe). You're not going to be able to hook up to it directly because it has a very different...

    February 6, 2012 at 5:55 pm

    #1443506

  • RE: Receive AS400 file to windows

    Phil Parkin (2/6/2012)

    quillis131 (2/6/2012)

    Koen Verbeeck (2/6/2012)

    What exactly do you mean with a file?

    A database table, or an actual file, such as a flat file (.csv)?

    Looking for downloading a file (.XYZ...

    February 6, 2012 at 1:23 pm

    #1443409

  • RE: Receive AS400 file to windows

    Koen Verbeeck (2/6/2012)

    What exactly do you mean with a file?

    A database table, or an actual file, such as a flat file (.csv)?

    Looking for downloading a file (.XYZ extension) from AS400...

    February 6, 2012 at 12:28 pm

    #1443376

  • RE: Excel Files issue, fails while set up as job.

    kramaswamy (12/27/2011)

    I could be wrong, but I'm pretty sure that excel 2007 files require a different connection manager than 2003. Did you try running two loops instead, one for the...

    December 27, 2011 at 9:27 am

    #1425765

  • RE: Truncation warnings

    Jeffrey Williams 3188 (11/28/2011)

    quillis131 (11/28/2011)

    kramaswamy (11/28/2011)

    Is it possible that you have spaces which you aren't counting? If SQL Server tells you the length is greater than 20, and when you...

    November 28, 2011 at 12:51 pm

    #1413615

  • RE: Truncation warnings

    Jason Selburg (11/28/2011)

    Use DATALENGTH instead.

    DECLARE @i VARCHAR(99)

    SET @i = '123 ' --- the #'s 1,2 and 3 plus two spaces

    SELECT len(@i), datalength(@i)

    Thank you ...Its helped me a lot

    November 28, 2011 at 12:49 pm

    #1413614

  • RE: Truncation warnings

    kramaswamy (11/28/2011)

    Is it possible that you have spaces which you aren't counting? If SQL Server tells you the length is greater than 20, and when you count the characters you...

    November 28, 2011 at 10:51 am

    #1413560

  • RE: Special Character appending on Flat file

    Please refer to Attachments:

    I have no idea ... how this JAVA code works ... But finall Thats the file it generates... Coming to issue, If you look at the...

    November 17, 2011 at 4:09 pm

    #1409618

  • RE: Special Character appending on Flat file

    Martin Schoombee (11/17/2011)

    quillis131 (11/17/2011)

    Martin Schoombee (11/17/2011)

    Do you know the ascii code for it?

    Not sure about the ascil code, Looking forward to get Rightward arrow (?)

    If you find out what the...

    November 17, 2011 at 4:02 pm

    #1409612

  • RE: Special Character appending on Flat file

    Martin Schoombee (11/17/2011)

    Do you know the ascii code for it?

    Not sure about the ascil code, Looking forward to get Rightward arrow (?)

    November 17, 2011 at 11:31 am

    #1409432

  • RE: Appending 00 for column values

    I tried out some Tsql Format for the query ... Its was just getting what i need ... but It doesn't sound good for SSIS ... I guess SSIS...

    November 11, 2011 at 4:03 pm

    #1406614

  • RE: OLEDB COMMAND Usage

    kramaswamy (11/8/2011)

    There's no need to execute every one of those tasks. If you use a Conditional Split instead, you have all of them executing in parallel instead of in series....

    November 8, 2011 at 2:26 pm

    #1404852

  • RE: OLEDB COMMAND Usage

    kramaswamy (11/8/2011)

    You can't have multiple outputs from an OLE DB Source.

    What you'll need to do is put a Conditional Split, and direct each to it's own OLE DB Command

    have a...

    November 8, 2011 at 2:13 pm

    #1404844

Viewing 15 posts - 16 through 30 (of 96 total)