What do you want exactly with the "last week"?

The week number? The first day of that week? The first and the last day of that week?

One of these days I'll have to learn how to use CROSS APPLY. 😀

That's because I...

timscronin (10/15/2013)

---

He commented you could keep the identity column. If the table already exists and just copying data between databases can you keep the identity value from the originating...

Meaning? Can you give an example?

Larry Johnson-473989 (10/15/2013)

---

I overheard our DBA today (2013-10-17) telling a junior developer to NEVER use a TRY-CATCH block in stored procedures. He told her that it is a very...

Seems a bit like homework.

I didn't test the query because you didn't provide table DDL and sample data, but this might be a step in the right direction:

SELECT

Result = CONVERT(VARCHAR(5),TempResult)...

In the OLE DB Destination, you can check the "Keep identity" property.

A simple data flow transfering data from one server to the other should suffice.

Seems you are getting some sort of time out exception on the webservice?

Ah, it's an expression. That should've been worth mentioning.

"\" " + (DT_WSTR, 4) @[User::ID] + " \" > log.txt"

OK, now add > log.txt to the arguments.

"\" " + (DT_WSTR, 4) @[User::ID] + " \"" > log.txt

This will create a file called log.txt with the output of Report.exe in...

What are the commandline arguments you specified in the Execute Process task?

Maybe you should use unicode? (the nvarchar data type)

venkat113 (10/15/2013)

---

Using Report.exe file render reports from report server and merge into one pdf file, One more thing is working fine in Dev server.

Note:Job is created long time it...

You'll need to read the first line of the file (easiest way is a script task), get the individual column names and create a dynamic CREATE TABLE statement using those...