pmscorca (7/15/2014)

---

Hi,

I've two SQL databases, the first one having the schema named sch1 and the second one with the schema

named sch2. I need to copy data of more tables belonged...

imani_technology (6/9/2014)

---

I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dashboard. Does this feature include row counts? If not, is there an...

Yes. You might want to review this article by Andy Leonard from the Stairways series on SSIS. It discusses...

Jake Shelton (3/19/2014)

---

<Shortened>

Am importing from a vertical-bar column-delimited CSV file that looks like a heap when open but imports perfectly in DTS.

However I have tried all available...

Two different approaches presented in these articles:

SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers[/url]

SSIS Design Pattern - Read a DataSet From Variable In a Script Task

If these approaches don't...

Must have been typing at the same time you...

Hard to say. If you haven't already done so, consider adding logging to the package. There's a Stairways article about SSIS logging if it's new to you --...

Glad you got it working. 🙂

Try using the system start date [System::StartTime] instead of GetDate(). It's the datetime that the package starts. See http://technet.microsoft.com/en-us/library/ms141788.aspx for more details about system variables.

I'm not sure this will capture everything, particularly if you have multi-column keys, but it should help point you in the right direction. There are probably more complete &...

Glad you were able to get the information--helpful naming conventions! 🙂

It's good to have a bus matrix although more typical to develop it to assist and...

I've used it for other purposes to populate error related variables. Has been a helpful method to capture error information in variables.

AVB (12/17/2013)

---

Is it possible to check what type of precedence constraint actually executed the Script Task from within the script? I'd like to change a user variable based on whether...

Glad you got it to work. 🙂