According to the 2005 dtexec page, the /configfile switch should take precedence over the design-time configurations.

http://msdn.microsoft.com/en-us/library/ms162810(v=SQL.90).aspx

It seems odd to me that the package would actually fail when a configuration can...

I know this is the SQL Server 2005 forum, but people usually post SSIS questions all over the place, so I'll ask to be sure:

is it SQL Server 2005 or...

Great question, thanks!

Logging in SSIS --> right-click on control flow on choose the conveniently named "Logging"

Changing column name --> you can do this in the Flat File Source

Euhm, about moving config data from one place to another:

I usually just script out the data from one environment using SSMS and then modify it slightly to put it on...

What? No recommendation from two living presidents?

:hehe:

You need to set the RetainSameConnection property on the connection manager to TRUE.

edit: oh yeah, also make sure the temp table actually exists when you do the preview

Your question is a bit confusing: you want user input to start a scheduled job? That seems contradictory.

Anyway, look into the stored procedure sp_start_job:

http://msdn.microsoft.com/en-us/library/ms186757.aspx

Be aware that this is an asynchronous...

Regarding poins 2 and 3, see my answer in this thread:

http://www.sqlservercentral.com/Forums/Topic999328-148-1.aspx

Point 1: I don't see an issue with that at first sight. I use it myself from time to time.

opc.three (5/20/2011)

---

Assuming you do not develop in PROD directly how do you manage configuration data when moving a brand new package from DEV to STAGING to PRODUCTION?

Also, how do you...

Check your favorite search provider for the following keywords:

* flat file connection manager

* flat file source

* OLE DB Destination with Fast Load

* For Each Loop

* Filesystem Task

* SSIS Logging

* SSIS...

You can download it seperately for SQL Server Express here:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en

But I don't think it is available seperately for other editions. For those you need the SQL Server installation disk.

Nice question to start the Monday.

Thanks.

You have some good tips there. I'll try them out next year 😀

emil 94400 (5/21/2011)

---

I'm glad you like that questions I tried to make them 'open' as anyone can learn questions and answers but not everyone knowns reasons why one way is...