Sounds like you could do it in 1 dataflow task this way:

1. First you need 3 connections, 1 to the Excel Source, 1 to the SQL Server, and 1...

GilaMonster (3/4/2009)

---

19 threads in total (including the Answered posts one), mostly a single post...

Based on my understanding of SSIS, you would need to use an Object Data Type as you are returning a ROW not a value.

You can do this (I...

Steve,

I just noticed that there is a rank this thread option when you first enter a thread. What about moving that to a rank this post. That way...

Mangel,

As far as marking posts as answered, sure I see some value in it, but I also have had several experiences where I have posted an answer that will work,...

Grant Fritchey (3/4/2009)

---

Well that one just yacked me off but good. He may as well be quoting from my posts because I'm "guilty" of all the "crimes" he listed. But...

Check this out for xcopy.

Check this out for possible solutions

Any one of the first few results may have the result you need. It appears this is a windows problem...

It would help if you posted the error you are getting.

Have you tried xcopy instead of the GUI?

Is the job running at all?

What is returned if you run a query like this:

SELECT

*

FROM

msdb.dbo.sysjobhistory AS JH JOIN

msdb.dbo.sysjobs...

Check out this article on transaction support in SSIS, http://msdn.microsoft.com/en-us/library/ms137690(SQL.90).aspx. I think it covers what you need.

I agree with Michael. Your approach seems good and creating custom components is not a difficult task if you get to the right resources.

Here is a link to a...

I do it all in SSIS.

Here's a link for how to do it using a Script Component in SSIS:

http://agilebi.com/cs/blogs/jwelch/archive/2007/06/01/xml-destination-script-component.aspx

And here's a place where you can purchase a Custom XML Destination...

I'll throw in a third vote for the stability of SCOPE_IDENTITY(). I have had issues with @@Identity (SQL Server 7) but never with SCOPE_IDENTITY in 2000 or 2005.

I think what you are looking for is Linked Reports. You can create a linked report in Report Manager (http://servername/reports using the default setup). Then in the linked...

No problem.