SSIS Question Help

  • 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.

  • 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
  • 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

  • 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.

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

  • 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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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