Viewing 15 posts - 1,186 through 1,200 (of 3,232 total)
I just wanted to say that from an outside observers perspective, that I admire Lynn and Gus's continued professionalism in the face of what has ended up being a landslide...
August 10, 2009 at 10:09 am
That's great. I'm sure it works just fine, but the fact is that this problem is easily solved with tools and techniques already built into SSIS and SQL Server.
I...
August 10, 2009 at 9:54 am
Frank is right on with his advice. SSIS is an ETL tool. You can do all of your validations and transformations inside the data flow before loading the...
August 7, 2009 at 3:16 pm
Gkhadka (8/7/2009)
August 7, 2009 at 3:09 pm
So you've configured your For Each loop to iterate through only the files you want to remove? Use the File System task inside your loop to delete the files.
August 7, 2009 at 3:05 pm
When you are referring to 'the first process', do you mean reading the file in twice using 2 data flows to load your 2 tables? In other words, the...
August 7, 2009 at 2:59 pm
Dynamically building out the BCP command and calling it from SSIS is as good an option as any. Any other way you go, you get bound to having to...
August 7, 2009 at 2:57 pm
Your Xml example did not make it into your post! You may want to use the Preview option next time to ensure your post looks like you want it...
August 7, 2009 at 2:48 pm
Your error is a memory buffer error for SSIS. This is usually because you have a data flow that is handling too much data, your server needs more memory,...
August 7, 2009 at 2:36 pm
So if your package kicks off and there are no files in the folder to process, you want an e-mail sent out? If that's what you're looking for, create...
August 7, 2009 at 2:15 pm
Well, Ken covered the other option, capture the return value of the executing Proc, but I would take it a step further and code it like this:
--Run subproc
DECLARE @err int
EXEC...
August 7, 2009 at 1:41 pm
To notify you via email if your data flow reaches the error condition, I'd create an OnError Event Handler on the data flow task and use the send mail task...
August 7, 2009 at 1:35 pm
Go to Control Panel>>Administrative Tools>>Component Serivces. Expand Component Services>>Computers, right-click on My Computer and Start MS DTC.
August 7, 2009 at 11:12 am
Can't you just set up an Alert (using SQL Server Agent's Alert feature) to monitor the SQL Server: Locks - Number of Deadlocks/sec counter?
August 7, 2009 at 11:01 am
Ah, ha. That is one of the requirements (from the article I posted for you) for running Required transaction option in SSIS. You must have MSDTS service running....
August 7, 2009 at 10:58 am
Viewing 15 posts - 1,186 through 1,200 (of 3,232 total)