Problem with defining columns in DTS

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

Import/Export (DTS) and Replication (2000)

Problem with defining columns in DTS

Author

Topic

kamann
Starting Member

5 Posts

Posted - 2006-01-24 : 10:33:20

I set up a package to export data from a table to a flat file.

There are three date/time fields who's format I want to change (from mm/dd/yyyy to yyyymmdd). I click on "transformations" there are no destination columns. When I click on "destinations" and "define columns" EM shuts down.

What's the lady doing wrong?

K

mcarahul
Starting Member

11 Posts

Posted - 2006-01-25 : 03:30:42

Click destination. Click on define columns then click execute after defining.
Then go to transformations.

Rahul Sharma

kamann
Starting Member

5 Posts

Posted - 2006-01-25 : 11:33:14

Rahul that is the problem...when I click on "define columns" EM shuts down.

K

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-01-25 : 11:37:35

What SP are you on? I used to get this problem on SP2 (I think).

kamann
Starting Member

5 Posts

Posted - 2006-01-25 : 12:33:45

we are on SP3

K

kamann
Starting Member

5 Posts

Posted - 2006-01-25 : 12:38:55

correction -- SP4

K

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-01-26 : 06:39:59

Are you SP4'd on both the server and your local client?

kamann
Starting Member

5 Posts

Posted - 2006-01-26 : 15:39:03

No I was not SP4'd on both the server and the client. I did, however, re-create from scratch the package directly on the server instead and got the same result.

K

rmason
Starting Member

12 Posts

Posted - 2006-02-06 : 05:25:29

Hey,

I'm also experiencing this error... did you find a solution kamann.

Cheers
Rob.

nr
SQLTeam MVY

12543 Posts

Posted - 2006-02-06 : 07:01:03

Sounds like it's having trouble connecting to the destination file.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

AdamKB
Starting Member

2 Posts

Posted - 2006-02-10 : 10:22:38

Please add me to the list of people with this exact problem... Any advice would be greatly appreciated.

AdamKB
Starting Member

2 Posts

Posted - 2006-02-14 : 14:27:02

I found this:
http://support.microsoft.com/kb/818540/EN-US

Gili
Starting Member

42 Posts

Posted - 2006-02-19 : 03:37:04