Thanx, That was basically the type of information i was looking for. Now i have to sort out how to implement a FileSystem watcher within the dts Script...

Then either use an command line unicode converter through the Execute process task  or if you have access to the file output application , modify it to replace all non...

look at http://www.sqldts.com/default.aspx?246, they have a dts package source code called looping, importing and archiving. Your process is similar to that one.

The only modifications you'll have to implement...

here is the way i would implement it:

 on point 1:

1. Create two connection one for the server , one for the XLS file

2. Create as many tables as workbook needed ...

Data's definition is more important than the data itself.

can you tell me what was wrong ( i haven't tested your code yet) . I can't see why you turned...

Ok here is the code:

Table Cust definition:

Cust_Key  Varchar(50) null,

Cust_CompanyName Varchar(50) not null,

Cust_CompanyAdress Varchar(255) null,

Cust_GroupID int null,

the table cust contains duplicate rows.

The code below is what i use...

Thanx all for your comments ,

but it doens't work.

I suspect some problems with the equalities test (i.e: Col1=a Col2=B etc) in all the queries involving such test. While it...

This might be a security problem. Check if the user executing the SP or the account under which the SQL server is running has enough right to access to network ressources...

maybe this could help:

if instr(fil.path,".dlt") > 0 then 

     '****  import this file***

else

   '*** Check another file name ***

end if

Be carefull that ".dlt" is not used within the file path but in...

Thank you Both,

The timer is working perfectly.

J.

Yep i am aware for this , but to be honest i haven't faced this situation during the test phases.

Also , The script has a mechanism for re processing the uncomplete files which is i...

That is what I wanted,

Many thanx,

Well I did that for a previous job, but each time the processing time was above 60 sec, the job scheduler launch the same job again before the end of the...

Any way of doing it with VBSCRIPt inside of an ActiveX Task?

J.

Thanx ,

Finally i found out , the commit transaction and close connection properties of the executeSQL task were checked. so it seems that it was not considered as a...