Data Transfer problem - 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

Import/Export (DTS) and Replication (2000)

Data Transfer problem

Author

Topic

karan@talash.net
Starting Member

12 Posts

Posted - 2003-06-25 : 02:53:05

HI Friends,
I am trying to transfer some data from an excel sheet to sql server table using dts. I have a field in the execl sheet which has huge data. It may have data upto 4000-5000 characters.

When i am transfering it to the sql server, data upto 1000 characters are only transferred, the remaining part is truncated. I have the field type of the destination table as varchar(5000), i have also tried nvarchar(4000) but there is no change in result.

Kindly suggest what may be the problem.

Regards
karan

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-06-27 : 16:00:05

Hi, karan!

Use this trick (*.xls >> *.txt >> DTS). Seems it's the only way out. :(
Add this into your package:

1. Active Script Task...

Dim e
'6 xlCSV, 21 xlTextDOS, 23 xlCSVWindows, 42 xlUnicodeText
Set e = CreateObject("Excel.Application")
e.Visible = False
e.DisplayAlerts = False
e.Workbooks.Open "D:\my.xls"
e.ActiveWorkbook.SaveAs "D:\my.txt", 21
e.Quit
Set e = Nothing

2. Bulk Insert Task...

And remember Workflow.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources