sql server dts: DTS task -- sql server dts

Re: DTS task

Allan Mitchell
2/3/2005 7:03:49 PM

sql server dts:

The DataSource Property of the excel connection object is what you need
to change so look at this article and adapt

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

You can use rudimentary SQL syntax against a worksheet.

[quoted text, click to view]

DTS task

newbie
2/4/2005 12:15:26 AM

Hi,
I'm the newbie to DTS.
I've a listing of excel file that would like to load to the sql DB.
each excel file has a different name (i.e. prefix + yymmdd.xls) --> e.g.
dts050202.xls
And for each file, I would like to extract specific porton of data (e.g.
sheet1 first cell of column A1 down to the cell which is non null)

How can these be done ?
should I create a Active X task to perform the above job ?
Please kindly advice . thanks!

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.