Viewing 15 posts - 11,071 through 11,085 (of 13,879 total)
If all that you are trying to do is to populate a DateCreated column in your table, why not just create a new datetime column with a default of GetDate()...
October 29, 2011 at 12:34 am
The data conversion task should do the job - are you aware that it creates a new variable (so you need to change your column mappings to use what the...
October 28, 2011 at 8:31 am
This error
component "Excel Destination" (16)" wrote 65535 rows.
is too much of a coincidence. You must be writing to a pre-2007 version of Excel, which can support a maximum of...
October 27, 2011 at 2:23 pm
Not natively.
If you can find a C#/VB solution, we can probably shoehorn it into SSIS somehow.
October 27, 2011 at 2:03 pm
You do this not in the connection manager itself, but when you add a source in your dataflow. You will get the option to set 'Data Access Mode'. Set it...
October 27, 2011 at 8:45 am
Try removing line 255 of the data file and see whether anything changes.
October 27, 2011 at 1:12 am
Note: the post previous to yours is nearly two years old.
October 26, 2011 at 7:35 am
GilaMonster (10/25/2011)
Phil Parkin (10/25/2011)
Clustered index = logical order. Not physical order. Must blog.
Gail, would you consider writing an article about this? It would generate lots of interest, I am sure.
I'll...
October 25, 2011 at 10:18 am
Clustered index = logical order. Not physical order. Must blog.
Gail, would you consider writing an article about this? It would generate lots of interest, I am sure.
October 25, 2011 at 9:48 am
I don't think so. There are custom components available here[/url], including more than one Regex component which looks promising, though I've never used any of them. Rather than doing that,...
October 25, 2011 at 7:48 am
kramaswamy (10/25/2011)
A bit of an uglier solution, ...
Only a bit? 😀
I was thinking along similar lines, but couldn't face writing out all that nesting!
October 25, 2011 at 7:07 am
Yes, you would need to install the Excel stuff on the server in order to manipulate the Excel spreadsheet to the degree you would like.
Personally, I don't like this approach...
October 25, 2011 at 7:00 am
You could add a SELECT LEN() just to verify that.
October 25, 2011 at 5:14 am
Griffster (10/24/2011)
Elliott Whitlow (10/24/2011)
October 24, 2011 at 9:53 am
thulani.moyana 79207 (10/24/2011)
I'm wondering why the single exec('Use database') does not affect the statement immediately after it as I would have thought it is executing on the target database but...
October 24, 2011 at 2:06 am
Viewing 15 posts - 11,071 through 11,085 (of 13,879 total)