Change the WHILE condition to:

while(dateadd(d,1,@datetime1) <= @datetime2)

You had it as <> which means does not equal and thats why the last date was not inserted, <= will insert while datetime1...

This can be done by using a CTE (Common Table Expression). There was an article on SQL Server Central about a very similar topic yesterday actually. The code would look...

True, there are no Precedence Contraints on dataflow so my idea would have to happen in the control flow. I have not used your method before and I am trying...

You can write the record counts to variables and then in your Precedence Contraints use expressions that check if the variable is > 0. If not the Data flow task...

Your best option for this would be to create a SSIS/DTS package that exports the data you need for your report.

This is from a previous post.

You arent inserting any values into tbl_TriggerLog, you either need a SELECT or a VALUES clause...

INSERT INTO tbl_TriggerLog(Insert1)

SELECT Value1

FROM Table

I had the same problem last week with the Login box and I resolved this issue by setting the IIS Directory Security settings on the server that hosts the reports....

Try adding a blank script task inside your Foreach loop as the first task to execute, dont put any code in it so that it is just there as a...

Use the OPENXML command... Create a SP that can receive the XML as either text or xml type and then use the OPENXML command. Your code should look something like...

I am not sure if I am missing something from your post... When you create a Flat File connection there is an option to create column names as the data...

I would use a ForEach Loop container that uses the Foreach File Enumerator and assign the filename to a variable. Inside the ForEach loop container, using the filename variable, you...

Use a Flat File Destination and specify the file as comma delimited.

Yes that is correct, that particular step with the incorrect format will fail but the package itself will still complete successfully and not terminate because of the format error.

Hope this...

I use it in a similar situation where we poll a folder for a set of files, if one of files dont exists it will continue to check for the...