DTS...help! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

DTS...help!

Author

Topic

brendalisalowe
Constraint Violating Yak Guru

269 Posts

Posted - 2004-06-25 : 15:20:38

Is there anyway to use DTS to export data, but not have a delimiter at all included into the textfile I export it to? I just need exactly what I have in the table exported into a text file. Or do I neen to use VB.NET or something to do it?

PLEASE HELP!

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-06-25 : 15:26:45

export it as fixed, or if that isn't an option convert the data to one nvarchar column and export that

Corey

brendalisalowe
Constraint Violating Yak Guru

269 Posts

Posted - 2004-06-25 : 15:32:54

If I export it as fixed, it puts spaces between it right?

How would I put it into one nvarchar column if I need to do that?

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-06-25 : 16:06:29

Yeah it would spaces in it if fixed

How many columns are in the table??

Select convert(nvarchar,Col1) + convert(nvarchar,Col2) + ... + convert(nvarchar,Coln)
From myTable

You could set up a view to do it...

Create View dbo.tableForExport
As

Select data = convert(nvarchar,Col1) + convert(nvarchar,Col2) + ... + convert(nvarchar,Coln)
From myTable
Go

Then just export the data from the view

Corey

brendalisalowe
Constraint Violating Yak Guru

269 Posts

Posted - 2004-06-25 : 16:14:48

How does converting it to nvarchar help put it into one column?

Brenda

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-25 : 16:15:27

Use + as mentioned in the other thread.

Tara

brendalisalowe
Constraint Violating Yak Guru

269 Posts

Posted - 2004-06-25 : 16:51:38

Can I be dumb? Thanks for the help! It works!

Brenda