Viewing 15 posts - 9,811 through 9,825 (of 11,678 total)
Phil Parkin (3/11/2011)
Or just develop the solution in the technology you feel most at home with.
Hmm, risky recommendation. Not sure I could solve this one using my iPod 🙂
I shall...
March 11, 2011 at 5:21 am
Why don't you store the connectionstring to the configuration table directly in the environment variable?
It is indeed correct that when package configurations do not succeed or are not present, that...
March 11, 2011 at 5:19 am
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
Viewing 15 posts - 9,811 through 9,825 (of 11,678 total)