Temp tables will work in SSIS, but you have to set the "RetainSameConnection" property of your connection to True. Otherwise new connections will be used for each task and...

I'm not sure I understand what you are asking....

If you have saved the connection string property of your connection managers in SSIS Configurations, and you edit that value in the...

Putts (5/2/2008)

---

anybody have an answer to my question about the connection used to pull Package Configurations.

Have researched everything I can find about using SQL tables for the Configuration but they...

Do all files of the same type have the same record structure? This is important because it will determine a single Data Flow can be defined to handle all...

Is it possible that something is locking the files that you are trying to delete?

If you are executing the SSIS package from the SQL Agent, then it is the SQL Agent service account that will need the proper permissions to the directory, not the...

You would set up each connection in the SSIS Package Connection Manager. Then run the SSIS Package Configurations wizard. It will display the connections you have defined and...

No, as Lowell previously mentioned, you cannot add new Server roles - and I think that is basically what you...

AndrewSQLDBA (8/4/2010)

---

You know, I think the version that I am using here in the office does not have the Breakpoint , Locals and Watch windows.

I am using MS Visual Studio...

Here is a link to a how-to video from Kathi Kellenberger that I just viewed yesterday:

http://www.sqlshare.com/BreakpointsinSSIS_806.aspx

A shortcut I use to view the file is to change the DTSX extension to XML and then drag the file into the IE browser.

princa (7/30/2010)

---

Ed Zann (7/30/2010)

---

If you only want to update specific rows in your sub-table, you would use a SQL Task in the Control Flow and write a standard SQL update...

If you only want to update specific rows in your sub-table, you would use a SQL Task in the Control Flow and write a standard SQL update query.

If you do...

I have not done this, but I would imagine you would use a Script Task and the Excel Object Model to manipulate the font color of cells.

You would...

In my environment, I write the SSIS event information to a log table, so I have not had to capture it as you are asking. However, it appears to...