You may find this article interesting.

It describes how you can have best of both worlds: fast loading but selective redirection of records that failed to insert. It requires some extra...

Jason,

At first sight, I don't think there's anything wrong with your strategy. What error do you get? Can you post a screenshot of your package?

I'm still puzzled by your question but I'll give it a shot.

Select a list or tablix in your report and press F4. Look for the propery DataSetName.

Select the DataSet in...

Buy this book: Professional Microsoft SQL Server 2008 Integration Services

You will also find some valuable information on this site: sqlis[/url]

To find the min/max value(s) you can use a Multicast transform and feed one flow to an Aggregate Task.

Write the output to a temporary file (eg RAW).

Add a second Data...

There is no way to do this AFAIK. Either create multiple stored procedures that return one result set each and continu with the Data Flow Task or insert the data...

I'm sorry - I don't understand the question.

Did you try my suggestion?

Change the destination to

"\"C:\\Documents and Settings\\jdgonzalez\\Desktop\\fileMove\\" + @[User::loopFileName] + "\""

and the source to

"\"C:\\Documents and Settings\\jdgonzalez\\Desktop\\" + @[User::loopFileName] + "\""

Why are you still using datepart when you have already done the extraction in your query?

Try this:

=DateSerial(Fields!Year.Value-10, Fields!Month.Value+3,Fields!Date.Value-1)

You may find this[/url] article interesting.

There's a few things to be said about your query but syntactically it is correct.

Where are you getting an error and what does it say?

#1: have a look at the SP [dbo].[sp_ssis_addlogentry]

#2: this is by design; you'll find a workaround here - personally I don't mind about the multiple entries and I never tried...

What is the expression you are using to assign the default value of yesterday to your parameter?

Select the connection manager for the flat file (at the bottom).

Press F4 - this will open the properties pane.

Look for expressions. Click the field on the right and you will...

What does expr3 look like?