<div>
What sort of trouble?<br />
<br />
You take a SQL connection, enter the right server, usr id, password, ...<br />
You take a text file (destination), and enter the file name, say it's delimited, use &quot;tab&quot; as the character that's separating columns, ...<br />
Put a data transfer task between them, enter a query as the source, ...<br />
<br />
should run.
</div>


What sort of trouble?

You take a SQL connection, enter the right server, usr id, password, ...
You take a text file (destination), and enter the file name, say it's delimited, use "tab" as the character that's separating columns, ...
Put a data transfer task between them, enter a query as the source, ...

should run.

<div>
I see no Transfer data task per se. I see a transform data, but it's a little confusing as to how to configure it. Or am I missing a task somehow?
</div>


I see no Transfer data task per se. I see a transform data, but it's a little confusing as to how to configure it. Or am I missing a task somehow?

<div>
<div class="content wysiwyg-content">
Does anyone know how to create a tab-delimited file from a SQL query from within a DTS package? Should be simple enough, but having some trouble.<br />
<br />
Thanks in adavnce,<br />
jm
</div>
</div>


Does anyone know how to create a tab-delimited file from a SQL query from within a DTS package? Should be simple enough, but having some trouble.

Thanks in adavnce,
jm

Creating Tab-delimited files from SQL 2000 DTS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.