Your wish is my command. This should comment out the schedule_uid parts.

For a sql server login I can not think of a way. The AcquireConnection method requires that the connection object have a connection string. Doing encryption is really not...

Sorry that is a classic problem with SQL Server logins. An option is to encrypt the password in a the config file and decrypt in the SSIS package using SQL...

I commented out a section in the code on how to use SQL Server Auth:

/* Setup connection, this is SQL Server authentication

...

Thanks Philcart!

I really need to look at this powershell someday when I have some free time.

Why don't you post it? I am always interested in multiple ways of doing the same thing. This would only work for SQL Server 2008 and above because...

kimetch (7/6/2010)

---

Although I have sql2005 with SP3 and ssis and sdk installed, I receive "Error the task "script task" cannot run on this edition of integration services. it requires...

You would need...

To use the scriptJobs2005.dtsx file you will need to have SQL Server 2005 installed with BIDS (SQL Server Business Intelligence Development Studio) and the SDKs (the folder C:\Program Files\Microsoft SQL...

I have attached the SQL Server 2005 version just remove the txt file extensions. Let me know if you have any issues. This version will only work on SQL...

I have only been working with this a short time but I found the using the SQL Destination has problems when trying to connect to non-local servers.  I have replaced...