here is a nice example in how to use global variables and sp's

http://www.sqldts.com/default.aspx?234

JFB

Probably yoy have this problem

http://www.sqldts.com/?297

JFB

Make sure the user name that creates the dts package has permissions to use sql agent as schedule job.

Also you can't use mapped drives in a schedule job.

Regards...

JFB

Hi Tom, this is one idea...

1.import the txt file or files to a temporary table.

2.using Execute sql task you can delete all the records that already exist in you master table.

3.import the...

Could be time, make sure you have Connection timeout setup properly in the disconnected edit option menu.

Also double check you code, looks like a connection still open.

Regards

JFB

You probably can create a loop using Bulk insert task. To have an idea in how to perform a loop, check this link:

http://www.sqldts.com/?246

JFB

If you have all setup for a text file, it should be easy to create a html file. Get more info about sp_makewebtask, sp_runwebtask and sp_dropwebtask procedures from BOL.

JBF

Check "Close connection on completion" in the workflow properties for each step.

Let me know if this works.

JFB

Each step has an rollback transaction under workflow properties. If you check this in  all steps it should rollback the dts pkg.

Regards

JFB

Which log file? Give us more details... What are you trying to do?

Remember FTP tool is only for get files from an ftp not to put files.

Regards

JFB

Use save as but change the location to structured storage file(file.dts). Transfer this file to you server and open there. It should work. Please let me know.

Regards

JFB

Nope... you need to create you own program

JFB

Nope... you have to create you own.

JFB

You file needs to be clean up before using dts, for this you can create a regular expression to clean you file in vb and execute the DTS package using...

You can execute a dts package using vb, vb.net or using asp over the internet. What are you trying to do?

JFB