How to export data from a table into a text file in SSIS?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Gogula G. Aryalingam SSCrazy Points: 2688 More actions · Answer 1

Hi,

Is it possible to be a little more specific regarding the Lookup part? Are you looking up a table? And what sort of problem are you getting?

Regards,

Gogula

ruchi-761283 SSC-Addicted Points: 434 More actions · Answer 2

Hi,

Data flow task I have successfully added, but now getting error on FTP task.

While executing package it's giving error: Flat file connection manager is not a file."

In FileTransfer :Flat file connection manager is given as al ocal path.Do I need to provide something in Remote path also?

pduplessis-723389 SSChampion Points: 10599 More actions · Answer 3

I am assuming that you want to upload to a FTP destination from a local path.

So you would require the remote FTP path in your FTP task, as well as the local file.

Trust this helps

~PD

Sara_DBA-629440 Right there with Babe Points: 721 More actions · Answer 4

Hi, you can do the following to export data from table to file

DECLARE @sql VARCHAR(2000)

DECLARE @DAY VARCHAR(20)

DECLARE @FILE VARCHAR(100)

DECLARE @DIR VARCHAR(100)

DECLARE @TABLE VARCHAR(100)

SET @DIR = 'G:\DRIVE\'

SET @TABLE = '"SELECT * FROM DATABASE.DBO.TABLE"'

SET @DAY = CONVERT(VARCHAR(20), GETDATE(), 102)

SET @DAY = REPLACE(@DAY, '.', '_')

SET @FILE = FILENAME_' + @DAY + '.txt'

SET @sql = 'BCP ' + @TABLE + ' QUERYOUT ' + @DIR + @FILE + ' -c -t, '

EXECUTE master..xp_CmdShell @sql, NO_RETURN

HOPE THIS HELP

[font="Comic Sans MS"]Sara[/font]

A ship in the harbour is safe . . . but that's not what ships were made for. 😀