Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Question Help Expand / Collapse
Author
Message
Posted Wednesday, October 23, 2013 3:13 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 208, Visits: 763
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.
Post #1507832
Posted Wednesday, October 23, 2013 3:52 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:29 PM
Points: 3,513, Visits: 7,565
What format would the DAT file use?
Wouldn't a flat file with DAT extension would be enough?



Luis C.
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?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1507839
Posted Thursday, October 24, 2013 1:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:28 AM
Points: 13,570, Visits: 10,447
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1507907
Posted Thursday, October 24, 2013 11:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 208, Visits: 763
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.
Post #1508184
Posted Thursday, October 24, 2013 11:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 208, Visits: 763
I am thinking, how I about I rename a file from txt file to FileName.bak, would that be good?
Post #1508201
Posted Thursday, October 24, 2013 12:02 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:28 AM
Points: 13,570, Visits: 10,447
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1508206
Posted Friday, October 25, 2013 4:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 5,035, Visits: 11,772
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1508393
Posted Tuesday, October 29, 2013 11:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 208, Visits: 763
Awesome!!!!

This question is ANSWER....
Post #1509497
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse