Post reply

SSIS Question Help

  • October 23, 2013 at 3:13 pm

    #284900

    Hi Guys,

    I have quick question, I would like to know I want to create a simple SSIS

    Package, My source is SQL and destination would be .DAT file. My question is

    which Destination should I use for .DAT file. I never work on .dat file.

    I have to create .DAT file as a destination(Client Requirement).

    Any advise would be great appreciate.

    Thank You.

  • October 23, 2013 at 3:52 pm

    #1661111

    What format would the DAT file use?

    Wouldn't a flat file with DAT extension would be enough?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 24, 2013 at 1:54 am

    #1661161

    It would be useful if you would supply us some sample data for the .dat file.

    But as Luis suggested, a flat file destination will probably do the trick.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 24, 2013 at 11:11 am

    #1661397

    Here is the Sample Data

    ID,DISTRIBUTOR BCITY,ACCOUNT ID TYPE,ACCOUNT ID

    DS,BP9744524,CARLSBAD,D,BR9307299,UNKNOWN

    I can Open this .DAT file in Notepad. Client just want above format files in .DAT format.

    Please guide me or you want more information, let me know.

    Thank You.

  • October 24, 2013 at 11:52 am

    #1661410

    I am thinking, how I about I rename a file from txt file to FileName.bak, would that be good?

  • October 24, 2013 at 12:02 pm

    #1661414

    rocky_498 (10/24/2013)

    I am thinking, how I about I rename a file from txt file to FileName.bak, would that be good?

    Yes. You can also specify the filename.dat in the flat file connection manager directly, no need to rename.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 25, 2013 at 4:07 am

    #1661568

    rocky_498 (10/24/2013)

    Here is the Sample Data

    ID,DISTRIBUTOR BCITY,ACCOUNT ID TYPE,ACCOUNT ID

    DS,BP9744524,CARLSBAD,D,BR9307299,UNKNOWN

    I can Open this .DAT file in Notepad. Client just want above format files in .DAT format.

    Please guide me or you want more information, let me know.

    Thank You.

    That looks like standard CSV format.

    .DAT does not define a file format, it's just a file name, nothing more. You can write directly to a flat file with a .DAT extension, no need for any renames.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • October 29, 2013 at 11:36 am

    #1662476

    Awesome!!!!

    This question is ANSWER....

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply