Table Definition:

CREATE TABLE [dq].[TableX]

(

[MMNUM] [int] NULL

,[MMLIN] [int] NULL

,[MMDES] [nvarchar](70) NULL

...

Ok here is the exec plan using the ShowPlan xml in Profiler. This is a very handy event to use.

I stripped out the query batches that SSIS runs to get...

Sorry for the delayed response here is the profiler output for RPC Complete and TSQL Batch Complete. The commands are being called from an SSIS OLE Source component.

SET FMTONLY ON

select

...

Resolution:

Added a script task in the OnError event handler for the File System Task that sets a variable to indicate that the file should be skipped. Then it sets the...

I read your post but a bit confused on what you are asking.

As for date and time dimensions we have one of each used across all datamarts.

The time dimension has...

hal9000-869914 (1/15/2010)

---

Hi,

I have some kind of SAP export where a lot of columns representing a ratio. In other words each column represents one ratio. Depending on which Dimension keys are...

I'm using SQL 2005 but should work the same.

Once our configs are setup there is no need to alter anything to move from one environment to another.

Basically there is a...

Gail,

I checked out the article when I think back to the profiler output (don't have it in front of me) but it appeared that it may have created a temporary...

Grant Yes they are different the one using the variable is doing a table scan the other an index seek and yes a RID lookup. Don't understand why it can't...

The only other thing I can think of and this really only applies if you have some type of dynamic parameter that could filtering the data and the expression or...

On the OLE Source enter "?" for the begin and end dates then click the parameters button, you can then map those to the variables.

why not just configure the error output to ignore failure. This way it will just out Null for non-numeric data.

Depends what you're returning for a result set. On the Exec SQL task IDE set the result type as either single row or full result set. It's one of the...

I would look into dtutil.exe that may have what your looking for. There's a ton of options available. If the package is password protected then the sensitive data would still...

Phil Church (3/8/2010)

---

I'm trying to move files from one folder to another at the end of several different processes. I want to use a generic SSIS package, but I'm...