Viewing 15 posts - 9,811 through 9,825 (of 11,676 total)
john.arnott (3/10/2011)
March 11, 2011 at 5:10 am
That is not an easy question to answer.
SQLBulkCopy is a bulk operation, but so is the OLE DB Destination with Fast Load in the dataflow. Speed can depend on batch...
March 11, 2011 at 3:51 am
Can you post the expression for the ExcelFilePath?
If possible, also the entire connectionstring.
March 10, 2011 at 12:58 pm
Don't worry, I'm not easily offended 🙂
It does indeed make sense to incorporate it in SSIS if it is part of a bigger solution.
March 10, 2011 at 12:33 pm
SQLocity (3/10/2011)
Thanks Koen, that is pretty much the same conclusion that I came to.
Yeah, I can be a bit redundant sometimes 😀
SQLocity (3/10/2011)
March 10, 2011 at 12:30 pm
How did you configure the dynamic connection?
How did you configure the Excel Source component in the dataflow?
March 10, 2011 at 12:16 pm
dg227 (3/10/2011)
Just a thought ... but bad data is still bad data if it's not sent to you in your established/spec format.
And you know what they say:
crap in is crap...
March 10, 2011 at 12:14 pm
BobMcC (3/10/2011)
I suppose it would be an option, but why would I want to?
Well, I don't really see a difference between running a SQL Server Agent job or running an...
March 10, 2011 at 12:06 pm
Anjan Wahwar (3/10/2011)
1. Drag n Drop a script task.
2. Create source n destination ADO.Net connection(Or access...
March 10, 2011 at 7:16 am
Gianluca Sartori (3/10/2011)
GilaMonster (3/10/2011)
I know Steve has removed a couple of threads that people started solely to promote their blogs
OK, so... report this post as well!
I'm so happy to...
March 10, 2011 at 6:25 am
dave-dj (3/10/2011)
Keon, Well done! It appears I had the Force Execution result set to failure! I can only assume it's something I've done in...
March 10, 2011 at 6:21 am
SW_Lindsay (3/10/2011)
This appears to be a problem with SSIS not using escape characters as other parts of the Windows Universe. Any one agree?
Or a problem with people not choosing...
March 10, 2011 at 6:19 am
Jamie Thomson (3/10/2011)
This one may be particularly useful: Visual Studio 2010 SQL Server Database Projects
Thanks for the references!
March 10, 2011 at 6:00 am
You can try the following:
-----> CONVERT(BIT,1) for True
-----> CONVERT(BIT,0) for False
This will return a boolean value instead of a tinyint.
March 10, 2011 at 5:47 am
Viewing 15 posts - 9,811 through 9,825 (of 11,676 total)