I can't get XML from a SQL script into a Script Task....
This is what I do:
a)
In an SSIS-Package I've created a String type variable (MyNS::MyVar) and added a SQL Task.

Hello, can someone please suggest to me how I can keep my ftp connection from
timing out after a large file download?  
I am using SSIS and I have tried multiple ways of ftp'ing the files in my
directory to my local hard drive, but the tasks keep failing after a large

I want to create a package that will import data from 10 different servers
all with the same source table structure.  The destination table has a few
extra columns, like store number that needs to get set based on the server
that is currently being imported from.  The stores are ...

Is it possible to execute an SSIS (dtsx) package using AutoSys? If so how?

Hi I have a ssis package that has loads of transforms due to importing from
an AS400 to Sql server 2005. using SSIS with AS400 makes every character
column a unicode so the transforms are used to convert from unicode to
varchar where needed to succesfully import into the SQL ...

When I develop an SSIS package - I execute it in my computer, and can see when it runs (yellow), succeded (green) or failed (red); and how many records where processed.
When the package runs on the production server - how could I monitor it? Of course - I can analyze the execution ...

I am converting a SQL2000 DTS package to SSIS.  I need to connect to an
Oracle database which requires the password to be changed every 30 days.  The
DTS packages reads a table to get the userid and password and then uses a
Dynamic Properties task to update these values in the ...

I have a text file that I'm reading to load my  SQL database. The first
column the data has double quotes around it such as "2006Q3", how can I
remove the double quotes so that only 2006Q3 is loaded into my table?

Just installed SSIS and trying to access integration services from the
management studio ON the server, no firewall in between me and the server
and I keep getting an RPC error when trying to connect to integration
services.  I've telneted to the server on port 1433 and no ...

I can run an SSIS package using Managment Studio but can not create a Job.  I
am using named instances.
Error
Additional information:

My SSIS package uses a OLEDB connection manager. I'm storing the connection
string in a configuration file. There is only one task in my package. It is
a data flow task which inserts a record into a table. I have used
OnTaskFailed event handler at package level which sends an ...

I am just getting started with SSIS 2005 and have created a package with the
following steps:-
Sequence Container
   - Execute SQL Task (deletes records from 3 tables)

I've been trying to store a connection string in any kind of configuration. It seems SSIS never stores the password there.
Do I really have to always enter the password manually into the configuration value? Isn't there an option to have it persisted somehow? Why does the option ...

Todd & Matteus or anyone who wants to help.
My long journey is almost over.  I decided to start a new questions since
it's about Scripts.
Here's my scenerio.

I'm trying to program a Script Task to send HTML e-mail by following these
instructions...
http://msdn.microsoft.com/en-us/library/ms403365.aspx
No matter what I do I get this error at execution time...