I don't think you have to make any changes. It should...

Did you try using the standard ActiveX Script Task? It is for executing older DTS scripts and this script looks like it should execute properly.

Vijay,

Check this post by Matt Masson.

Hi David,

Why not try to export the Excel file content into CSV file and then use script to process this text file? You will still need Excel to do the...

Check this article by Todd McDermid. You have to apply the same process ,...

This is the problem. The component is for 2008 and you are using 2005. You can easily modify the component to work for 2005 ,...

What version of SQL Serve do you use? 2005 or 2008 ?

What is the exact error message?

What's the issue? Have you tried asking a question in...

Have you checked this component ?

erngreen (9/13/2010)

---

The flat file connection manager does not work for files with uneven column data. It works well in DTS but not in SSIS. The file is also delimited with...

Hi,

You should use Script Component, not Script Task and create Script Source. Two recommendations:

- Explicitly define the columns from the source and then define each and every column in the...

WayneS (9/9/2010)

---

I'm working on some SSIS packages. The data is extracted by years loaded into a table - each year is processed separately.

Part of the data extraction utilizes dynamic sql...

Scott-361039 (9/9/2010)

---

Hi

I am looking for some help with the following please:

I am passing out an excel file that will be emailed to a recipient and i would like to password...

Hi Arunvijay,

You have to install "Integration Services" on the target machine. This is an option in the SQL Server installation wizard.