Dts export to file

If you're looking for something else, see Related tasks and content. Run the bit version of the wizard unless you know that your data source requires a bit data provider. Tap the F1 key from any page or dialog box of the wizard to see documentation for the current page. You don't have to take any action on this page.

If you prefer to see screenshots. It's easy to join and it's free. Register now while it's still free! Already a member? Close this window and log in. Join Us Close. Join Tek-Tips Forums! Join Us! I am trying to take one table 38 columns 1 x char 35 , 1 x char 3 and 36 x char 8 and using DTS to export it to a Text File. When developing the package, creating the Transform task between the Database connection SQL Server and the text file connection. I have done this many times before and tested against other tables today successfully.

First I thought there may be something wrong with the table, however there is not and what I am thinking is it because the table has too may columns for a text file to handle? I would appreciate some advice on this. Hi Andy — Why not avoid the problem and use something like bcp or even script rather than a data pump task?

Thanks for the reply and I would agree with you in most cases, however in this case I have chosen this option as I have to manipulate the data a little beforehand by adding some leading zero padding and other data formatting stuff.

It seems to make sense to do this in the DTS package as an SQL task, then output the results to a text file in exactly the format the administrator receiving this file needs. I would not trust that complex task to DTS, rather do it in a stored proc and call dtsrun to do the final transfer. Thanks for the reply. I cannot get to the stage of viewing a log because it is not possible to complete the transform task between the database and the destination text file, this is the original problem when arriving at the transform tab in setting the properties of the transform task whereby the columns defined are actually not being defined.

It seems that DTS is not recognizing the columns to the destination text file for some reason. Now as you mention logs, in the destination tab where the text file is set up, there is an option to Define Columns, when first setting up it automatically opens this dialogue and can be configured at this stage, however — if after doing this, I click on Define Columns again, I get an error message which appears naturally in the Application list of the Event Viewer:.

Totally confused! Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.