I came across this page a while back but never got around to trying it out. Might help you out and I would be interested to know if you can...

What data type is the column your are importing into?

Also, what length have you specified?

For a fullproof method, do the following.

Add a Execute SQL Task and name it drop table. Point the connection to the excel file - NOT the db connection. Code the...

Not that hard but rather than re-invent the wheel:

http://vyaskn.tripod.com/code.htm#propercase

Excel guesses where it think the eof occurs. If any cells have been blanked for example, it may still keep the same pointer.

The best way to see where excel assumes...

It depends upon what front end you are going to allow the users to access the data from.

If you are using the web, you can create an asp page and...

As far as I know text files are treated differently and import various data types in the same column with no problem.

I have never had the same problem, so...

DTS by default checks the first few rows of data and then determines the type it expects. If it sees something different it will ignore the value and bring in...

Best way is to use mkdir command

exec master.dbo.xp_cmdshell 'mkdir "c:\temp\foldername\"'

This code goes into a normal sql statement. Just select the foldername from your table into a variable and replace 'foldername'...

I know you can put it into the format as shown, but...

If you use the xml template generator in word 2003 you get real problems. Try out this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_wd2003_ta/html/odc_wdxmlresumetemp.asp

The...

Not wanting to get into an argument here, Kenneth, but I stand by my point and hope to clarify a little more.

If you have multiple authors with a first name...

See this link http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=184423#bm184434

In that case, you will find that when you run the package, it is running it against your nt login account and using your outlook mail box.

When you run...

I thought your article was simplified and made easy reading. Hiowever, you did miss out on some of the limitations of xml.

The main limitation being that xml cannot handle...

There are a number of ways to import xml into sql server. Personally, I favour the approach of using ado to retrieve the data into a recordset and then populate...