Have you tried what I suggested in my previous post?

Where is your file count variable?

BACKUP DATABASE YourDBName

TO DISK = 'your file path and name'

Use SQL Agent to schedule the backup command followed by a CmdExec command to move the file.

What have you...

Duplicate thread, please reply here: http://www.sqlservercentral.com/Forums/Topic766824-148-1.aspx#bm767459

Are you doing anything with the XML data or does it just go from your staging table straight into your destination tables?

So the sole purpose of your package is to...

You can do this from SQL Server, but I would recommend creating the backup locally and then moving it off to another server. This will ensure that the backup...

CozyRoc (8/10/2009)

---

John Rowan (8/10/2009)

---

CozyRoc (8/10/2009)

---

John,

1. I'm talking about this statement: "Dynamically building out the BCP command"

This is requirement to be a programmer.

2. I agree that depending on one component, could...

CozyRoc (8/10/2009)

---

John,

1. I'm talking about this statement: "Dynamically building out the BCP command"

This is requirement to be a programmer.

2. I agree that depending on one component, could cause all your...

Than you can do exactly what I said. Create a data flow. Add a task for to get your source rows, add an OLE DB Destination to insert...

CozyRoc (8/10/2009)

---

John Rowan (8/10/2009)

---

It may just mean that my definition of 'easy' differs from yours. My post previous to your request that I try your product and provide you...

CozyRoc (8/10/2009)

---

John Rowan (8/10/2009)

---

It may just mean that my definition of 'easy' differs from yours. My post previous to your request that I try your product and provide you...

That's a pretty broad question. With no detail on your part to tell us where the data is comming from or what you have to do to it, the...

It may just mean that my definition of 'easy' differs from yours. My post previous to your request that I try your product and provide you with feedback provided...

Does the SELECT.....FOR XML statement create the XML in the format that you were looking for? If so, use the SELECT statement inside a stored procedure. The XML...

I'm glad you posted a reply. I was sure that I had been discussing the same type of tactic in 2 different threads. I found that there is...

I'm...