I use protection option "Encrypt all data with password" to protect package
content. At the beginning everything is ok: when I want to open the package
I must provide a password. The problem is that when I run the package I must
give the password again.

Using this
examplehttp://msdn2.microsoft.com/en-US/library/ms135917(SQL.90).aspxgives
me:
"A requested parameter does not exist in the package"

I have an SSIS package that should copy a table from a backup database to a
production database. Both databases are SQL Server 2005 and are on the same
physical server. The package runs without an error, but the table is not
copied. I specified the table in the table Collection. ...

I was reading the article:
http://www.codeproject.com/useritems/Schedule__Run__SSIS__DTS.asp
I followed his instruction until I reached "Package Source: File System.
but I can not find the option. I am using SQL Server 2005 developer Edition.

I have a small group of developers that need access to deploy and execute
packages. They could have 'full' access to every thing within SSIS however I
do not want them to have full access to SQL Server 2005.
How do I acheive this?

Iam trying to dynamically set the connectionstring property of ADO.NET(odbc
data provider) connection manager. I have stored the connection string in a
text file. First I am reading  this string into a package variable and then
trying to set the connectionstring property of the ...

I have SSIS package running within Agent’s Job; the same job on several
servers in my organization.
Package execution time is approx 2-3 sec. At some servers total job
execution time is equal to package execution time; at some servers total job

I have ADO.NET(ODBC Data provider) connection manager in my SSIS package( I
am connecting to CacheDatabase on a remote machine using ODBC driver(System
DSN)).
Iam trying to change the connection manager properties i.e. connection

Hi NG,
I am pretty new to IS and trying to create a first solution. I am reading in
a flat file, getting some variables and writing it to an oracle db (9i).
Anything works fine except a Sql Execute Task that should give me the result

I've read a few posts about adding rows to the output buffer of a
script component. I need to add rows in certain instances, and tried
the command Output0Buffer.AddRow()
Even though my output is named Output 0, it doesn't recognize

Anyone know a way to set the default datatype for Identities?
I'm importing an XML document into SQL Server and every time I set up a SQL
Server Destination, the identity columns default to DT_UI8. I don't even
think it's possible to set a SQL data column to an unsigned integer. ...

Hello! I need call stored procedure for source data and OLE DB Command is
the best for it. But there are some conditions to fail in my proc (by
raiserror, e.g.) and in this case i want to log failed data. But when fail
occures then whole data flow task is terminated and error output ...

I am getting tilde(~) separated csv. and the client will not give any other
format.How to handle this in SSIS?
Thanks in advance,
Remo

Trying to sort out how to use the configuration options to easily promote a solution up the environments Dev/Test/Prod.
I found some stuff on how to create an XML file to use as the config setting - but it seems like I also would set something up using Configuration Manager?

I am trying to migrate data from a number of denormalized source tables to a
new set of normalized tables in another SQL database. For example, I have a
Patient source table with multiple phone# fields that I want to split into a
Patients table and a PatientPhone table. What's ...