"Imports some tables from Access"; from what Access, the same db? To the same db? What is your source and what is your destination? 

There are lots of examples of vb code that executes...

It sounds to me that what you need is to use in MS_SQL dynamic query. That is:

DECLARE @sql_batch AS nvarchar(4000)

DECLARE @table AS nvarchar(128)

DECLARE @field AS nvarchar(128)

SELECT @table='Categories', @field='CategoryName'

SET @sql_batch='SELECT

Yes you can, in a dtsrun utility command you can pass in the server name, the login AND the DTS package global parameters. Same thing if you use the sp_OAs.

You...

"First of all thanks every body your feedback & i appreciate that. i am going to get pipe delimiter txt file with most of dupllicate rows with same customer...

You will find answers to your problem on http://www.sqldts.com/. You can use osql utility from a vb script and/or .bat file to deploy packages; you can pass in the server...

You can execute the package from a stored procedure and then call that stored procedure from the trigger. (1) There are some internal MS-SQL stored procedures that can create objects and...

a dts package that uses sql statements must have a conection to a database of any kind. if it doesn't have it won't work. if the computer you run the...