This looks like fairly simple script. It would help if you can publish the exact error you get when you run the script. If you have other ActiveX scripts working...

secretshifter (6/15/2009)

---

Hi..

I have created a simple SSIS package using ole db source and oledb destinations to copy data from one db to other.

When m trying to execute this package..during execution...

secretshifter (6/15/2009)

---

Hi,

I have used protection level "Encrypt sensitive data with password"and set the job step type to "SQL Server Integration Services Package"...but i dont know how to include the...

My friend,

No direspect, but you are wrong about the 90% argument. It is called "SQL Server Integration Services" platform for a reason. It does imply that it is expected to...

RBarryYoung (6/14/2009)

---

CozyRoc (6/14/2009)

---

I understand what you mean. But this will work only when using windows authentication. If you use a database, which doesn't support windows authentication then you have to...

RBarryYoung (6/14/2009)

---

CozyRoc (6/14/2009)

---

This will not be enough. When you use...

This will not be enough. When you use this option,...

secretshifter (6/12/2009)

---

Hi,

I have created a SSIS package which contains OLE DB sources and OLE DB destinations and encrypted sensitive data with password.

When I run this package from visual studio...

Griffster (6/11/2009)

---

Is it possible to change the value of a user variable from within a data flow task please? I'm trying to change a package level variable's value within a...

David Brea (6/12/2009)

---

I had tried to install a Driver, but its only install on ODBC, and it never shows itself at the list in the destinations window at the wizard...

I'm sorry. I didn't understand properly. So if you want to use macros to do formatting of the data after you insert then this will obviously not work. And yes,...

The recommended solution is to setup template excel workbook with the required macros, worksheets inside and then use the Jet provider to populate specific portions with data. In this way...

washawgolla (6/11/2009)

---

THant was a helpful response cosyRoc; I am having this problem to import those xml files to a table using SSIS

[SQL Server Destination [2984]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER....

This is a double post. Your question is answered here.

skids (6/10/2009)

---

Hi,

I thought I'd use Script Task and use VB .Net to open an excel workbook but for some strange reason there's no COM tab in the Add Reference...