Viewing 15 posts - 1,171 through 1,185 (of 3,232 total)
Have you tried what I suggested in my previous post?
Where is your file count variable?
August 10, 2009 at 3:53 pm
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...
August 10, 2009 at 3:51 pm
Duplicate thread, please reply here: http://www.sqlservercentral.com/Forums/Topic766824-148-1.aspx#bm767459
August 10, 2009 at 3:47 pm
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...
August 10, 2009 at 3:18 pm
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...
August 10, 2009 at 3:11 pm
CozyRoc (8/10/2009)
John Rowan (8/10/2009)
CozyRoc (8/10/2009)
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...
August 10, 2009 at 3:02 pm
CozyRoc (8/10/2009)
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...
August 10, 2009 at 1:07 pm
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...
August 10, 2009 at 12:13 pm
CozyRoc (8/10/2009)
John Rowan (8/10/2009)
August 10, 2009 at 11:53 am
CozyRoc (8/10/2009)
John Rowan (8/10/2009)
August 10, 2009 at 11:22 am
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...
August 10, 2009 at 11:09 am
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...
August 10, 2009 at 11:04 am
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...
August 10, 2009 at 10:37 am
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...
August 10, 2009 at 10:18 am
Parthipan (8/9/2009)
Hi John,I will learn more about this, and should i include all the steps(sub tasks) as same like that of control flow, dataflow to alert or ignore any error.
BR,
Parthi
I'm...
August 10, 2009 at 10:13 am
Viewing 15 posts - 1,171 through 1,185 (of 3,232 total)